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!!
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2013-01-29 : 23:52:38
Do you have access to the source database of this backup? If so, check the number of VLFs.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

shiyam198
Yak Posting Veteran

94 Posts

Posted - 2013-01-30 : 08:09:00
Thank you so much, both of you.
Go to Top of Page
   

- Advertisement -