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!

Register Log in
  • Congratulations Chris Miller 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

dmvdmv

MIS
Mar 15, 2004
37
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.

Similar threads

Kennymc
  • Locked
  • Question
backup exec
Replies
0
Views
396
Kennymc
Kennymc
Martha_SysAdm
  • Locked
  • Question
Which hardware and software can i consider for Backup and Disaster recovery 1
Replies
3
Views
579
goombawaho
goombawaho
Marino.
  • Locked
  • Question
Restore backup in Open VMS
Replies
0
Views
448
Marino.
Marino.
nmahat
  • Locked
  • Question
Symantec Backup Exec 2015: Backup Fail
Replies
0
Views
157
nmahat
nmahat
LucilleWJarrett
  • Locked
  • Question
All points are well and important
Replies
1
Views
424
iggsterman
iggsterman

Part and Inventory Search

Sponsor

Back
Top