Database Restore Speed

  • 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 ...

  • hi,

    why restore? Why not try to get the database out of suspect mode, or find out why it is in suspect mode ?

  • 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

  • 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