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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Balance a filegroup that run out of space

Author  Topic 

alejo46
Posting Yak Master

157 Posts

Posted - 2014-04-15 : 21:31:57
good evening
I 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 1002503

Isnt 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
Go to Top of Page

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
Go to Top of Page

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
Go to Top of Page
   

- Advertisement -