sp_configure 'allow updates', 1 Reconfigure with override
sp_resetstatus 'crm'
sp_configure 'allow updates', 0 Reconfigure with override
restart sql service
If the databse is still suspect put it into emergency mode and extract the data
sp_configure 'allow updates', 1 Reconfigure with override
UPDATE master..sysdatabases SET status = 32768 WHERE name = 'DatabaseName'
restart sql service
Should now be able to use DTS or BCP to get the data out
No comments:
Post a Comment