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 |
|
yuvi
Starting Member
3 Posts |
 Posted - 2014-04-25 : 01:35:47
|
| 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
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2014-04-25 : 08:22:50
|
| 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.aspxAlso, 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. |
 |
|
|
yuvi
Starting Member
3 Posts |
Posted - 2014-04-25 : 08:38:11
|
| 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? |
|
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2014-04-25 : 11:21:20
|
| 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. |
|
|
|
|
|
|
Running out of space