Skip to Content
avatar image
Former Member

Database Backup

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 03, 2010 at 10:11 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 03, 2010 at 11:18 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 06, 2010 at 10:45 AM

    Thanks guys

    Add comment
    10|10000 characters needed characters exceeded