Link to home
Start Free TrialLog in
Avatar of Daniel Forrester
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
Avatar of Qlemo
Qlemo
Flag of Germany 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
Change File Names and DB Name in Restore DB dialog.