how to schedule backup on SQL database backend

[Former Member]

Hi,

We have installed CRM5.0 on SQL2005 database at first time. My concern is in oracle database we schedule through DB12 twi types of backup Onlie and offline.

But in SQL backend how many types of backup? is that same like online and offline.

Can we schedule the backup through DB13? or do we need to schedule throgh SQL level and OS level.

Please suggest backup strategy using SQL backend.

Thanks

Lisa

[Former Member]

bakcup master/MSDB/PRD databses every day ( complete)and Log backup every 30minutes

[Former Member]

Hi Lisa,

The types of backup in SQL2005 are mostly the same.

We have the Full/Incremental/Differential DB backup along

with the transactional log backup. Not neccessary to have

access to OS level for scheduling backups, DB13 can be

used easily for backups. A good strategy would be to

first have a complete DB backup, thereafter periodic

incremental DB backup/transaction log backup would be

suffucient. The periodicity could depend on the usage

requirements.

Hope this helps.

Regards

Srikishan