Error: 1101, Severity: 17, State: 10

Error: 1101, Severity: 17, State: 10
Could not allocate new page for database 'TEMPDB'. There
are no more pages available in filegroup DEFAULT. Space
can be created by dropping objects, adding additional
files, or allowing file growth..
Does anybody know the quick fix to this? Thx.Rose,
Tempdb has filled up its space or has filled the disk
where it was created.
This leads to an MSDN article on expanding databases with
some specific comments on tempdb.
http://tinyurl.com/hoh4
Since tempdb is recreated each time you start the server
a restart will clear the current problem. However, you
should try to find out what was happening that filled
tempdb and try to prevent it from happening again.
Russell Fields
>--Original Message--
>Error: 1101, Severity: 17, State: 10
>Could not allocate new page for database 'TEMPDB'. There
>are no more pages available in filegroup DEFAULT. Space
>can be created by dropping objects, adding additional
>files, or allowing file growth..
>Does anybody know the quick fix to this? Thx.
>.
>|||Rose,
>> Does anybody know the quick fix to this?
How about the one mentioned in the error message itself? Did you check if
there is enough space in the filegroup?
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Rose Mbatuchic" <simacy6@.yahoo.com> wrote in message
news:0bd401c35059$82aec8b0$a401280a@.phx.gbl...
> Error: 1101, Severity: 17, State: 10
> Could not allocate new page for database 'TEMPDB'. There
> are no more pages available in filegroup DEFAULT. Space
> can be created by dropping objects, adding additional
> files, or allowing file growth..
> Does anybody know the quick fix to this? Thx.

Error while performing Fullbackup after a filegroup restore.

System.Data.SqlClient.SqlError: The backup of the file or filegroup "CUSTBilling" is not permitted because it is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data. (Microsoft.SqlServer.Smo)

I did a file group backup and restore of a database and then when I tried to perform a full backup I am getting the above error. Any thoughts. I indeed happen to see this error http://support.microsoft.com/default.aspx/kb/921106 but not sure if both errors are the same.

Santhosh
http://sqlspy.blogspot.comI assume that you did a backup and restore of the CUSTBilling file group? Did you ensure that the filegroup is back online after the restore completed?|||

According to the error message, not all of your filegroups were online when you attempted the full backup.

After your filegroup restore, were all of your filegroups online, or only some of them?

Backup cannot process offline filegroups, and a full backup is defined to process the whole database.

You need to either bring all filegroups online, or back up only the online filegroups using the FILEGROUP clause in your BACKUP statement.

The differential backup message is caused by the fact that you haven't successfully performed a full backup, and so the differential has no base on which to calculate the deltas.

Kevin

|||

I have the same problem.

I had a database on an SQL 2000 server and I copied the data into a new, SQL 2005 Express database that did not have fulltext indexing on. Now I'm trying to back up my database using the GUI, but I still get the error:

System.Data.SqlClient.SqlError: The backup of the file or filegroup is not permitted because it is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data. (Microsoft.SqlServer.Smo)

There is no setting in the GUI about FILEGROUPs, or if there is, I can't find it. Do I need to write code to backup the database, can't I use the SQL Studio?

Thanks,

Janos

|||I have the same problem.
In my case I detached from 2000 and attached to 2005. The full text is checked

When I try to backup I get this error
Failed-1073548784) Executing the query "BACKUP DATABASE [PublicWorks] TO

" failed with the following error:
"The backup of the file or filegroup "sysft_Plats" is not permitted because it is not online.
BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data.

How do I get the sysft_Plats on line?
If not what is the FILEGROUP or FILE clauses syntax?

Thanks in advance for your help.
|||Kevin,
How do you do that "You need to either bring all filegroups online, or back up only the online filegroups using the FILEGROUP clause in your BACKUP statement.

Can you tell me how to bring filegroups online?
OR
How to use the FILEGROUP clause?

Thanks in advance for your help

Tarig

Error while performing Fullbackup after a filegroup restore.

System.Data.SqlClient.SqlError: The backup of the file or filegroup "CUSTBilling" is not permitted because it is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data. (Microsoft.SqlServer.Smo)

I did a file group backup and restore of a database and then when I tried to perform a full backup I am getting the above error. Any thoughts. I indeed happen to see this error http://support.microsoft.com/default.aspx/kb/921106 but not sure if both errors are the same.

