February 13, 2010 at 9:54 am
Hi Guys,
While doing some backup and restore operations on the test servers i observed that Restore operation is taking long time than the backup operation for the same 50 GB .bak file.
Can any one let me know what exactly the restore command will perform in the background and why it is taking long time to complete.
Regards
Sandhya
February 13, 2010 at 4:44 pm
Its normal for a restore to take 5-10% longer than a backup.
what sort of time difference are you seeing?
---------------------------------------------------------------------
February 13, 2010 at 5:34 pm
The restore will take longer. A restore will "zero" out the data file and grow it if necessary. Due to this kind of IO it should take longer than the backup command.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 13, 2010 at 11:32 pm
Hi,
Thanks for the reply.
Can you elaborate what exactly the restore will do internally.(Internal process)
Regards,
Sandhya
February 14, 2010 at 12:20 am
Article from Microsoft
http://msdn.microsoft.com/en-us/library/ms190954.aspx
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 14, 2010 at 9:57 am
CirquedeSQLeil (2/13/2010)
The restore will take longer. A restore will "zero" out the data file and grow it if necessary. Due to this kind of IO it should take longer than the backup command.
You can eliminate this step of the restore operation by enabling instant initialization. This is enabled by default for the local system account and users in the Administrator group, but I would not recommend adding your service account to the administrators group.
You can enable instant initialization in local policies by adding the service account to the perform volume maintenance right.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 14, 2010 at 9:59 am
Hi,
Many thanks for the post.
The article clarified all my doubts.
Regards,
Sandhya
February 14, 2010 at 3:32 pm
Jeff - nice followup
sandhyarao49 - you're welcome.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply