SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Restore database
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Khongoroo
Starting Member

Mongolia
2 Posts

Posted - 04/28/2011 :  01:39:24  Show Profile  Reply with Quote
Hello Everybody,


I want to restore, but showing error. How can i fix it? Help me



Restore failed for Server 'KHONGOROO\SQLEXPRESS'. (Microsoft.SqlServer.SmoExtended)

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

------------------------------
Program Location:

at Microsoft.SqlServer.Management.Smo.Restore.SqlRestore(Server srv)
at Microsoft.SqlServer.Management.SqlManagerUI.SqlRestoreDatabaseOptions.RunRestore()

===================================

System.Data.SqlClient.SqlError: The tail of the log for the database "GBIS_GOBI" 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.50.1600.1+((KJ_RTM).100402-1540+)&LinkId=20476

------------------------------
Program Location:



Regards,


Khongoroo

?.?????????

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 04/28/2011 :  02:03:14  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
Directly from the error message:

quote:
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.


--
Gail Shaw
SQL Server MVP
Go to Top of Page

Mary Joe
Starting Member

2 Posts

Posted - 04/28/2011 :  20:26:37  Show Profile  Reply with Quote
I agree with gila
unspammed
Go to Top of Page

Jahanzaib
Posting Yak Master

Pakistan
115 Posts

Posted - 04/29/2011 :  14:06:15  Show Profile  Visit Jahanzaib's Homepage  Reply with Quote
Take the Tail Log backup and then restore it



Regards,

Syed Jahanzaib Bin Hassan
MCTS,MCITP,OCA,OCP,OCE,SCJP,IBMCDBA

My Blog
www.aureus-salah.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.17 seconds. Powered By: Snitz Forums 2000