Hi,
Is there a way to Revover a Sql Server 2000 database in the absence of the backup file(the backup file got overwritten). Does Sql Server do any automatic Transaction logging?
Thanks for any inputThe short answer...you need a dump..
Abd yes sql server is constantly creating transactions for every event (even if they're not fully logged)
What's the problem?
database fall down and go boom?
Check this out:
http://www.sqlteam.com/item.asp?ItemID=11672|||The database was overwritten with some old data and by the time this was realised the backup got overwritten with this old data. There are no transactions logs either. Only a full Database backup taken every day.
Is there any hope of recovering at all?
Thanks|||What's your recovery model set to?
Look at this site
http://www.lumigent.com/|||Lumigent LOG EXPLORER!!!!
Probably the best third party product available for SQL Server 2000
it has single-handedly discontinued the STOPAT clause from the BACKUP statement.
No comments:
Post a Comment