robymon78 (9/7/2011)

---

I need to Restore the Database with NoRecovery, when i did like this, Database is showing in Restore State, can't do anything for the Database. I am doing the Database Mirroring, for this i need to Restore the DB with NoRecovery.

Following is the sql i used to restore the database, Please check this sql and tell me any mistake in this sql.

RESTORE DATABASE Test FROM DISK = N'D:\DB\Test.bak' WITH FILE = 1, MOVE N'Test' TO N'D:\SQL_Files\Test.mdf', MOVE N'Test_log' TO N'D:\SQL_Files\Test_log.ldf', NORECOVERY,REPLACE, NOUNLOAD, STATS = 10

GO