Issue with SQL Server 2008 R2 SP2: Database restore

By reddo6199
Dec 11, 2014
Post New Reply
  1. Hi All,

    I've recently rebuilt a server for our Reports Database, installed SQL Server R2 2008 and updated to SP2. Installed all the preqs. However when restoring our test database, it takes forever to restore, literally hours. Is there something I missed? Any suggestions would be greatly appreciated.

    many thanks in advance

  2. jobeard

    jobeard TS Ambassador Posts: 11,174   +989

    First, investigate the technique being used: A binary image restore of the files OR just a plain SQL REPLACE. The binary restore is not the default, so I am afraid you're into the slow route.
    Make sure you are not doing record at a time and are using the batch mode

    If there's 1000's of records, ditch the indices:

    DELETE all secondary indicies from every table (keep the definitions obviously)
    Then RESTORE - - the base tables will fill much faster.

    When done, update the schemas to add back the indices, and you can then write
    SQL recreate the index data from the base tables.
    Being the SQL-DBA is fun :sigh:

Similar Topics

Add your comment to this article

You need to be a member to leave a comment. Join thousands of tech enthusiasts and participate.
TechSpot Account You may also...