Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

SQL Server 2008 Restore Error

Posted on 2010-08-13
3
Medium Priority
?
431 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 2000 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

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

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

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
In this article I will describe the Detach & Attach 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.
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

618 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