Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Modify filegroup to readonly in multi user mode Expand / Collapse
Posted Wednesday, March 27, 2013 9:39 AM


Group: General Forum Members
Last Login: Tuesday, June 23, 2015 5:14 PM
Points: 125, Visits: 756
I have a 2 TB database with multiple filegroups. These filegroups are divided based on the datetime. I am planning to convert some of the file groups to read only. Can I do it when the database is in multi user mode or do i have to take the database to single user mode. I tried to do it on a small database which worked, but on a 2 TB database I am just hesitate to move forward.
Post #1435990
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse