Home Forums SQL Server 2005 Backups full and differential backup RE: full and differential backup

  • April 17, 2013 at 9:55 am

    #1607311

    Are you trying to restore on a top of database which already exists?

    If yes then use:-

    Alter database <DBNAme> set offline with rollback immediate

    go

    alter database <DBNAme>set online

    go

    restore command