Database Backup

[Former Member]

Hi Experts

We hav SAP NW 7.0 BI System and datbase is SQL Server 2005.

I am new to SQL Server, previously i have worked with Orale. In Oracle they provided back up tool call BR tools.

Can anyone please tell me how to take database back up in OS level ?

Thanks in advance

Uday

[Former Member · Accepted solution]

Hi,

The database backup is taken using the SQL Management studio in SQL 2005.

Please follow the steps as outlined in the help.

http://help.sap.com/saphelp_nw2004s/helpdata/EN/91/cd84bbb26b4c44adf982948cdf13e0/frameset.htm

and the Microsoft guide

http://support.microsoft.com/kb/930615/en-us

Regards,

Rohan.

[Former Member]

Thanks guys

[Former Member]

Hi Uday,

at OS level I would use sqlcmd.exe. Have a look at Books Online how to use sqlcmd or have a look at this [link|http://technet.microsoft.com/en-us/library/ms180944%28SQL.90%29.aspx] (example D).

Regards,

Sven