Santhosh
http://sqlspy.blogspot.comI assume that you did a backup and restore of the CUSTBilling file group? Did you ensure that the filegroup is back online after the restore completed?|||

According to the error message, not all of your filegroups were online when you attempted the full backup.

After your filegroup restore, were all of your filegroups online, or only some of them?

Backup cannot process offline filegroups, and a full backup is defined to process the whole database.

You need to either bring all filegroups online, or back up only the online filegroups using the FILEGROUP clause in your BACKUP statement.

The differential backup message is caused by the fact that you haven't successfully performed a full backup, and so the differential has no base on which to calculate the deltas.

Kevin

|||

I have the same problem.

I had a database on an SQL 2000 server and I copied the data into a new, SQL 2005 Express database that did not have fulltext indexing on. Now I'm trying to back up my database using the GUI, but I still get the error:

System.Data.SqlClient.SqlError: The backup of the file or filegroup is not permitted because it is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data. (Microsoft.SqlServer.Smo)

There is no setting in the GUI about FILEGROUPs, or if there is, I can't find it. Do I need to write code to backup the database, can't I use the SQL Studio?

Thanks,

Janos

|||I have the same problem.
In my case I detached from 2000 and attached to 2005. The full text is checked

When I try to backup I get this error
Failed-1073548784) Executing the query "BACKUP DATABASE [PublicWorks] TO

" failed with the following error:
"The backup of the file or filegroup "sysft_Plats" is not permitted because it is not online.
BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data.

How do I get the sysft_Plats on line?
If not what is the FILEGROUP or FILE clauses syntax?

Thanks in advance for your help.
|||Kevin,
How do you do that "You need to either bring all filegroups online, or back up only the online filegroups using the FILEGROUP clause in your BACKUP statement.

Can you tell me how to bring filegroups online?
OR
How to use the FILEGROUP clause?

Thanks in advance for your help

Tarig

Error while performing Fullbackup after a filegroup restore.

System.Data.SqlClient.SqlError: The backup of the file or filegroup "CUSTBilling" is not permitted because it is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data. (Microsoft.SqlServer.Smo)

I did a file group backup and restore of a database and then when I tried to perform a full backup I am getting the above error. Any thoughts. I indeed happen to see this error http://support.microsoft.com/default.aspx/kb/921106 but not sure if both errors are the same.

Santhosh
http://sqlspy.blogspot.comI assume that you did a backup and restore of the CUSTBilling file group? Did you ensure that the filegroup is back online after the restore completed?|||

According to the error message, not all of your filegroups were online when you attempted the full backup.

After your filegroup restore, were all of your filegroups online, or only some of them?

Backup cannot process offline filegroups, and a full backup is defined to process the whole database.

You need to either bring all filegroups online, or back up only the online filegroups using the FILEGROUP clause in your BACKUP statement.

The differential backup message is caused by the fact that you haven't successfully performed a full backup, and so the differential has no base on which to calculate the deltas.

Kevin

|||

I have the same problem.

I had a database on an SQL 2000 server and I copied the data into a new, SQL 2005 Express database that did not have fulltext indexing on. Now I'm trying to back up my database using the GUI, but I still get the error:

System.Data.SqlClient.SqlError: The backup of the file or filegroup is not permitted because it is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data. (Microsoft.SqlServer.Smo)

There is no setting in the GUI about FILEGROUPs, or if there is, I can't find it. Do I need to write code to backup the database, can't I use the SQL Studio?

Thanks,

Janos

|||I have the same problem.
In my case I detached from 2000 and attached to 2005. The full text is checked

When I try to backup I get this error
Failed-1073548784) Executing the query "BACKUP DATABASE [PublicWorks] TO

" failed with the following error:
"The backup of the file or filegroup "sysft_Plats" is not permitted because it is not online.
BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data.

How do I get the sysft_Plats on line?
If not what is the FILEGROUP or FILE clauses syntax?

Thanks in advance for your help.
|||Kevin,
How do you do that "You need to either bring all filegroups online, or back up only the online filegroups using the FILEGROUP clause in your BACKUP statement.

Can you tell me how to bring filegroups online?
OR
How to use the FILEGROUP clause?

Thanks in advance for your help

Tarig