January 27, 2009 at 12:19 pm
When you back up a sql server database and then restore it, is the restored database more efficient (as far as querying)? Does a simple backup (without any options specified) and restore process, reorganize the data and index pages? Does it remove any unused space from the database? I took a backup of a production database and restored it to test and it seems like my queries run faster against the restored test database. We have SQL Server 2000.
Thanks in advance, Kevin
January 27, 2009 at 1:20 pm
kevinsql7 (1/27/2009)
When you back up a sql server database and then restore it, is the restored database more efficient (as far as querying)?
No.
Does a simple backup (without any options specified) and restore process, reorganize the data and index pages?
No.
Does it remove any unused space from the database?
No
Restoring a backup will put the database down exactly as it was when it was backed up
I took a backup of a production database and restored it to test and it seems like my queries run faster against the restored test database. We have SQL Server 2000.
Less contention and blocking from other users?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply