Auto Backups of SQL Database

[Former Member]

Can anyone please tell me how we can enable the automatic backups of SQL Database 2008 R2??

[Sriram2009]

Hi Aamir

You can schedule the Backup task either in SAP Transaction code DB13 or any other third party backup tool (like Symantec Backup Exec). Kindly read the following SAP Notes

1878886 - Backup Strategies for SQL Server

1048382 - SQL Server: Third Party Backup Tool support

1420452 - FAQ: Restore and recovery with MS SQL Server

BR

SS

[Former Member]

Check out the following link https://www.youtube.com/watch?v=PxRfzO7MCwA this video will show you step by step method to create auto backup in SQL Server 2008 R2