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.
]]>