Duplicating SQL Database

I'm a business analyst in my formal job. I'm very familiar with running SQL queries. I do that almost all day. What I don't know anything about is the database admin part of it.

My family owns a family restaurant business that has a point of sale system running on SQL server 08. I have made connections to it, I sometimes run queries on it and I also have admin rights to it. I do just enough against the operational database where I know I'm not going to corrupt it. Here is my question.

I'm looking to create custom reports and other things but I don't feel comfortable enough to mess with it directly. I have SQL studio at home.

How do I make a copy of the database and set it up at home so that I can experiment with it? Can anyone that has done something like this before give me any best practices? Some do's and dont's? How can I really have fun with it I mean I can already remote connect to it?

Thank you.
Who is Participating?
Mohammed KhawajaConnect With a Mentor Manager - Infrastructure:  Information TechnologyCommented:
There are two options:

1. Backup and Restore (this is what I recommend and everyone else here too)
2. Copy DB files and attach the files.  This is not recommended as you need the DB offline while you make copy of the files.  

Whenever you do backup and restore, it is  a good practice to change the path as mentioned above as some servers may have multiple drives whereas your home one might have one.
Kelvin SparksCommented:
The simplest solution, is to make a backup (or grab the latest one you have) and copy it to your local machine and restore it.

If you have specific users you need - you'd need to set them up.

spaced45Author Commented:
Is it as simple as a copy paste though. That is really my question. Using the word "restore" makes me think otherwise.
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Kelvin SparksConnect With a Mentor Commented:
You copy and paste the backup file, then using the Management studio, Right click on Databases in the tree, and choose restore. Select the backup file and away you go.
ValentinoVConnect With a Mentor BI ConsultantCommented:
In addition to kelvinsparks: when restoring the DB there are a couple of default settings which you may need to change.  After you get the Restore Database popup window, select the From device radio button.  Now you can select the backup file.

With the backup file selected, switch to the Options page and check if the file paths are right for your system.  By default you'll get the paths as they were on the source system.

Ref How to: Restore a Database Backup (SQL Server Management Studio)
spaced45Author Commented:
This is all great information. Thanks Experts!!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.