Re: Restore database
- From: "Brett I. Holcomb" <brettholcomb@xxxxxxxxxxxxx>
- Date: Wed, 30 May 2007 18:29:29 -0400
Evidently there is a log that's not backed up - or part of it.
You can backup the log if it's still around or if you know for sure that there aren't any transactions in the log that you need you can use the options listed in the error to force it to restore the database -BUT be VERY sure the missing log doesn't have something you need.
Markgoldin wrote:
I am trying to restore database from SQL 2005 to SQL 2005 Express.
I am getitng an error:
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
Restore failed for Server 'HOMEDEV\SQLEXPRESS'. (Microsoft.SqlServer.Express.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&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 "accidents" 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.Express.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&LinkId=20476
Can someone help, please?
--
Brett I. Holcomb
brettholcomb@xxxxxxxxxxxxxxxxx
Remove R777 to email
.
- Follow-Ups:
- Re: Restore database
- From: Markgoldin
- Re: Restore database
- Prev by Date: sql server 2005 service question
- Next by Date: Re: Restore database
- Previous by thread: sql server 2005 service question
- Next by thread: Re: Restore database
- Index(es):
Relevant Pages
|
