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 |
|
clement.store
Starting Member
25 Posts |
 Posted - 2010-05-05 : 22:38:27
|
| Dear all,The physical disk which the DB resides on is nearly full.I want to add a new HD for this expansion. Would there be any script oradvice that can achieve this expansion.Help Appreciated.Clement |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-05-06 : 02:17:21
|
If the LOG and DATA files are on the same drive then you might get enough space by just moving the LOG to the new drive. That will be better for performance too (particularly if the RAID is optimised for sequence access for the LOG< and random access for the DATA)Moving TEMPDB would be the next step I reckon.Depends a bit on the relative sizes of the various DBs' files.Is MSDB big? If so it probably needs purging (not something that happens automatically, unless you set something up  ) |
 |
|
|
|
|
|
Physical disk full....Split DB into 2...?