Restoring a Compressed DB Backup is taking long

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

Restoring a Compressed DB Backup is taking long

Author

Topic

shiyam198
Yak Posting Veteran

94 Posts

Posted - 2013-01-29 : 22:50:04

Hi,

I took a backup of a database with "Compressed" selected in "set backup compression".

When I restore it is taking 6 hours for a backup that usually take an hour without compression. Should I be worried?

I used the following command

Regards,
Shiyam


restore database DBBlah
from disk='D:\Shiyamtemp\DBBlah_Jan29.bak' 
WITH MOVE 'DBBlah_Data' TO 'D:\SQLDATA\DBBlah_Jan29.mdf',
MOVE 'DBBlah_Log' TO 'D:\SQLDATA\DBBlah_Jan29.ldf',
replace, recovery, stats=5, maxtransfersize=1048576

This is where it is stuck for atleast 4 hours.


75 percent processed.
80 percent processed.
85 percent processed.
90 percent processed.
95 percent processed.
100 percent processed.
Processed 6162912 pages for database 'DBBlah', file 'DBBlah_Data' on file 1.
Processed 1 pages for database 'DBBlah', file 'Blazon_Log' on file 1.

Tried in 2 different database servers, same deal. Please let me know if this could be an issue?

- Shiyam

prett
Posting Yak Master

212 Posts

Posted - 2013-01-29 : 23:10:25

Please check this post: http://blog.sqlauthority.com/2011/12/28/sql-server-effect-of-compressed-backup-setting-at-server-level-on-database-backup/

Hope it will help you to understand your issue!!