to migrate a database from one server to anohter server

Posted on 2009-04-24
Last Modified: 2012-05-06
A customer asked me to migrate a database with all queries in sql 2005 from a server to another can 1 do this migrate?could you please tell me step by step because of 1 am not experience so much in sql server..
Question by:teodor76
    LVL 142

    Accepted Solution

    please start with this support note of MS:

    LVL 2

    Expert Comment

    Before do the migration please take a back up of ur database...It will help u if any error occurs during migration ...

    Author Comment

    thank will all the queries backup? and will I backup all the logons in sql?
    LVL 142

    Assisted Solution

    by:Guy Hengel [angelIII / a3]
    queries=> views/procedure?
     those are part of the database backup, so are migrated also.

    logins (server) => review the support note
    users (database) => part of the database .
    LVL 2

    Expert Comment

    Hi u can use odbc to migrate ur database...

    It is very simple...Any questions about the odbc please let me know...


    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    Access table relationships 4 37
    Stored Procedure error 45 36
    T-SQL to Update Table Dynamically 2 21
    Delete from table 6 26
    by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
    INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
    This video discusses moving either the default database or any database to a new volume.
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    728 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

    17 Experts available now in Live!

    Get 1:1 Help Now