Posted by Erland Sommarskog on 04/12/07 21:22

(Utahduck@hotmail.com) writes:
> I back up using Filegroups because I dont' want to back up the large,
> static ones on a regular basis. This backup worked just fine. When I
> try to restore it I run:
>
> RESTORE DATABASE Thomas
> FILEGROUP = 'PRIMARY'
> FROM DISK = 'D:\SQLBackups\2 - Monday\Full-Thomasville-
> PRIMARY-070409-1528h.bak'
> WITH PARTIAL,
> PASSWORD = 'p@$$w0rd',
> 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.

In SQL 2000 you can only do partial restore from a full backup. SQL 2005
provides new options, although I am not certain that they addrss your
needs.


--
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

[Back to original message]