August 11, 2018 at 9:23 am
Hello ,Following a migration error of my SQL2008 server to 2014
I am starting from a new installation 2014
the goal will be to transfer the 2008R2 to the new
IF I start with the transfer of system base (master, msdb, model)
Will you be able to restore the 2008 master database to a server with a 2014 version
the same for msdb and the modelThank you for your return
August 13, 2018 at 1:34 pm
joujousagem2006 1602 - Saturday, August 11, 2018 9:23 AMHello ,Following a migration error of my SQL2008 server to 2014
I am starting from a new installation 2014
the goal will be to transfer the 2008R2 to the new
IF I start with the transfer of system base (master, msdb, model)
Will you be able to restore the 2008 master database to a server with a 2014 version
the same for msdb and the modelThank you for your return
You need to restore to the same version of SQL Server that the backup was taken from. Refer to the limitations section in this documentation:
Back Up and Restore of System Databases
October 8, 2018 at 12:34 am
You can migrate your SQL Server database from one Server to another by various methods. Copy Database Wizard, Generate script, by Backup & Restore,
http://www.technologycrowds.com/2018/10/import-sql-server-database-to-another-server.html
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply