Scheduler SBO backup do not memorize

[marcozer]

Hi,

I want that my backup start at specificed time  but the Scheduler SBO backup do not memorize my settings. Why? Every time I open the Scheduler SBO backup"  , it always shows: " -On Specific Date- with current date and time".

I use 8.82. patch 9

Thanks

Marcozer

[KennedyT21 · Accepted solution]

Hi Marco Zer...

Collation Settings of MSSQL Server 2005 or 2008

Symptom

When defining the wrong collation during manual installation of MSSQL Server 2005 or MSSQL 2008, in certain situations it might cause functional problems. Examples:

1. When trying to use any functionality of Drag & Relate, the following error message will be displayed: 'No matching record found'.

2. When runing "Sales\Purchase analysis report" for Business Partner, the report might not retrieve any results eventhough it should.

Other terms

MSSQL 2005, MSSQL 2008, SQL server, documentation, collation, Drag & relate, drag and relate, collation settings, collation setting, SQL 2005, SQL 2008

Reason and Prerequisites

Consulting Note

Solution

The latest version of any documentation can be found at http://service.sap.com/smb/sbo/documentation.

Please make sure to choose collation setting of: SQL_Latin1_General_CP1_CI_AS

when installing MSSQL 2005 / 2008 Server.

In order to check what the collation is set to in your server, please run the following query:

Collation of your Server:

select SERVERPROPERTY ('collation')

(This query gets the collation settings of MSSQL Server's System Database "Master")

Expected answer : SQL_Latin1_General_CP1_CI_AS

In case you have already installed the MSSQL 2005 or 2008 Server with any collation other than SQL_Latin1_General_CP1_CI_AS, please follow the steps below:

Change your server collation to SQL_Latin1_General_CP1_CI_AS.

You can find Microsoft's instructions for changing an SQL server collation here:

http://msdn2.microsoft.com/en-us/library/ms179254.aspx

Please note that collation settings of Database "Master" needs to be changed only. All SAP Business One Databases must not be changed! These must remain on SQL_Latin1_General_CP850_CI_AS.

If you need any clarifications with this process please refer to an Expert Empowerment Session "SQL 2005 Server Collation settings" at https://websmp203.sap-ag.de/~sapidb/011000358700000050892007E/ or http://service.sap.com/smb/sbo/support -> Archive: Empowerment Sessions.

If you have any Servicepack for MSSQL Server installed, but the Servicepack is not included into your DVD MSSQL Server, do as follows:

1. Deinstall Servcicepack

2. Change Collation Settings as per Expert Empowerment Session

3. Install Servicepack again

Regards

Kennedy

[marcozer · Accepted solution]

Dear Kennedy,

Absolutely many thanks for your help and for your time.

I applied your query and effectively the collation setting is different!

I cannot ope the SAP links. Is it possible to receive them by mail?.

Thanks again.

Regards,

Marcozer