Daniel Forrester
asked on
Restore SQL database to another database
I need to restore some live data from the 'live' database into a 'trial' database on the same sql server 2012 and am having difficulty using the sql backup restore, so much so i ended up restoring the live data into itself, luckily I was able to roll it back but it was a twitchy time as i'd foolishly not done a backup of the live data as i didn't think i was touching that database.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Change File Names and DB Name in Restore DB dialog.