on 09-03-2010 11:04 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks guys
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.