July 22, 2010 at 10:40 pm
Guys,
If I don't want any 'data loss' and want to recover the database from Suspect mode, well, how to do it? Moreover, I don't have any 'backup' of the database also...
Note: DBCC Checkdb () has three options::
REPAIR_ALLOW_DATA_LOSS | REPAIR_FAST| REPAIR_REBUILD
None of the option, talk about to retrieve the entire piece of data.
any suggestion friends?
Thanks.
July 23, 2010 at 2:33 am
The only way you can guaranteed recover a suspect database with no data loss is to restore from a backup. Since you have no backup, you are potentially looking at data loss to get it back, no way around that.
Is this an academic question, or do you have a suspect database without a backup?
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
July 23, 2010 at 2:49 am
First check whether the database is truly suspect or not.... Can we repair it...??? What errors u r getting when u run DBCC CheckDB???
Then only we can come to know upto what extent we can recover the daatabase...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply