Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Rolling Back a database script

Author  Topic 

robc
Yak Posting Veteran

60 Posts

Posted - 2005-07-20 : 18:16:47
I ran a script to create my DB through Query Analyzer and ended up overlooking a few things that I needed to keep in the existing DB.

So basically it wiped all the info. I do not have a backup because I was just in the midst of setting everything up.

My question is, is there any way to roll back those changes? Can I get that data back?

Please help.

Cheers

Rob

Thrasymachus
Constraint Violating Yak Guru

483 Posts

Posted - 2005-07-21 : 09:48:29
See the note in the signature. Sorry.

Sean Roussy

Please backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own.

I am available for consulting work. Just email me through the forum.
Go to Top of Page

franco
Constraint Violating Yak Guru

255 Posts

Posted - 2005-07-21 : 09:58:24
There is a tool Log Explorer from Lumigent that maybe can do what you need.
http://www.lumigent.com/

Franco
Go to Top of Page
   

- Advertisement -