Skip to Content
0

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

Dec 07, 2016 at 12:21 PM

128

avatar image

Hello,

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Nagarajan K Feb 27 at 12:29 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Johan Hakkesteegt Feb 27 at 07:07 AM
-1

Hi Tobias,

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

  1. on the current / old server create a backup of your company database
  2. check with SAP that 2014 is supported for your B1 version.
  3. Optional: check with SAP that 2014 is the latest version supported for your B1 version.
  4. on the new server perform a clean install of B1 and MS SQL Server 2014.
  5. copy the backup file of the company database from the old server to the new server
  6. on the new server in MS SQL Server Studio, create a new empty database (optionally: with the name of your company database)
  7. restore the backup of your company database, with overwrite, on top of the new empty database
  8. 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

Share
10 |10000 characters needed characters left characters exceeded
Joshua Lacroix Dec 09, 2016 at 04:13 PM
0

https://wiki.scn.sap.com/wiki/display/SAPSQL/FAQs+about+SQL+Server+2014

,

Go here,

https://wiki.scn.sap.com/wiki/display/SAPSQL/FAQs+about+SQL+Server+2014

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

https://www.sap.com/community/topic/sql-server.html

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi Joshua,

These sources are all related to SAP systems based on SAP NetWeaver.

SAP BusinessOne and other products shall not follow these guides.

0

OH good catch! I guess I just default to NW

0
Luis Darui
Dec 09, 2016 at 06:16 PM
0

You should seek information within SAP Business One documentation:

http://service.sap.com/~sapidb/011000358700000032462013E.pdf

And SAP Note 928839

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Hello, this link isn't working.
0
Sudhakar Kuricheti

I just tested the link. It is working. You need to be logged in the SAP One Launchpad with your S-User and have proper authorization to open the documentation.

0