Automatic backup and restoring of SQL server 2008 R2 database from one server to another

Question

We have a database in server A which has to be automatically backed up and restored into another server B periodically. I need a notification on the process completion from both server A and server B for backing up and restoring respectively.

Please help ..

Answer 1

use database mail to send the email after restore is completed

---

Ramesh Babu Vavilla MCTS,MSBI

Answer 2

Please refer following links.

http://technet.microsoft.com/en-us/library/ms187048.aspx

http://technet.microsoft.com/en-us/library/ms175477.aspx

Answer 3

Please guide me to automate the backup and restore process of database.

Answer 4

Is there any software tool that can be used to automate the process...

Answer 5

here is the simple solution

http://www.sqlservercentral.com/blogs/powersql-by-prashanth-jayaram/2013/08/19/sqlcmd-database-backup-and-restore-automation-quickest-and-simplest-method/

---

Ramesh Babu Vavilla MCTS,MSBI

Answer 6

If you want it automated, the simplest way would be to use Snapshot Replication. 

Please see:

http://technet.microsoft.com/en-us/library/ms151734(v=sql.105).aspx

Answer 7

Hi TUSHAR SHETTY,

We can use Log Shipping. For more detail information, you can refer to the following link:

Configure Log Shipping (SQL Server)
http://technet.microsoft.com/en-us/library/ms190640.aspx

Best Regards,
Allen Li

---

Allen Li
TechNet Community Support