Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Add a Database file to an existing database Expand / Collapse
Author
Message
Posted Monday, November 4, 2013 1:07 PM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Monday, August 18, 2014 10:12 AM
Points: 750, Visits: 1,556

I inherited an old SQL Server 2000 instance running 8.00.239 (SQL Server 2000 Enterprise edition / Sp4)

One of the Databases (created back in 2007) has it's Data and log files on the C: Drive. Obviously this is not ideal - having the DB files on the same partition as the operating system - and I have already moved the logfile off to another drive.

My Data File however is 25GB and I do not have enough room on the other drive to move it so I am thinking I need to add another datafile and set the datafile on the C: drive to stop growing.

My plan is to add an additional Datafile, but I have a couple of questions:

1 - should this second datafile be in the primary file group ?

2- what settings do I have to change in order for any growth to stop happening in the datafile that resides on the C drive?

Thanks in advance




Post #1511266
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse