Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
noamg
Posting Yak Master
215 Posts |
 Posted - 2004-03-18 : 04:14:42
|
| hi,I backup a specific filegroup.now i try to restore it:restore database RREE file = 'Silverton_GIF28_Data', filegroup='primary' from disk='D:\BBfg.BAK' with norecoverybut i get an error:"The backup set holds a backup of a database other than the existing 'RREE' database."... of course ... - I want to restore it into other database with the same schema.any idea ?Noam Graizer |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-03-18 : 08:31:57
|
| You will need to use the WITH MOVE clause of RESTORE DATABASE. Books Online has a good example to cut and paste.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-03-18 : 12:29:35
|
| You are using FILE = incorrectly. Does your backup file contain more than one database backup? If so, then you must specify which one to use inside that file. To determine which one it is, run RESTORE FILELISTONLY. FILE must be part of the the WITH also.If your backup file only contains the one backup, then remove the file = and filegroup = options. Filegroup isn't even an option for the RESTORE command.Also, are you planning on restoring additional transaction logs or a differential backup after this command runs? If not, you want WITH RECOVERY.Tara |
|
|
|
|
|
|
restore