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

-
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 ..
Question
Answers
-
here is the simple solution
Ramesh Babu Vavilla MCTS,MSBI
- Proposed as answer by Allen Li - MSFTModerator Thursday, November 07, 2013 7:01 AM
- Marked as answer by Allen Li - MSFTModerator Thursday, November 14, 2013 1:45 PM
-
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.aspxBest Regards,
Allen LiAllen Li
TechNet Community Support- Marked as answer by Allen Li - MSFTModerator Thursday, November 14, 2013 1:45 PM
All replies
-
-
Please refer following links.
-
-
-
here is the simple solution
Ramesh Babu Vavilla MCTS,MSBI
- Proposed as answer by Allen Li - MSFTModerator Thursday, November 07, 2013 7:01 AM
- Marked as answer by Allen Li - MSFTModerator Thursday, November 14, 2013 1:45 PM
-
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
-
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.aspxBest Regards,
Allen LiAllen Li
TechNet Community Support- Marked as answer by Allen Li - MSFTModerator Thursday, November 14, 2013 1:45 PM