如何将我的sqldatabase express 2008 r2与lan同步？ [英] how to synchronize the my sqldatabase express 2008 r2 with lan?

问题描述

如何同步我的sqlserver 2008 r2与lan？每小时数据备份必须创建。一个副本应该在局域网中，另一个副本应该在我的本地系统。请帮助我............................

how to synchronize the my sqlserver 2008 r2 with lan?for every one hour data backup have to created. one copy should be in the lan and another copy should be at my local system .please help me ............................

推荐答案

1。根据您所需的时间间隔创建作业并进行计划。这会将数据保存到本地磁盘的定义位置。

2.写一个Windows服务并在30分钟后安排它（似乎数据库备份需要30分钟到本地），这将复制保存的备份到定义的网络位置。

1. Create a job and schedule it according to you required interval. This will save data to the defined position of the local disk.
2. Write a windows service and schedule it after 30 mins (it seems database backup needs 30 min to locally) that will copy the saved backup to the defined network location.

这篇关于如何将我的sqldatabase express 2008 r2与lan同步？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！