Home Forums SQL Server 2005 T-SQL (SS2K5) Fatal error 824 RE: Fatal error 824
mobile
SSC Enthusiast
Points: 107
More actions
November 18, 2008 at 10:45 am
#900078
- hacer new query en master.
- alter database dbname set emergency
- ALTER DATABASE DBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
- dbcc checkdb ('dbname', repair_allow_data_loss)
- alter database dbname set multi_user
saludos