Avatar of Jose Bredariol
Jose Bredariol
Flag for Brazil asked on

MSSQL SERVER EXPRESS BACKUP/RESTORE

I have windows 2008 server and Mssql server express 10.50.2500 runing fine. Now I have to change the server.
The other server is windows 2008 server too, but another name and domain. I installed the same MSSQL express I had on the old server.
I did backup on the old server, but I´m not able to do the restore on the new server. I´m getting "restore failed for the server ""NEWSERVER\DATABASE"" ...." what I´m doing wrong ?
Microsoft SQL ServerStorage SoftwareMicrosoft SQL Server 2008

Avatar of undefined
Last Comment
Jose Bredariol

8/22/2022 - Mon
SOLUTION
Brian Crowe

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Jose Bredariol

ASKER
Yes, I think they have, how can I check it ? what more I have to check ?
Can I copy the DATA folder ?
SOLUTION
Brian Crowe

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Jose Bredariol

ASKER
I'm using microsoft sql management for backup and for restore. I'm using exactly the same version.
The servers name are different, the instances have the same name, the database have te same name and collation.
What more i have to check ?
ASKER CERTIFIED SOLUTION
Brian Crowe

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Jose Bredariol

ASKER
Ok, I'll do it on monday and post the result. Thanks
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
Jose Bredariol

ASKER
ERROR MESSAGE :

Restaurar falhou para Servidor 'WIN-QOX3CFMGC91\SBASQLEXPRESS'.  (Microsoft.SqlServer.SmoExtended)

Para obter ajuda, clique em: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.2500.0+((KJ_PCU_Main).110617-0026+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restaurar+Server&LinkId=20476

------------------------------
INFORMAÇÕES ADICIONAIS:

Ocorreu uma exceção ao executar um lote ou uma instrução Transact-SQL. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

O conjunto de backup mantém um backup de um banco de dados diferente do banco de dados 'Logbook' existente.
RESTORE DATABASE está sendo encerrado de forma anormal. (Microsoft SQL Server, Erro: 3154)

Para obter ajuda, clique em: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.2500&EvtSrc=MSSQLServer&EvtID=3154&LinkId=20476
Jose Bredariol

ASKER
Thanks
I forgot to check the box to replace the database