How to Get Rid of Standby/Read-Only/Warm-Standby on SQL Server
Here is a simple instruction for doing so:
USE master;
GO
ALTER DATABASE my_database_name SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
GO
ALTER DATABASE my_database_name SET MULTI_USER WITH ROLLBACK IMMEDIATE;
GO
RESTORE DATABASE my_database_name WITH RECOVERY
GO
ALTER DATABASE my_database_name SET READ_WRITE
Here is a simple instruction for doing so:
USE master;
GO
ALTER DATABASE my_database_name SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
GO
ALTER DATABASE my_database_name SET MULTI_USER WITH ROLLBACK IMMEDIATE;
GO
RESTORE DATABASE my_database_name WITH RECOVERY
GO
ALTER DATABASE my_database_name SET READ_WRITE
No comments:
Post a Comment