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.

All Forums  SQL Server 2005 Forums  SQL Server Administration (2005)  Restore Backup

Author  Topic  juanita Starting Member 9 Posts Posted - 2009-04-20 : 05:25:41 Hi, I have two backup program, is a full once a day and a differential 1 time every 30 minutes. Both generated from a backup device. I created a backup device for each backup type (full and differential) When the restoration is not complete gives me error, but when I try to restore the differential gives me the following error: "You can not restore the backup of the registry because any differential file is ready to catch '(I've searched the error and it is 3117) I also tried the following: "RESTORE DATABASE Dynamic FROM DISK = 'C: \ Pouch \ Ianiro \ Backup \ DinamicoBackupCompleta' WITH NORECOVERY Dynamic RESTORE DATABASE FROM DISK = 'C: \ Pouch \ Ianiro \ Backup \ DinamicoBackupDiferencial' WITH RECOVERY " I have read the online help but I have not been clarified. To restore the differential that I have restored before complete? So what should be done in two steps or resturacion of the two in one? Thank you