var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Database Recovery
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 input
The 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:
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?
What's your recovery model set to?
Look at this site
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.