Moving a database from one server to another one

Posted on 2005-05-15
Last Modified: 2010-03-19

I'm planning to move a database called ABC from server A to server B.
I'm using SQL Server 2000.
To achieve that I was thinking of performing the following steps:
1) take a full backup of database ABC on server A;
2) copy over the network the backup of ABC on to server B;
3) rebuild from the backup the database ABC on server B.
My question is. Whatelse do I have to do?
How can I also move loggins and all other objects associated with this database?
The database is used to store data for an application used by some users. Exactly, which others steps do I have to perform to make sure that the users will not have any problem when we database will be move to server B?
Which are the most common problems I may come accross and how solve them?

Thank you
Question by:deepakee
    LVL 42

    Accepted Solution

    if yo

    review the article and links from the article
    HOW TO: Move Databases Between Computers That Are Running SQL Server

    HOW TO: Transfer Logins and Passwords Between Instances of SQL Server
    LVL 5

    Expert Comment

    Extra job to do :

    1. Backup any DTS file you have made and stored on server A
    2. Backup any scheduled jobs running on server A
    3. Recreate security logins, roles, linked server information on server B
    LVL 8

    Expert Comment

    When you restore your database - sometimes your logins are not recognised depending on what service pack was installed on SQL server 2000.

    If you have a linked server you will have to re configure.

    You need to setup you applications to point to the server b rather that server ABC.

    I dont see any other problem with restore.

    If your users cannot login  run the following query

    sp_change_users_login 'auto_fix', 'username'


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    Viewers will learn how the fundamental information of how to create a table.
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now