December 16, 2009 at 6:47 am
Hi All
Yesterday , One of our database goes in suspect mode at 11:00 AM Morning
& we have night 9:00 PM Full Backup of previous day only.
Recovery Model is Full
I know repair allow data loss can repair database but how to recover data deleted ?
Thanks
Ghanshyam
December 16, 2009 at 7:03 am
Do you backup the transaction log? If so, can your restore to point in time just prior to event? If not, then i'd argue it must be because a certain amount of data loss is acceptable, else log backups would be in place
December 16, 2009 at 12:05 pm
Ok, first thing that we need to do, before anything else, is work out why the database is suspect. Can you have a look through the SQL error log, find all the messages relating to this database around the time it went suspect and post them here.
Do Not run a repair at this point. That's the last resort, should all other potential solutions fail.
Do you have backups of this database? Do you have an unbroken chain of log backups for this database?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply