• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 440
  • Last Modified:

SQL Server 2008 Restore Error

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
gerrymac1943
Asked:
gerrymac1943
1 Solution
 
dba2dbaCommented:
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
 
mustaccioCommented:
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
 
gerrymac1943Author Commented:
excellent
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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