SQL SERVER – Making Database to Read Only – Changing Database to Read/Write

I recently received following comments on my earlier blog:

“Today i was trying to attach the (MDF,NDF,LDF ) sql server 2008 database which i have received from my client. After attachment the database status is showing (Read-Only) (Eg.database name (Read-Only). How do i make to normal mode for the data updation. is there any query available to resolve this problem. Your help will be highly helpful.”

Here is the answer:

Make Database Read Only

USE [master]

GO

ALTER DATABASE [TESTDB] SET READ_ONLY WITH NO_WAIT

GO

Make Database Read/Write

USE [master]

GO

ALTER DATABASE [TESTDB] SET READ_WRITE WITH NO_WAIT

GO

If you face error that if database is already in use, you can resolve the same by making database in single user mode – here is the guideline SQL SERVER – ALTER DATABASE dbname SET SINGLE_USER WITH ROLLBACK IMMEDIATE.

Read more: Journey to SQLAuthority

Posted via email from Jasper-net