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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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.
Kelvin SparksCommented:
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.
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

ValentinoVBI 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)
Mohammed KhawajaManager - 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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
spaced45Author Commented:
This is all great information. Thanks Experts!!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.