Link to home
Create AccountLog in
Avatar of PDSWSS
PDSWSS

asked on

In SQL 2008 R2, how would I undo the restore state produced by mistakenly choosing tail log backup?

In creating a backup of a DB in SQL 2008 R2 Management Studio, I made an error and chose tail log backup, which put the DB in the "restore" state.  Can I undo my mistake without restoring the DB?

Thanks
ASKER CERTIFIED SOLUTION
Avatar of EvilPostIt
EvilPostIt
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of PDSWSS
PDSWSS

ASKER

EvilPostIt:

I am an SQL novice. Could you provide some more details on how I would use your solution. Thanks
You would run this in management studio using a "New Query".

This would bring the database out of its restoring state.
Avatar of PDSWSS

ASKER

To confirm -

1) Highlight the Database that is in the restore state

2)  In new Query          restore database [pharmgen] with recovery

3) click execute.

Is that it?   Thanks
Yes, that is it. Although you dont need to highlight the database in your step 1. This statement is explicitly against the database named in the restore statement already.