Posted onJanuary 3, 2011 by Josephine syntax to restore database in NORECOVERY mode run this sql: RESTORE DATABASE databasename WITH RECOVERY