将Sqlserver数据库同步到本地sql服务器数据库(SQL SERVER中的日志传送) [英] Sync Sqlserver Database to local sql server database (Log shipping in SQL SERVER)

问题描述

我正在使用MS-SQL SERVER作为数据库.和并行plesk面板作为我网站的控制面板.

我想将网站服务器数据库中的数据同步到本地主机数据库.但我无法做到.

请帮我，并提供一些解决方案以完成此任务.

I am using MS-SQL SERVER for Database. and parallel plesk panel as a control panel of my website.

I want to Sync data from my Website''s server database to localhost database. but i can''t manage to do it.

Please, Help me and give some solution to do this task.

推荐答案

您可以阅读有关复制的信息:
http://msdn.microsoft.com/en-us/library/ms151198.aspx [ ^ ]

http://www.sqlserver-training.com/video-how-to-setup-replication-with-sql-server-2008/- [

You can read about Replication:
http://msdn.microsoft.com/en-us/library/ms151198.aspx[^]

http://www.sqlserver-training.com/video-how-to-setup-replication-with-sql-server-2008/-[^]

Or just do a backup of your .mdf and .ldf file :)

Hope it helps.

尝试这些文章:
http://www.red-gate.com/products/sql-development/sql-comparison-sdk/learn-more/synchronizing-databases

http://technet.microsoft.com/zh-cn/sqlserver/dd407782.aspx

Try these articles:
http://www.red-gate.com/products/sql-development/sql-comparison-sdk/learn-more/synchronizing-databases

http://technet.microsoft.com/en-us/sqlserver/dd407782.aspx

这篇关于将Sqlserver数据库同步到本地sql服务器数据库(SQL SERVER中的日志传送)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！