[ms sql 2000] Cancel the Restore process

[mar_zim]

Hi guys good day. I have this problem that I accidentally press the ok button for restoring database, w/out knowing I cancel the restore process so that the current data will not replace w/ the backup data but the problem the database became idle(gray cylinder instead of yellow). When I right click the database and see the properties it throws an error "Error 927: Database 'xxx' cannot be opened. It is in the middle of a restore". I thought when you cancel the restore process there is nothing happend to the database. How can I get the current data and not the backup data to put in the database?


Thanks in advance guys.

[szlamany]

I believe that most of us would be guessing here at this question.

If you truly need to get the database back to the "pre-restore" moment - then go to this site and ask them...

http://www.microsoft.com/technet/com...lserver.server