Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Wednesday, March 27, 2013 9:39 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, January 21, 2014 8:49 AM
Points: 116, Visits: 713
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