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)
 Balance a filegroup that run out of space
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

alejo46
Posting Yak Master

Colombia
127 Posts

Posted - 04/15/2014 :  21:31:57  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

USA
1641 Posts

Posted - 04/16/2014 :  18:23:40  Show Profile  Reply with Quote
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

Edited by - Bustaz Kool on 04/16/2014 18:26:15
Go to Top of Page

alejo46
Posting Yak Master

Colombia
127 Posts

Posted - 04/18/2014 :  16:03:40  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

USA
1641 Posts

Posted - 04/18/2014 :  17:45:22  Show Profile  Reply with Quote
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
  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.06 seconds. Powered By: Snitz Forums 2000