SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Running out of space
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

yuvi
Starting Member

3 Posts

Posted - 04/25/2014 :  01:35:47  Show Profile  Reply with Quote
My D Drive is Running out of space.
Is there a way to move the database files without stopping SQL Server.
Database should not go down by any means is it is possible?

James K
Flowing Fount of Yak Knowledge

3719 Posts

Posted - 04/25/2014 :  08:22:50  Show Profile  Reply with Quote
You can't move the database files without setting the database offline. However, you may be able to add another file on another drive - see here: http://technet.microsoft.com/en-us/library/ms189253.aspx

Also, you might want to examine why you are running out of space. Is it legitimate data growth which you may have no control over, or is it perhaps log file growing, which you should be able to control.

Edited by - James K on 04/25/2014 08:23:43
Go to Top of Page

yuvi
Starting Member

3 Posts

Posted - 04/25/2014 :  08:38:11  Show Profile  Reply with Quote
It almost reached the max space of the drive.It is not the problem with the database grwoth.
So if i added N no of .ndf files will it resolve my problem.
How SQL server will let the new transactions to know about the new .ndf file addition?
will it redirect the statements to .ndf files?
Go to Top of Page

James K
Flowing Fount of Yak Knowledge

3719 Posts

Posted - 04/25/2014 :  11:21:20  Show Profile  Reply with Quote
From what I recall, if you add a file to an existing file group, new data written will be distributed proportionate to the space available (in the file, not the disk). Please do look up the documentation to make sure that this is the case. You may only have one file group (PRIMARY) and if so, all the tables will be in that file group. So to allow the data written to those tables to be written to the new disk, create the new file in the primary file group.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.36 seconds. Powered By: Snitz Forums 2000