We help IT Professionals succeed at work.

sql server 12

michaeldean99
on
256 Views
Last Modified: 2012-06-12
hi
I have  downloaded a sql server database into sql server 2012 on my computer.
how do i create a duplicate of this local database?
thanks
michael
Comment
Watch Question

Commented:
What do you mean by duplicate?

there are different ways.

1. Take a backup of the original and create new database. Do restore from the backup
2. Take database script and execute on new database.

Author

Commented:
hi

duplicate with the existing data. It is to use as an online test database for code changes that are being made.
I have downloaded a .bak copy into my local sql server 2012.
I wanted to make a duplicate of this local copy which i can then modify (data and table changes) before putting it back online for testing a new version of the website.
I have very little experience of sql db admin, just enough to know that I will probably mess up anything complicated!
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.