Wednesday, January 20, 2016

suddenly my SQL Server DataBase turn in to restoring mode




suddenly my SQL Server  DataBase turn in to restoring mode, reason was it is executing in
transactions and creating large log files and there was less space in server so limbo condition was created. I restated the SQL Service and it convert db in restoring mode.
to make in normal I executed follwoing commands.
USE master;
GO
ALTER DATABASE M11272015BACKUP 
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE;
GO
ALTER DATABASE M11272015BACKUP
SET READ_ONLY;
GO
ALTER DATABASE M11272015BACKUP 
SET MULTI_USER;
GO
ALTER DATABASE M11272015BACKUP
SET READ_WRITE WITH NO_WAIT
GO

Note: If it is still in restore mode use
RESTORE DATABASE M11272015BACKUP WITH RECOVERY


No comments: