MS SQL administration / backup in SAP

[Former Member]

Hi,

I have worked mostly with SAP and Oracle environment. Now I plan a backup plan for SAP ECC system with SQL server 2005.

So please help me to get some link where I can learn about backup and restore of SQL server in SAP environment.

Regards,

Nallasivam.D

[Former Member]

Hi Nallasivam,

You can schedule all your backup in db13 and can take the unscheduled backup at mssql level.

Go through the online documentation on mssql 2005 ,backup/restore is mentioned there.

http://msdn.microsoft.com/en-us/library/ms187048(SQL.90).aspx

Regards

Ashok Dalai

[Former Member]

Hi,

can you look at this

[http://help.sap.com/saphelp_nw04/helpdata/en/f2/31add4810c11d288ec0000e8200722/frameset.htm]

Regards,

Muralidhar

[Former Member]

Hi Keane

Check this [Link|https://www.sdn.sap.com/irj/sdn/mss]

Regards

Uday

[Former Member]

Hi Nallasivam,

Please refer http://msdn.microsoft.com/en-us/library/ms187048(SQL.90).aspx

http://help.sap.com/saphelp_nw70/helpdata/EN/f2/31add4810c11d288ec0000e8200722/content.htm

http://help.sap.com/saphelp_nw70/helpdata/EN/f2/31adc8810c11d288ec0000e8200722/frameset.htm

[Guide|http://help.sap.com/businessobject/product_guides/planning10/en/SQL%20Server%20Setup%20Guide%20for%20Business%20Objects%20Planning.pdf]

Also use Note 555223 - FAQ: Microsoft SQL Server

Regars,

Nibu