Primary filegroup is full error!

Hi everybody,
I developing a database solution currently 22GB with 4.5GB datafiles.
I ran into below error and can't figure out how to work around it.
"Error 1105: Could not allocate space for object '(SYSTEM table id: 8)' in
database 'fasion_spring04' because the 'PRIMARY' filegroup is full.
Extending database by 1.00 MB on disk 'fashion_018'
I have created a second filegroup called "images" but even when I add a
datafile to the "images" filegroup I get this error.
Any idea how to resolve this.
Thanks in advance
Christian> I have created a second filegroup called "images" but even when I add a
> datafile to the "images" filegroup I get this error.
No data will go to the second filegroup until you explicitly create a table
on that filegroup.
What you should probably do is add a second file to the primary filegroup,
on a different drive with plenty of free space. Then, you should sit down
and decide where this is going to live, because obviously it is outgrowing
its current environment.
http://www.aspfaq.com/2446 (this isn't just for tempdb)
http://www.aspfaq.com/2471

Primary filegroup is full error!

Hi everybody,
I developing a database solution currently 22GB with 4.5GB datafiles.
I ran into below error and can't figure out how to work around it.
"Error 1105: Could not allocate space for object '(SYSTEM table id: 8)' in
database 'fasion_spring04' because the 'PRIMARY' filegroup is full.
Extending database by 1.00 MB on disk 'fashion_018'
I have created a second filegroup called "images" but even when I add a
datafile to the "images" filegroup I get this error.
Any idea how to resolve this.
Thanks in advance
Christian
> I have created a second filegroup called "images" but even when I add a
> datafile to the "images" filegroup I get this error.
No data will go to the second filegroup until you explicitly create a table
on that filegroup.
What you should probably do is add a second file to the primary filegroup,
on a different drive with plenty of free space. Then, you should sit down
and decide where this is going to live, because obviously it is outgrowing
its current environment.
http://www.aspfaq.com/2446 (this isn't just for tempdb)
http://www.aspfaq.com/2471

Primary filegroup is full error!

Hi everybody,
I developing a database solution currently 22GB with 4.5GB datafiles.
I ran into below error and can't figure out how to work around it.
"Error 1105: Could not allocate space for object '(SYSTEM table id: 8)' in
database 'fasion_spring04' because the 'PRIMARY' filegroup is full.
Extending database by 1.00 MB on disk 'fashion_018'
I have created a second filegroup called "images" but even when I add a
datafile to the "images" filegroup I get this error.
Any idea how to resolve this.
Thanks in advance
Christian> I have created a second filegroup called "images" but even when I add a
> datafile to the "images" filegroup I get this error.
No data will go to the second filegroup until you explicitly create a table
on that filegroup.
What you should probably do is add a second file to the primary filegroup,
on a different drive with plenty of free space. Then, you should sit down
and decide where this is going to live, because obviously it is outgrowing
its current environment.
http://www.aspfaq.com/2446 (this isn't just for tempdb)
http://www.aspfaq.com/2471

Primary filegroup

Hi
I have a database with 3 datafiles :
file1 => filegroup primary
file2 => filegroup primary
file3 => filegroup index_data
Now I want to delete the file2. Is that possible ' I get the message that
the file is not empty. How can I determine what data is in the file ?
Regards
GeneYou need to empty it first using DBCC SHRINKFILE with the EMPTYFILE option.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Gene Vangampelaere" <gene.vangampelaere.remove.this@.infohos.remove.this.be> wrote in message
news:e5GdaAfVFHA.3716@.TK2MSFTNGP12.phx.gbl...
> Hi
> I have a database with 3 datafiles :
> file1 => filegroup primary
> file2 => filegroup primary
> file3 => filegroup index_data
> Now I want to delete the file2. Is that possible ' I get the message that the file is not empty.
> How can I determine what data is in the file ?
>
> Regards
> Gene
>|||thx !!!
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> schreef
in bericht news:OyG65IfVFHA.1200@.TK2MSFTNGP14.phx.gbl...
> You need to empty it first using DBCC SHRINKFILE with the EMPTYFILE
> option.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Gene Vangampelaere"
> <gene.vangampelaere.remove.this@.infohos.remove.this.be> wrote in message
> news:e5GdaAfVFHA.3716@.TK2MSFTNGP12.phx.gbl...
>> Hi
>> I have a database with 3 datafiles :
>> file1 => filegroup primary
>> file2 => filegroup primary
>> file3 => filegroup index_data
>> Now I want to delete the file2. Is that possible ' I get the message
>> that the file is not empty. How can I determine what data is in the file
>> ?
>>
>> Regards
>> Gene
>|||Hi,
To do this, use the DBCC SHRINKFILE with EMPTY FILE option for the NDF file
This will empty the file and mark it as unavailable. After this use ALTER
DATABASE.. REMOVE FILE option to remove the NDF file.
Steps:
1. Take a database backup
2. Use database_name
go
DBCCSHRINKFILE('NDFFILE_name',­'EMPTYFILE')
3. Use ALTER database to Remove the file
ALTER DATABASE <DBNAME> REMOVE FILE 'logical ndf file name'
Thanks
Hari
SQL Server MVP
"Gene Vangampelaere" <gene.vangampelaere.remove.this@.infohos.remove.this.be>
wrote in message news:e5GdaAfVFHA.3716@.TK2MSFTNGP12.phx.gbl...
> Hi
> I have a database with 3 datafiles :
> file1 => filegroup primary
> file2 => filegroup primary
> file3 => filegroup index_data
> Now I want to delete the file2. Is that possible ' I get the message that
> the file is not empty. How can I determine what data is in the file ?
>
> Regards
> Gene
>

