SQL Server 2005 - Restore with NoRecovery worked but still shows Restoring?

sbornstein2
sbornstein2 used Ask the Experts™
on
I just did a backup and then restore with norecovery because I am trying to setup mirroring which is a royal pain.  It successfully did the restore where I had the MOVE option to place the files where I wanted them.  But the database now still shows restoring and it won't go away.  Any ideas?  I then need to deal with the rest of the mirror with the port etc. which I have no clue? lol  This was my tsql that worked fine:

RESTORE DATABASE SGIKB
FROM DISK='E:\SQLBackup\SGIKBSEAN.bak'
WITH NORECOVERY,
MOVE 'SGIKB_Data' TO
'E:\SQLData\SGIKB_Data.mdf',
MOVE 'SGIKB_Log' TO
'E:\SQLLog\SGIKB_Log.ldf';
GO
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Awarded 2008
Awarded 2008
Commented:
Yep, that is what norecovery does...will show that way until it is recovered.

Author

Commented:
so for setting up mirroring how does this work because when i select mirror it says the database is being restored still?

Author

Commented:
the first step was to restore the database with the norecovery option

Author

Commented:
oh wait forget it I get it,  I have to do the mirror on the principal.  Cool thanks again

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial