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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Backup Exec 10D w/SQL 2005

Status
Not open for further replies.

dmvdmv

MIS
Mar 15, 2004
37
0
0
US
I am trying to restore a database that is on SQL 2005 and get the error "The tail of the log for the database "databasename" has not been backed up. Use BACKUP LOG WITH NORECOVERY to backup the log if it contains work you do not want to lose. Use the WITH REPLACE or WITH STOPAT clause of the RESTORE statement to just overwrite the contents of the log."

I found something about this on the symantec website. It said to check the "Overwrite Existing Database" option in the Restore - Settings - Microsoft SQL. I do not have this option. My guess is because I am on version 10D.

Does anyone have a workaround or know of a setting that will do the same thing? Nothing seems obvious. I don't see anything about Replace or Stopat

Thanks a lot,
Diane
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top