how to recover or repair database

Published: 24 March 2022
on channel: timeoutexpired
49
0

use master
--to recover/repair Database, try below queries
EXEC sp_resetstatus 'yourDBName';
ALTER DATABASE yourDBName SET EMERGENCY
DBCC CHECKDB ('yourDBName')
ALTER DATABASE yourDBName SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CHECKDB ('yourDBName', REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE yourDBName SET MULTI_USER


Watch video how to recover or repair database online without registration, duration hours minute second in high quality. This video was added by user timeoutexpired 24 March 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 49 once and liked it 0 people.