Primary filegroup

Hi
I have a database with 3 datafiles :
file1 => filegroup primary
file2 => filegroup primary
file3 => filegroup index_data
Now I want to delete the file2. Is that possible ? I get the message that
the file is not empty. How can I determine what data is in the file ?
Regards
Gene
You need to empty it first using DBCC SHRINKFILE with the EMPTYFILE option.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Gene Vangampelaere" <gene.vangampelaere.remove.this@.infohos.remove.thi s.be> wrote in message
news:e5GdaAfVFHA.3716@.TK2MSFTNGP12.phx.gbl...
> Hi
> I have a database with 3 datafiles :
> file1 => filegroup primary
> file2 => filegroup primary
> file3 => filegroup index_data
> Now I want to delete the file2. Is that possible ? I get the message that the file is not empty.
> How can I determine what data is in the file ?
>
> Regards
> Gene
>
|||thx !!!
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> schreef
in bericht news:OyG65IfVFHA.1200@.TK2MSFTNGP14.phx.gbl...
> You need to empty it first using DBCC SHRINKFILE with the EMPTYFILE
> option.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Gene Vangampelaere"
> <gene.vangampelaere.remove.this@.infohos.remove.thi s.be> wrote in message
> news:e5GdaAfVFHA.3716@.TK2MSFTNGP12.phx.gbl...
>
|||Hi,
To do this, use the DBCC SHRINKFILE with EMPTY FILE option for the NDF file
This will empty the file and mark it as unavailable. After this use ALTER
DATABASE.. REMOVE FILE option to remove the NDF file.
Steps:
1. Take a database backup
2. Use database_name
go
DBCCSHRINKFILE('NDFFILE_name',X'EMPTYFILE')
3. Use ALTER database to Remove the file
ALTER DATABASE <DBNAME> REMOVE FILE 'logical ndf file name'
Thanks
Hari
SQL Server MVP
"Gene Vangampelaere" <gene.vangampelaere.remove.this@.infohos.remove.thi s.be>
wrote in message news:e5GdaAfVFHA.3716@.TK2MSFTNGP12.phx.gbl...
> Hi
> I have a database with 3 datafiles :
> file1 => filegroup primary
> file2 => filegroup primary
> file3 => filegroup index_data
> Now I want to delete the file2. Is that possible ? I get the message that
> the file is not empty. How can I determine what data is in the file ?
>
> Regards
> Gene
>

Primary filegroup

Hi
I have a database with 3 datafiles :
file1 => filegroup primary
file2 => filegroup primary
file3 => filegroup index_data
Now I want to delete the file2. Is that possible ' I get the message that
the file is not empty. How can I determine what data is in the file ?
Regards
GeneYou need to empty it first using DBCC SHRINKFILE with the EMPTYFILE option.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Gene Vangampelaere" <gene.vangampelaere.remove.this@.infohos.remove.this.be>
wrote in message
news:e5GdaAfVFHA.3716@.TK2MSFTNGP12.phx.gbl...
> Hi
> I have a database with 3 datafiles :
> file1 => filegroup primary
> file2 => filegroup primary
> file3 => filegroup index_data
> Now I want to delete the file2. Is that possible ' I get the message that
the file is not empty.
> How can I determine what data is in the file ?
>
> Regards
> Gene
>|||thx !!!
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> schreef
in bericht news:OyG65IfVFHA.1200@.TK2MSFTNGP14.phx.gbl...
> You need to empty it first using DBCC SHRINKFILE with the EMPTYFILE
> option.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Gene Vangampelaere"
> <gene.vangampelaere.remove.this@.infohos.remove.this.be> wrote in message
> news:e5GdaAfVFHA.3716@.TK2MSFTNGP12.phx.gbl...
>|||Hi,
To do this, use the DBCC SHRINKFILE with EMPTY FILE option for the NDF file
This will empty the file and mark it as unavailable. After this use ALTER
DATABASE.. REMOVE FILE option to remove the NDF file.
Steps:
1. Take a database backup
2. Use database_name
go
DBCCSHRINKFILE('NDFFILE_name',_'EMPTYFIL
E')
3. Use ALTER database to Remove the file
ALTER DATABASE <DBNAME> REMOVE FILE 'logical ndf file name'
Thanks
Hari
SQL Server MVP
"Gene Vangampelaere" <gene.vangampelaere.remove.this@.infohos.remove.this.be>
wrote in message news:e5GdaAfVFHA.3716@.TK2MSFTNGP12.phx.gbl...
> Hi
> I have a database with 3 datafiles :
> file1 => filegroup primary
> file2 => filegroup primary
> file3 => filegroup index_data
> Now I want to delete the file2. Is that possible ' I get the message that
> the file is not empty. How can I determine what data is in the file ?
>
> Regards
> Gene
>