[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 213
  • Last Modified:

Copying an SQL Server 2005 Database

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
1 Solution
backup and restore it.
npl77Author Commented:
doesnt work..how do I restore it in detail, maybe im doing something wrong.
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

-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
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.
npl77Author Commented:
Thanks for such the quick response guys!

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now