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 |
|
alejo46
Posting Yak Master
157 Posts |
 Posted - 2014-04-15 : 21:31:57
|
| good eveningI need your help please, im new at SQL Sever, and there are n filegroups which for example one is named htrellesms2 which is 22 % free space and Total space is 1254480,and the other FG named prece1 is 2 % free space and total space is 1002503Isnt it possible our DBA balance those filegroups ? i mean reallocate some space for the filegroup which has more available space to the FG which is about to run out of space ?If so, which isues should be considered ? 2. which method will be used for our DBA ? by TSQL commands ?Thanks for your help in advanced |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2014-04-16 : 18:23:40
|
| From the scenario as you described it there are several options:If there is space available on the drive(s) where the prece1 file(s) reside and at least one file is allowed to grow, the system will automatically add more disk space to the file(s) as needed.If there is file space available on the server on another drive, a new file could be added to the prece1 filegroup on that other drive.If the files in both filegroups are on the same drive and there is no room for growth, you could shrink the file(s) in htrellesms2 and make sure the prece1 file(s) are allowed to grow.As to the question of how to do it, its really personal preference. Some are more comfortable with SQL scripts; others like to convenience of the SSMS interface.HTH===============================================================================“Everyone wants a better life: very few of us want to be better people.” -Alain de Botton |
 |
|
|
alejo46
Posting Yak Master
157 Posts |
Posted - 2014-04-18 : 16:03:40
|
| OK Thanks for your help, but ive got 2 questions: how do i know the drive(s) where the file(s) reside on, and how do i know the file(s) are allowed to grow ?are there any special tsql command s ? if so which are besides sp_helpdb ?Thanks for your help |
|
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2014-04-18 : 17:45:22
|
| There is SQL code but SSMS is easier. Right click the database -> Properties -> Files. The Autogrowth, Path and File Names are visible and editable. This also shows the filegroup the file is in. You can find which filegroup a table is in by right clicking the table -> Properties -> Storage.===============================================================================“Everyone wants a better life: very few of us want to be better people.” -Alain de Botton |
|
|
|
|
|
|
Balance a filegroup that run out of space