Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rubs_65
Posting Yak Master
144 Posts |
 Posted - 2004-06-30 : 13:15:04
|
| Hi,In our application we are using partition view and tables are partitioned based on month. So we are planning to store each table in separate filegroup and after month ends change the filegroup property to readonly programmatically. But it seems like when I try to run alter database command it try to hold exclusive lock on database and timeouts and since we can't stop the system for this command..is there any way we can force to change the filegroup status as READONLY?Thanks--rubs |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-06-30 : 18:19:22
|
| ALTER DATABASE database SET READ_ONLY WITH ROLLBACK IMMEDIATEMeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
rubs_65
Posting Yak Master
144 Posts |
Posted - 2004-07-01 : 13:08:50
|
| We just need to put particular filegroup in RADONLY mode and not the complete database. we want the users that are using database and accesing the data in other filegroups to be unaffected by this commandThanks--rubs |
|
|
|
|
|
|
Readonly Filegroups