Solved

SQL Server 2008 Restore Error

Posted on 2010-08-13
3
417 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

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

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

Suggested Solutions

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …

738 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