Link to home
Start Free TrialLog in
Avatar of michaeldean99
michaeldean99Flag for United Kingdom of Great Britain and Northern Ireland

asked on

sql server 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
Avatar of rajvja
rajvja
Flag of United Kingdom of Great Britain and Northern Ireland image

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.
Avatar of michaeldean99

ASKER

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!
ASKER CERTIFIED SOLUTION
Avatar of rajvja
rajvja
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial