Solved

SQL Server 2008 Restore Error

Posted on 2010-08-13
3
421 Views
Last Modified: 2012-05-10
Hi,

I am trying to restore a database (DATABASE_TEST) to a Server ('MY_SERVER). The restore fails with the following message:

------------------------------

Restore failed for Server 'MY_SERVER'.  (Microsoft.SqlServer.SmoExtended)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.2531.0+((Katmai_PCU_Main).090329-1045+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

System.Data.SqlClient.SqlError: The tail of the log for the database "DATABASE_TEST" 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)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.2531.0+((Katmai_PCU_Main).090329-1045+)&LinkId=20476

--------------------------------------------------

Any suggestions on how to rectify the problem?


0
Comment
Question by:gerrymac1943
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 8

Accepted Solution

by:
dba2dba earned 500 total points
ID: 33431654
The issue occurs if "Overwrite the existing database" is not selected under Restore Job Properties.

If you are using t-sql to perform the restore, please use WITH REPLACE Clause in the restore command.
0
 
LVL 8

Expert Comment

by:mustaccio
ID: 33432172
Suggestions are listed right there in the error message you have posted, after ADDITIONAL INFORMATION:

The tail of the log for the database "DATABASE_TEST" 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. (
0
 

Author Closing Comment

by:gerrymac1943
ID: 33435652
excellent
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question