SAP Business One: SQL Server Migration from SQL Se...

tobias_frei1 · ‎12-07-2016

Hello,

we are planning to change our database server. Is there a detailed step by step tutorial how this can be achieved?

kothandaraman_nagarajan · ‎02-27-2018

Hi,

Before upgrading your server,

1. Check your current version is compatible with SQL server 2014. You may consider upgrading to SQL server 2016 which supports latest 9.3 version.

2. Check System and hardware requirement guides from SAP portal for server and client installations.

3. Make sure there is enough space for installing programs and daily backup of database.

Regards,

Nagarajan

Johan_H · ‎02-27-2018

Hi Tobias,

If you have a new server, I recommend the following:

on the current / old server create a backup of your company database
check with SAP that 2014 is supported for your B1 version.
Optional: check with SAP that 2014 is the latest version supported for your B1 version.
on the new server perform a clean install of B1 and MS SQL Server 2014.
copy the backup file of the company database from the old server to the new server
on the new server in MS SQL Server Studio, create a new empty database (optionally: with the name of your company database)
restore the backup of your company database, with overwrite, on top of the new empty database
in MS SQL Server Management Studio, open the property sheet of the company database, check that the recovery model is simple, and that the compatibility level is set to MS SQL Server 2014

Regards,

Johan

luisdarui · ‎12-09-2016

You should seek information within SAP Business One documentation:

And SAP Note 928839

former_member206857 · ‎12-09-2016

,

Go here,

and

service.sap.com/instguides

You should be able to find a guide. I just did 08 t0 2012 with a Guide from there.

some notes for 2012 that may link you to 2014

1676665 1651862

Look at your kernel, likely need upgraded or updated.

Also check out this page

SAP Business One: SQL Server Migration from SQL Server 2008R2 to SQL Server 2014 (new Server)