Archive for July, 2007

Getting DB out of Read-Only mode

ALTER DATABASE DB_Name SET READ_WRITE WITH ROLLBACK IMMEDIATE — take it out of read-only mode
ALTER DATABASE DB_Name SET READ_ONLY WITH ROLLBACK IMMEDIATE — make it read-only again

Sunday, July 1st, 2007

Posted in sql | No Comments »