Backups for sqlserver and SAP

[Former Member]

Hi Gurus,

I want to know the some information related to backups in SAP and SQLSERVER also.

I have installed solman,ecc,ep on windows 2003 and database is sqlserver 2005.

Till now I am taking full database(offline) backup weekly once through SQLSERVER MANAGEMENT STUDIO.

But I have not scheduled any online backups through DB13 moreover I want to take file system and transaction log backups also.

As I am new to this backups please let me know the following queries.

1)What strategy(backup) should I need to follow in order to take database and log and files also,please give me suggestion.

2)As per my knowledge we have to adjust some parameters related to backup in the file initsid.sap,but in ms sqlserver I am not able to find initsid.sap,please suggest me where can I find this file.

3)In sqlserver where can I find brtools information(please specify path),and also let me know from DB13 how can I schedule backups.

If possible please send me any specific link related to all my above queries.

Your help would be more appreciable

Many thanks in advance

rk.

[Former Member]

answered