Issue with SQL Server 2008 R2 SP2: Database restore

[reddo6199]

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

Dre

 

[DelJo63]

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: