Copy 2012 MsSQL Server Database to 2017 MsSQL Server

by Glenn Sampson   Last Updated July 11, 2019 22:06 PM

I was wondering if this was possible as currently my task is failing.

I have a production database on a enterprise MsSQL Server 2012 this has been copied to a enterprise MsSQL 2012 on a staging server successfully.

My last step is to now copy this to my development environment.

This environment is a developer MsSQL Sever 2017.

I step through the setup step to copy the database to the dev environment and it starts running. It successfully connects to both using SQL Admin, then starts to copy the files (you can see them appear in the path at the desired server), fails, deletes the files and doesn’t create a log file.

Any thoughts/work arounds please



Related Questions


Updated March 12, 2016 07:02 AM

Updated July 27, 2015 17:02 PM

Updated March 20, 2019 09:06 AM

Updated July 26, 2019 15:06 PM

Updated March 26, 2015 09:02 AM