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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-09-12 : 10:47:00
|
| Marjo writes "Hi:My sqlserver DB is online for 24hrs. And at present the Restrict filegrowth is 50MB but I want to make it 70MB so is it possible to change it directly or should I stop the DB, change it and then start the DB again??Thanx in anticipation.Marjo." |
|
|
solart
Posting Yak Master
148 Posts |
Posted - 2002-09-12 : 11:22:24
|
| Change it directly. But be aware that file expansion is accompanied by SQL Server activity that I would liken to a format process. This process may temporarily impact queries. So best to pick as slow a time as you can for your online system.solart |
 |
|
|
|
|
|
URGENT - To Change the Restrict FileGrowth option Do I have to Stop the DB??