Home Forums SQL Server 2008 SQL Server Newbies Automated Database Restore script for Reporting DB RE: Automated Database Restore script for Reporting DB

  • November 16, 2012 at 5:53 am

    #1559756

    I will Recommend you to go through this topic.

    http://www.sqlservercentral.com/Forums/Topic1063979-1237-1.aspx

    EDIT : Forgot to put URL

    Thanks , I've had a read through and may use the kill script, I changed my code to read the below but I might run the kill script as mentioned in those posts alter DB may not be available.

    --Take DB offline

    ALTER DATABASE Test_DB SET OFFLINE WITH ROLLBACK IMMEDIATE