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 11:20 pm

    #1559973

    bugg (11/16/2012)

    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?

    No ,database will not go offline till there users connected to it.

    -----------------------------------------------------------------------------
    संकेत कोकणे