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.