SQL Server Performance Forum – Threads Archive

how to find space usage in filegroup

Hi Everybody,
I have 2 databases. one is SRC_DB and the other is ARchive_DB.
when my archiving script is trying to archive the tables from source to archive database
few tables were not archived.WHen I tried to find out the reason.The filegroup of those tables did not have enough space in the Archive_DB. so now my question is 1. when i am transfering my table from SRC_db to Archive_DB , how do i check if i have enough memoryin the filegroup of the archive(target) database.. 2. IS there any procedure or query which tells me the USED SPACE,FREE SPACE in a particular filegroup so that i can check before archiving. Thanx
Rajesh.

Run SP_HELPFILE to get information the database files and their sizes. 1) Compare the SRC_db & ARchive_db sizes in order to assure the table transfer will complete. 2)From Query analyzer use sp_spaceused.
From EM, view, taskpad you will find space used and free for each filegroup

quote: Luis Martin

Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

quote:Originally posted by geeth_rajesh
1. when i am transfering my table from SRC_db to Archive_DB , how do i check if i have enough memoryin the filegroup of the archive(target) database..

Why is this a problem? Do you have only limited space?
If not, the file will grow when needed

quote:
2. IS there any procedure or query which tells me the USED SPACE,FREE SPACE in a particular filegroup so that i can check before archiving.

What about sp_spaceused? ———————–
–Frank
http://www.insidesql.de
———————–

Try Using Sp_HelpDB ‘DBNAME’
&
Sp_SpaceUsed Thanks,
Sandip

Also check database properties if filegroups have autogrow.
Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Hi friends… thanx a lot..the tips given were really useful.
-rajesh

]]>