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!!!
pabrannPresidentAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Nakul VachhrajaniTechnical Architect, Capgemini IndiaCommented:
Is there any error that gets logged in the SQL Server log (and/or the Windows event viewer)?

Also, what is the process that you are using to execute the restore? If you can share the command/UI steps that would be nice.
0
pabrannPresidentAuthor Commented:
The ErrorGeneral areaFiles areaOptions area
Hopefully you will see what I did. Select the backup file from hard disk.(SQLOrderSys_PB_20150512.bak) file from database (SQLOrdersys)

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
0
Anthony PerkinsCommented:
This has nothing to do with SQL Server 2012 vs 2008. You have a permission problem.  You need to make sure that the SQL Server service startup account has the appropriate permissions in the  e:\Applications\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\DATA_2 folder.
0
IT Pros Agree: AI and Machine Learning Key

We’d all like to think our company’s data is well protected, but when you ask IT professionals they admit the data probably is not as safe as it could be.

pabrannPresidentAuthor Commented:
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?
0
Anthony PerkinsCommented:
Check the account used for SQL Server service.
Check the security tab for the Windows folder.
Make sure the account has the appropriate permissions in that folder.
0
Nakul VachhrajaniTechnical Architect, Capgemini IndiaCommented:
I agree. It's a permissions problem. The solution by Anthony should do the trick.
0
pabrannPresidentAuthor Commented:
Full-Control.JPG   I checked the hard drive location where the files are being stored and it appears that I have "full control"/
0
Anthony PerkinsCommented:
 I checked the hard drive location where the files are being stored and it appears that I have "full control"/
The key question you are overlooking is "Check the account used for SQL Server service", does it have full control of that folder?
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Why are you choosing to overwrite the database? Isn't to restore into a new database?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
pabrannPresidentAuthor Commented:
Works fine now, thank you very mucy.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.