In this article, we’ve discussed different types of backups in SQL Server and how to create these backups. We also discussed the ways to restore database backups using SSMS and T-SQL commands. In case ...

This article is a revised version of the original published January 3, 2005. See Editor’s Note for details. Two major factors drive database backups these days: compliance and disk space. Some ...

The tool scans the SQL database (MDF/NDF) file and displays all the database objects, including the deleted records. You can then select and save the deleted records in a new database file. This helps ...

SQL Server 2005 or later script to generate TRUNCATE statements for all tables. Anyone that has tried this on anything but the most simplistic database has found, as I did, that this won't work. Any ...

Our server group wants to take over our SQL Server 05 backups for some reason. (Not sure why, our backups and restores work fine, so who knows why they want the change)<BR><BR>Anyway, came into ...

Joey on SQL Server. The Right Approach to Database Backups. Elaborate backups might seem like a good idea at first, but they add unnecessary complexity to your recovery process.

Idera’s SQLsafe — a backup utility for Microsoft SQL Server — was designed to compete directly with Imceda’s LiteSpeed. Similar to LiteSpeed, SQLsafe improves on native SQL Server backups ...

With SQL Server 2000, there are myriad choices for backing up your database. Whether your database is small and changes infrequently or very large and changes rapidly, there is a backup strategy ...

Deleting all Data from a SQL Server Database (Part 2) ... I described a scenario in which I needed to empty all the data from a copy of a large database on a remote server, in order to download a ...

Database backup and recovery is becoming more difficult and complicated, ... Here it is: the dedicated array will pay for itself by eliminating the need for backup agents on each SQL Server.