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 |
|
drsloat
Starting Member
45 Posts |
 Posted - 2008-01-09 : 15:38:33
|
| My primary (and only) data file has reached the point where it is auto growing. I would like to grow this file in one big chunk at an off peak time. I can't seem to find the code I need to make the file grow when I want it to? |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2008-01-09 : 15:45:19
|
| you could use the ALTER DATABASE command (http://msdn2.microsoft.com/en-us/library/ms174269.aspx) and schedule it to run once using SQLAgent at the off-peak time.-ec |
 |
|
|
|
|
|
Proactively Grow Data File Size