Posted by Erland Sommarskog on 11/18/05 14:37

Branco Medeiros (branco.medeiros@gmail.com) writes:
> Today, to my surprise, the destination SQL returned the following
> error:
>
> Processed 25592 pages for database 'db_icoaraci', file 'ICOARACI_DAT'
> on file 1.
> Processed 1 pages for database 'db_icoaraci', file 'ICOARACI_LOG' on
> file 1.
> Server: Msg 1105, Level 17, State 2, Line 1
> Could not allocate space for object '(SYSTEM table id: 6)' in database
> 'db_icoaraci' because the 'PRIMARY' filegroup is full.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
>
> I searched the list and a found a few posts refering to the same error,
> but none in the exactly same scenario.

Looks like you have run out of disk space. Probably the database autogrows
as part of the upgrade to SQL 2000. For an autogrow to succeed there has to
be so much space available.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: BULK INSERT and APPLICATION ROLE
• Prev in forum: Re: What looks like a basic SQL query still not resolved
• Thread view: Re: SQL Server Msg 1105, Level 17, State 2, Line 1

[Reply to this message]