Posted by Branco Medeiros on 11/17/05 15:33

Dear (and mighty) all:

I backed up a database (SQL server 7.0) and tried to restore it on
another system (SQL Server 2000). This is not the first time I'm doing
this and never had a problem before:

-- in the source db
BACKUP db_icoaraci TO DISK = 'C:\TEMP\BACKUP-ICOARACI.DAT'

--in the destination db
RESTORE db_icoaraci FROM DISK='E:\TEMP\BACKUP-ICOARACI.DAT'
WITH MOVE='ICOARACI_DAT' TO 'E:\DB\ICOARACI.MDF',
MOVE='ICOARACI_LOG' TO 'E:\DB\ICOARACI.LDF'

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.

I tried to restore the database with NORECOVERY, and, before restoring
the log, increase its size (ALTER DATABASE ... etc), but SQL Server
says that the DB couldn't be open because it's in the middle of a
restore...

I'll appreciate any help.

Regards,

Branco.

• Next in forum: Query returning 1.7million records slow
• Prev in forum: Re: [Newbie] Restoring.............
• Thread view: SQL Server Msg 1105, Level 17, State 2, Line 1

[Reply to this message]