sql server new users: It can't be this hard -- sql server new users

You're in the

sql server new users

group:

It can't be this hard

keithb
4/25/2006 8:58:33 AM

sql server new users: I just want to move my database from sqlserver 2000 to sqlserver2005. I use
Enterprise Manager, select backup, database complete and create a file with
a bak extension. Then I open sql server management studio express, select
restore database, select from a device and enter the backup file path and
name and I get the error message shown below. Apparently, my backup is
missing something called a "tail" (even though it was supposed to be a
complete backup) Is there an easy way to do this???

Thanks,

Keith

TITLE: Microsoft SQL Server Management Studio Express
------------------------------

Restore failed for Server 'LT-E29961SERVER\SQLEXPRESS'.
(Microsoft.SqlServer.Express.Smo)

For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.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
"BuildEmail" 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.1399.00&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

Re: It can't be this hard

Jens
4/25/2006 10:35:36 AM

As the original file destination are retained in the backup, make sure
that the target destination is changed, if you have other target
destinations than on the old server.

HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---

Re: It can't be this hard

Roger Wolter[MSFT]
4/25/2006 5:25:47 PM

As full database backup doesn't include the log so to get the entire
database including any transactions that weren't written to the database
yet, you need to backup the log also with the command they specify in the
error. Another option is to detach the database from SQL Server 2000 and
then attach it to SQL Server 2005 - moving the MDF and LDF files as
required. At this point though, it's probably faster to just backup the
log.

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server new users group.

home · blog · groups

Questions? Comments? Contact the dn