Hi,
I am trying to put a 2012 database on a new 2017 server. So, I thought that the easiest way would be to take the backup that I have for 2012 and restore it to 2017. However, it would not go. I tried just restoring it, and then made an empty database with the same name and tried restoring it to that. but it will not go. I get the following error:
System.Data.SqlClient.SqlError: File "AFData1" cannot be restored over the existing "C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\DMPCRU.mdf". Reissue the RESTORE statement using WITH REPLACE to overwrite pre-existing files, or WITH MOVE to identify an alternate location. (Microsoft.SqlServer.SmoExtended)
SO I went to Options and selected the overwrite option and then I get this:
System.Data.SqlClient.SqlError: RESTORE detected an error on page (0:0) in database "DMPCRU" as read from the backup set. (Microsoft.SqlServer.SmoExtended)
Not sure what I can do from here, to get the database on this new server.
Thank you