cancel
Showing results for 
Search instead for 
Did you mean: 

How to take SQL Server Database backup from DB side

Former Member
0 Kudos

Dear All,

Please suggest how to take SQL Server Database backup from DB side?

System Info-

Portal Server (EP7)

MS SQL Server

Microsoft Windows 2003 Server

Suggest ASAP.

Thanks & Regards,

Sameer

Former Member
0 Kudos

Hi,

I am planning to take SAP DB backup I need the procedure how to take backup. With in the server.

My Operating System is IBM AIX

Database is Oracle 10g

SAP BI7.0 through this I need to take backup.

Note:

1) First of all I gone to /oracle/<SID>/102_64/dbs/init<SID>.sap and I changed the settings backup_dev_type = disk

backup_root_dir = /home/db0/test/sateesh/DB0backup

stage_root_dir = /home/db0/test/sateesh/DB0backup

2) Then I gone to BRTOOLS I changed to disk there I scheduled Online backup

3) Then I came to SAP DB13 I want to take daily backup. But the backup is not going properly what to do any mistake I had done

Try to give the valuable solution to take Online backup

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Sameer,

Just use enterprise manager as suggested by juan,

Logon to it using sidadm,it will take the user id by default just logon.Then select your server and then rightclick on the database go to tasks then backup.

You can schedule full or transaction log backup.

You can take the option of backing up to tape or disk,select your device and give a name as you want the backup file to be.

Reward points if helpfull.

Regards,

Vamshi.

Former Member
0 Kudos

Dear Juan/Vamshi,

Can we take offline or online backup?

Sameer

Former Member
0 Kudos

Dear Sameer,

You can take a full online backup using the management studio.

Reward points if helpfull.

Regards,

Vamshi.

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi

Go to Start manu -> choose SQL studio

sql screen open select SID and click

and provide path where you want to store.

file extention must be BAK.

thanks & regards

Arpan Saini

JPReyes
Active Contributor
0 Kudos

Just use the MSSQL Enterprise manager... Backup options are in the menu.

Regards

Juan

former_member249185
Participant
0 Kudos

Hi,

You can use Tivoli Backup software with TDP client for SQL.

What about remain systems ? How you backup them ?

Thanks & Regards,

Charanjit Singh.