How to configure and Use Database Backup Compression in SQL Server 2008


Restoring Uncompressed Database Backup
The following TSQL code will restore the SampleDB database from the uncompressed backup and it is completed in 15.9891 seconds

RESTORE FILELISTONLY
FROM DISK = N’D:DatabaseBackupsSampleDB_Uncompressed.Bak’
GO
RESTORE DATABASE SampleDB
FROM DISK = N’D:DatabaseBackupsSampleDB_Uncompressed.Bak’
WITH MOVE N’SampleDB_Data’
         TO N’D:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataSampleDB.mdf’,
MOVE N’SampleDB_Log’
         TO N’D:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataSampleDB_1.ldf’,
RECOVERY,
STATS = 20
GO



Performance Counters to evaluate the Database Backup Compression
The % Processor Time counter of the Processor Object
The % Disk Time counter & Avg Disk Queue Length of the Physical Disk Object
The Device Throughput Bytes/sec counter of the SQLServer:Backup Device object
The Backup/Restore Throughput/sec counter of the SQLServer:Databases object

About the Author
Ashish Kumar Mehta is currently Software Development Engineer at Microsoft. He has been working in IT for over 5 years and with database for over 4 years.

Pages: 1 2 3




Related Articles :

  • No Related Articles Found

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |