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 ?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
ASKER
Can I copy the DATA folder ?