July 29, 2009 at 11:46 pm
Hi
All,
Database Restore Speed
I have question about the restoration speed of database, I have two scenarios
1) Fresh (New) database restore in instance (The database is in suspect mode so I have planned to drop suspected database and restore it as new)
2) Restoring the database with replace option. (If there is database and the database is in suspect mode)
----which operation is speed.
Thanks and regards.
ashwin vp
Ashwin VP
CSC India ...
July 30, 2009 at 5:21 am
hi,
why restore? Why not try to get the database out of suspect mode, or find out why it is in suspect mode ?
July 30, 2009 at 6:50 am
To answer the question, it's going to be approximately a wash. Replace acts as a drop & recreate.
But, I'd suggest pursuing what happened as well. What do the consistency checks say.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 30, 2009 at 11:52 am
Why restore database for suspect database. Try to find the status of database in sysdatabases table. I had a situation before and status was 8 and when doing some google I got to a thread where it mentioned to change the value to 24. Database came back online. DB was suspect because of an open transaction and no disc space left.
SQL DBA.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply