Moving database to another server | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Moving database to another server

I need to move my SQL2000 Server which is currently running windows 2000 to another server running Windows 2003. To make things more complicated the new Windows 2003 server is in another domain. I have tired usinghttp://vyaskn.tripod.com/moving_sql_server.htm by vyas which is great but to no avail, i understand that in this artical he is using identical OS. If someone could give me a hand it would be great. cheers Nat
You should follow the same article inorder to accomplish the task and on operating system point of view ensure to install fresh windows 2003 rather than upgrading from Windows 2000. Before that always test the process in order to ensure to overcome any issues in production. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Thanks satya! I went through the documentation and all worked fine, it appears all Databases have been moved without a problem! My next question is regarding cubes, I am quiet new to SQL2000 and this server has cubes attached. I moved the data using Analyst manager from one server to the other. However now when i try and use Cubes (Excel Spreadsheet) it comes up with Server or Authentication error. Any ideas would be great. thanks in advance.
For OLAP issues may referhttp://www.mssqlcity.com/Articles/Adm/olap_troubleshooting.htm link. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>