Home Forums SQL Server 2008 SQL Server Newbies Automated Database Restore script for Reporting DB RE: Automated Database Restore script for Reporting DB
bugg
SSCertifiable
Points: 7567
More actions
November 16, 2012 at 9:05 am
#1559845
Cheers I Have used the with restore, and changed from
SET SINGLE_USER WITH
ROLLBACK IMMEDIATE
TO
ALTER DATABASE Test_DB SET OFFLINE WITH ROLLBACK IMMEDIATE
Do you think this will suffice?