restore/rollback without backup??

[beechill4]

Hi,

this may seem like a silly question but is there anyway of restoring a live database back to the state it was in on March 31st without having any kind of backup of this database from March 24th to the present day?

 

[mrdenny]

Nope. You have to have a backup in order to restore.

I take it you don't have any log backups?

Even if you have all the logs still in the database, you can back them up, then restore the most recent full, then do a point in time restore and have the logs stop processing at 3/31/06.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[SQLBill]

To use MrDenny's suggestion, you would have had to do a full backup prior to Mar 31st. But as you haven't done ANY backups - you are out of luck.

-SQLBill

Posting advice: FAQ481-4875

 

[beechill4]

thanks folks,

as i expected. not a db i look after by the way!