Restoring SQL Server 2012 database to a different location and database name
I'm having difficulty trying to restore a SQL Server 2012 database to a new location and name. This used to work fine in SQL Server 2008 but no longer works and it leaves my original database in a (restoring...) state.
The reason I'm trying to do this is so I can have the exact same database as my client for comparative purposes. I restore my own database to another name and then restore my client's database over my original. I'm trying to do this using SQL Server 2012 Management Studio.
Thanks!!!
The reason I'm trying to do this is so I can have the exact same database as my client for comparative purposes. I restore my own database to another name and then restore my client's database over my original. I'm trying to do this using SQL Server 2012 Management Studio.
Thanks!!!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
How do I do that?? I was able to successfully do this a few times a couple months ago.. was something changed in a Windows Update or SQL Server update?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I checked the hard drive location where the files are being stored and it appears that I have "full control"/
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Works fine now, thank you very mucy.
ASKER
Hopefully you will see what I did. Select the backup file from hard disk.(SQLOrderSys_PB_20150
Select the destination database (SQLOrderSys_C)
Click on "Files" object and choose the destination folder (new folder)
Change the file names by concatenating a "_C" to the mdf and ldf to the "restore as" file
Click on "Options" object and check "Overwrite existing database"
Click "OK" and watch the fail