November 13, 2001 at 10:28 am
Our SQL 7/ SQL 2K accounts database is getting large. I plan to add more physical storage to the server but how do I "extend" the DB to this new drive?
TIA,
Bill
November 13, 2001 at 10:53 am
Take a look at filegroups. Not my favorite solution, but a valid technique. Hopefully you're adding a RAID set and not just a single drive?
Andy
November 13, 2001 at 1:50 pm
Agree with Andy. You would need to use filegorups (or add another file to the default group). Hopefully you are on RAID. If so, your raid controller may support expansion of the existing array.
If not, you can add the new drives and move the whole database to the new drives.
Steve Jones
March 6, 2003 at 6:31 am
I just contributed a script called "Add files to filegroups and log for many dbs" with I use when I add a new SAN-disk and want to expand database filegroups and logs with another file for a large number of databases. The script freezes expansion of the of the old files by setting max size. You can use it for one database or all databases (but master, model, msdb and the demo databases).
Edited by - lge on 03/06/2003 06:33:34 AM
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply