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

x
  • 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
0
npl77
Asked:
npl77
1 Solution
 
chapmandewCommented:
backup and restore it.
0
 
npl77Author Commented:
doesnt work..how do I restore it in detail, maybe im doing something wrong.
0
 
sm394Commented:
0
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.

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

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