Datawarehouse Migration

Question

I need to transfer/move sql servers (2005 and 2008) from one location to another. Actual hardware is not moving but we need to develop exactly same environment(through backup and restore) at other location. What are the components we will be required to move?
Any document would be helpful.

Answer 1

Hi Mayur,

Base on your description, user databases, logins and passwords etc. are required to move. If you don’t want to move master, model, tempdb or msdb system databases, you also need to move jobs, alerts, and operators and so on. For more details, please refer to this article: How to move databases between computers that are running SQL Server.

For moving databases, there’re many ways including: detach and attach, backup and restore, use copy database wizard, generate the create script using Generate Script Wizard (SSMS) and execute it in the destination server and so on. For more details, please refer to this blog: Move a database from one server to another server in SQL Server 2008.

For moving system databases, please refer to this article: Moving System Databases.

Best Regards,
Ray Chen

Answer 2

During transfer of logins : Server Role mappings are not getting transferred. How this can be managed? Any solution?