December 15, 2003 at 12:29 am
I have a situation where in a production database has been marked suspected by the SQL server. I have tried recovering the database through some methods posted in some other site but of no use. The procedures tend to work when you only have a primary log file but in my case I have a secondary log file also. If somebody has tried recovering a suspected database do revert back.
December 15, 2003 at 5:50 am
I had to do it once. I used he following commands, maybe they can help.
sp_resetstatus 'dbname'
dbcc dbrecover (dbname)
and DBCC Rebuild_log (dbaname) bacause my log was damaged.
December 17, 2003 at 3:21 pm
Yesterday, I found a suspect DB. The drive had disappeared after a server cycle and
the log file was missing. I performed a restore from the last backup and pointed the log portions to a new location.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply