Skip to main content
Help

Current version by: John Walker ,

Text:

Execute the following query
 
''ALTER
ALTER
DATABASE test
''ALTER
ALTER
DATABASE test
 
SET emergency
 
GO
 
ALTER DATABASE test
 
SET single_user
 
GO
 
DBCC checkdb (test, repair_allow_data_loss)
 
ALTER DATABASE test
 
SET multi_user
 
GO''GO
GO''GO
 
BUT be careful: REPAIR_ALLOW_DATA_LOSS means that some data might be lost in the DB even if it attached successfully. If you want to recover your data without any loss then you must go with third party [http://www.sqlmdfviewer.org/recovery/|SQL MDF Recovery Tool]

Status:

open

Original post by: John Walker ,

Text:

Execute the following query

''ALTER DATABASE test

SET emergency

GO

ALTER DATABASE test

SET single_user

GO

DBCC checkdb (test, repair_allow_data_loss)

ALTER DATABASE test

SET multi_user

GO''

BUT be careful: REPAIR_ALLOW_DATA_LOSS means that some data might be lost in the DB even if it attached successfully. If you want to recover your data without any loss then you must go with third party [http://www.sqlmdfviewer.org/recovery/|SQL MDF Recovery Tool]

Status:

open