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?