How to backup MSSQL database in ECC6

[Former Member]

Hi guys, i am doing patching for our internal ECC6 server. So i need to backup the database before run the patches. I have onliy done database backup in Oracle using Brtools. So i am not familiar with Ms Sql Server backup. Can anyone tell me step by step to do this backup and send me link or screen shot or any type of documents or guidence which help me to resolve this issue. I really appreciate a prompt reply from you guys. Would like to thank you in advance.

[Former Member · Accepted solution]

Hello Ram,

This Notes can be very helpfull to you if you want to implement a backup strategy.

44449 - Backup strategies with the SQL server

1048382 - SQL Server: Third Party Backup Tool support

413516 - Backup tools for SQL server and SAP

For how to backup a DB in MSSQL please check the BOL:

http://msdn.microsoft.com/en-us/library/ms187510.aspx

Regards,

Victor.

[Former Member]

You can take backup through DB13/SQL server management studio.

Regards,

Nikunj Thaker.

[Former Member]

you have to create a new backup device at SQL level( tape drive or nework drive ). after that you can backup using DB13 or directly by SQL server studio

Thanks

[Former Member]

Hello Ram,

You can take the backup of MSSQL server using SQL server Management studio,

Refer to http://technet.microsoft.com/hi-in/library/cc966495(en-us).aspx for procedure of taking the backup

Rohit