Home Forums SQL Server 2005 Backups Restore with no data RE: Restore with no data

  • December 6, 2007 at 10:11 am

    #757760

    As Scott said, RESTORE DATABASE dbname WITH RECOVERY, this will remove the database from a recovering state. Delete the database. Then restore from backup.


    My blog: http://jahaines.blogspot.com