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

problems with restore of SQL

Status
Not open for further replies.

suie760523

Technical User
Nov 3, 2006
1
MX
I have the following problem with restore


E8617 11/03/2006 04:57:28 PM 414 53 Failed to end restore. (DBNAME=PortafoliosPrudential, EC=MXHDQDBS01:[SQL Server] szSqlState = 37000,fNativeError = 3159, errMsg = [Microsoft][ODBC SQL Server Driver][SQL Server]The tail of the log for the database "PortafoliosPrudential" 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 hope can help me, thanks

Atte Enrique Suarez
 
Are you trying to restore diff backup or complete backup?

This error is typical when you try to restore a diff backup without previus restore a complete backup.

Bye.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top