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 ?
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
Last Comment
Jose Bredariol
SOLUTION
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.
SOLUTION
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.
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 ?
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
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.
ASKER
Ok, I'll do it on monday and post the result. Thanks
ASKER
ERROR MESSAGE :
Restaurar falhou para Servidor 'WIN-QOX3CFMGC91\SBASQLEXP
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.Conne
--------------------------
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
Restaurar falhou para Servidor 'WIN-QOX3CFMGC91\SBASQLEXP
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.Conne
--------------------------
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
ASKER
Thanks
I forgot to check the box to replace the database
I forgot to check the box to replace the database
Can I copy the DATA folder ?