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
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 ?
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)
Can I copy the DATA folder ?