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:
Post a Comment