Posted by Utahduck on 04/11/07 22:21

I've been having some issues so forgive me if this double-posts.

Because I have some large but static Filegroups within a database I
prefer to backup my filegroups instead of everything at once. This is
SQL Server 2000.

The other day I backed up a file with this command:

BACKUP DATABASE Thomasville
FILEGROUP = 'PRIMARY'
TO DISK = 'D:\SQLBackups\2 - Monday\Full-Thomasville-
PRIMARY-070409-1528h.bak'
WITH FORMAT

The backup worked flawlessly. But when I try to restore it into
another database:

RESTORE DATABASE Thomas
FILEGROUP = 'PRIMARY'
FROM DISK = 'D:\SQLBackups\2 - Monday\Full-Thomasville-
PRIMARY-070409-1528h.bak'
WITH PARTIAL,
MOVE 'Thomasville_Data' TO 'd:\SQLServerData\MSSQL\data
\Thomasville_Data_Thomas.MDF',
MOVE 'Thomasville_Log' TO 'd:\SQLServerData\MSSQL\data
\Thomasville_Log_Thomas.LDF',
NORECOVERY

I get this:

Server: Msg 3135, Level 16, State 2, Line 1
The backup set in file 'D:\SQLBackups\2 - Monday\Full-Thomasville-
PRIMARY-070409-1528h.bak' was created by BACKUP DATABASE...FILE=<name>
and cannot be used for this restore operation.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

It works if I remove the PARTIAL clause but then I can't recover my
database afterwards. I need the PARTIAL because I'm only restoring
one filegroup and not the entire database.

Please help.

-Utahduck

[Back to original message]