automatic DB backup regularly from Server to another system

Question

I want to take automatic DB backup regularly from Server to another system. I need step by step process......... Thanks in Advance

Mark Willium · Answer

Shiva, follow below steps to create database backup using Maintenance Plans: Go-to the SQL Server Configuration Manager > SQL Server Services > Run SQL Server Agent (Set it to Run Automatically) Go To SQL Server Management Studio, Find TAB Management > Maintenance Plans. Right Click > Maintenance Plans Wizard. Text your maintenance plans, ex: DailyBackup. Select Option button : Single Schedule for entire task. Click Configure > Set Schedule according your demands. Select Maintenance tasks. for this case, you choose Full Database backup. Click Next, then define which database to backup, set backup location, and backup extension. Click Next, Choose your report mode, then Finish. Note: SQL server agent is not available in express edition. Ref: http://stackoverflow.com/questions/14616764/sql-database-automatic-back-up

Upendra Pratap Shahi · Answer

https://www.linode.com/docs/databases/mysql/back-up-your-mysql-databases http://www.papercut.com/products/ng/manual/ch-sys-mgmt-backups.html http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=37089

automatic DB backup regularly from Server to another system

Answers (2)