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 Development (2000)
 Roll back

Author  Topic 

stephenodoi
Starting Member

1 Post

Posted - 2011-06-03 : 03:46:45
We have 2 servers 1 is live and the other test. A colleague backed up the sql database from the live and restored it on the test without backing up the test. can the test be rolled back to the state before? we had a test going on before this happened and this has changed everything. Any help?

nigelrivett
Master Smack Fu Yak Hacker

3385 Posts

Posted - 2011-06-03 : 04:55:34
No. Not without a backup.

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -