Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 758
  • Last Modified:

Failed DB Recovery - 'The tail of the log....'

I'm testing database restores and every time I attempt to restore a full database backup I receive the following messge:

System.Data.SqlClient.SqlError: The tail of the log for the database "DataMartAZ" 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. (Microsoft.SqlServer.Smo)

What causes this?  The Full Backup operation performs fine with no errors, but on restore I get this.  Any advice is appreciated.
0
jobprojn
Asked:
jobprojn
1 Solution
 
jorge_torizResearch & Development ManagerCommented:
BACKUP your database, then, BACKUP your log

RESTORE your database (with "WITH NORECOVERY" option) and then RESTORE your log
0
 
jobprojnAuthor Commented:
Thanks.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now