Copying an SQL Server 2005 Database

Posted on 2008-11-03
Last Modified: 2010-04-21
I have an sql server database on my machine that has tables, data, and stored procs in it. I want to give to put the database and all its data on a different machine. What is the fastest way to do this? I have tried to create a backup file and restore it on the other machine, but that doesnt seem to work. Thanks in advance
Question by:npl77
    LVL 60

    Expert Comment

    backup and restore it.

    Author Comment

    doesnt do I restore it in detail, maybe im doing something wrong.
    LVL 13

    Expert Comment

    LVL 5

    Accepted Solution

    -Create a db on the new server with the same name, choose the file location and file names you want
    - Restore the db with the option "overwrite files" on the Options menu
    LVL 3

    Expert Comment

    Detach the database from the source server, copy the .mdf and .ldf to the destination server and attach the database there. You might just need to adjust user permission a bit. That should be the fastest way.

    Author Closing Comment

    Thanks for such the quick response guys!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
    Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
    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…

    737 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

    22 Experts available now in Live!

    Get 1:1 Help Now