SQL 2005 Replication

[Former Member]

Hi Experts,

I've installed SAP B1 2007 B PL-04 .

But the problem is ---Everyday I need to take a backUp. Can u tell me regarding the replication or any other way

that will keep an automatic BackUp?

Rgds

Subrata

[Former Member · Accepted solution]

Hi Subrata

You could use the backup service which integrated in the server tools

to do the daily backup job.

It can be found in the service manager.(Just like the license manager)

Regards,

Syn Qin

SAP Business One Forums Team

[Former Member · Accepted solution]

Thanks for Reply,

Plz tell me , what would I've to do for that?

If I start SBO BackUp from SAP Business One Service Manager, will it work?

Where will it keep the back up?

Does the back up restore/retrievable?

Rgds

Subrata

[former_member1190345 · Accepted solution]

HI Subrata,

One of the reasons why the SBO Service manager has been given is that you can use this service to take auto backups whenever you want as per the timing settings given by you in the Service manager.

The Service manager keeps the Back ups in the folder in the directory mentioned by you in the Service manager. When you open the service manager and then open the settings tab here you need to mention the directory and the path.

And yes it is very much retreivable ....you can retrieve the same from the place where you have stored the file as mentione above.

Hope this helps.

Nagesh

[Former Member · Accepted solution]

Thnks for reply again.

Does it effect the job during taking the BackUp?

Would users have to stop their tasks at that scheduled time?

Rgds

Subrata Chatterjee

[former_member1190345 · Accepted solution]

Hi Subrata,

Not at all .....the SBO service does a back ground job of taking backups as per the timing you have set. ie. say you have set back ups to be taken after ever 3 hours then the users do no need to stop their work after every 3 hours so that the system takes the back up. It is an internal background job.

Hoep my replies have helped you .

Nagesh

[Former Member · Accepted solution]

Hi Nagesh,

failed to take backup.

Basically, my Database Server is in SAPBD whereas Application & License SERVER is in SAPAP.

I defined in SBO BackUp of SAP Business One Service Manager as---

Schedule--->

On Specific Date--8/22/2008

4:30:00 pm

Settings----

---

>

D\Backup

Connection------->

Server -->SAPBD

Usercode

Password

Database -

---

>

Choose Datbase Name

Atlast I started the SBO BackUp Server.

But still it doesn't work.

Rgds

Subrata

[Former Member · Accepted solution]

Hello,

A .BU file is generated after taking the SAP Service Manager SBO BackUp .

Could u tell me how will I restore the backup in my database?

Plz help.

Subrata

[Former Member · Accepted solution]

Hi Subrata

The BU file is the backup file of your DB.

You can restore this file to your DB just like a normal SQL Server backup.

Regards,

Syn Qin

SAP Business One Forums Team

[Former Member]

Hi Subrata,

For the quickest and most cost efficient way of replication in SQL 2000/ SQL 2005 you should consider Log shipping / Asynchronous replication.

The overview of log shipping is as follows :

1) A primary server which holds the main db for sap business one and a secondary server holding the backup db.

2) At initialization, the primary sever via log shipping sends an instance of the db to be restored to the secondary server. Thereafter you configure the log shipping for various times to transfer logs from primary to secondary. The logs are then applied accordingly to the secondary server via sql scheduled job.

3) If the primary fails, you can simply switch to the secondary server and the data loss which you possibly face is the time duration you set for the log shipping. For example if you set the system to transfer logs every 20 minutes between the primary server and secondary and assuming the primary fails at 1.00pm, you can then switch to the secondary server which will be replicated upto 12.40pm with the latest logs applied to it. Offcourse the time slot of 20 minutes can be configured according to your requirements and since the two servers can be in one lan or wan, it is flexible in design.

One thing you must note is that the seconday server is a warm server and will not automatically be available after the primary has failed. Otherwise it would similar to clustering. The administrator must check logs to ensure the process is running smoothly and if primary fails, it is a simple manual sql command to get the secondary sap business one database live. Your can then direct the SAP business one clients to choose the secondary server and continue working while you deal with the primary.

You can find more notes with the following link :

http://msdn.microsoft.com/en-us/library/ms190016(SQL.90).aspx

Best of luck and I hope this solution will resolve your query.

Kind regards,

Indraj.