Upgrading SQL for SAP Business One

[Former Member]

Hi All,

What is the best option when it comes to upgrading SQL Server from SQL 2005 to SQL 2008 for SAP Business One

Creating a new instance Vs. Upgrading current instance

What is the best industry practice?

Thanks and Regards,

David

[former_member445201 · Accepted solution]

Hi dtengani,

I have recently gone through the same issue.

Best practise is to install SQL2008 on a new server, back up your DB on sql2005 and restore to SQL2008. if you cannot do this you will need to uninstall sql 2005 and install SQL 2008 (remember to also back up your Database(s)). I would upgrade to new DB. It is not recommended to run both versions as SQL is very resource hungry. If you do this your server resources will become very heavy.

Go with a operating system on 64 bit as 32bit OS will only support 4GB RAM max. With 64 bit OS you can handle more than 4GB RAM. I have my SQL server on 24GB RAM with room to expand :). Hope this helps.

[Former Member]

Hi All,

Thank you all for your feedback.

From all your tips I can gather that the best practice would be to uninstall the current instance, ofcourse after backing up your DBs and perform a new installation of SQL rather than upgrading or running two seperate instances.

You also all perfect sense when you point out the resource factor when running two seperate instances.

Thank you all!

David

[Former Member]

Hi,

When upgrading from SQL Server 2005 to 2008.

- Backup your database.

- Uninstaller SQL Server 2005 so that all instances and services will

not consume process memory consumption.

- Install SQL Server 2008.

- Restore your database.

Regards,

Clint

[jbrotto]

You could upgrade the current instance but I think it would be faster to back up the db and restore on 2008 if you are using new hardware. If it is the same machine there should be no need to restore the db. Also keeping it the same instance should make add ons work problem free as nothing would have changed.