|
|
Posted by Mohit on 04/12/07 11:47
On Apr 12, 3:21 am, "Utahduck" <Utahd...@hotmail.com> wrote:
> 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
tnnx
Navigation:
[Reply to this message]
|