Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Agent - Restore Error

Status
Not open for further replies.

barrycork

IS-IT--Management
Jul 25, 2002
53
GB
I have a test database which has a problem therefore I am attempting to restore a previous backup which I know is error free. The database is called GM_TEST. To restore I am selecting 'Filegroups in GM_TEST' from Veritas. Is this the entire database as I am unsure exactly what filegroups are?

When I run the restore it fails with error;

An error occurred on a query to filegroup GM_TEST..PRIMARY.
^ ^ ^ ^ ^
The tail of the log for database 'GM_TEST' has not been backed up. Back up the log and rerun the RESTORE statement specifying the FILE clause.
^ ^ ^ ^ ^

Any suggestions would be appreciated.

Regards,

Barry
 
Does the GM_test database still exist? if it doesn't you will need to restore the full backup of the db first, then restore your filegroups and then after that the log backups.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top