.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Disaster Recovery replication topology

Posted By:      Posted Date: September 15, 2010    Points: 0   Category :Sql Server
I've been trying to figure out the best way to set up replication for our Disaster Recovery. Currently we have five production databases replicating through five distributors to one data warehouse. We're looking to recreate the same set of servers with replicated data for our Disaster Recovery, but I can't figure out the best approach. We are using Server 2003, SQL 2005, and transactional replication. Between our production and Disaster Recovery, we are sharing a 45Mb/sec tunnel. Here are the scenarios I've come up with: Scenario 1: Replicate the production databases to our Disaster Recovery databases using the original publications and distributors. Then using our Disaster Recovery distributors, create new publications from the replicated databases and replicate again to our Disaster Recovery Data Warehouse. With this method I've encountered a couple problems already. First, our two busiest databases can not keep up over the WAN after the snapshot is delivered (i.e. latency continues to grow). and second, so far I haven't been able to replicate a replicated database, and I'm not even sure it is possible. Scenario 2: Use the original production databases and configure our Disaster Recovery distributors to replicate to both our Disaster Recovery databases and our Disaster Recovery Data Warehouse. This means adding a second distributor for each original publisher, and

View Complete Post

More Related Resource Links

Welcome to the SQL Server Disaster Recovery and Availability Forum

(Edited 8/14/2009 to correct links - Paul)Hello everyone and welcome to the SQL Server Disaster Recovery and Availability forum. The goal of this Forum is to offer a gathering place for SQL Server users to discuss: Using backup and restore Using DBCC, including interpreting output from CHECKDB and related commands Diagnosing and recovering from hardware issues Planning/executing a disaster recovery and/or high-availability strategy, including choosing technologies to use The forum will have Microsoft experts in all these areas and so we should be able to answer any question. Hopefully everyone on the forum will contribute not only questions, but opinions and answers as well. I'm looking forward to seeing this becoming a vibrant forum. This post has information to help you understand what questions to post here, and where to post questions about other technologies as well as some tips to help you find answers to your questions more quickly and how to ask a good question. See you in the group! Paul RandalLead Program Manager, SQL Storage Engine and SQL Express Be a good citizen of the Forum When an answer resolves your problem, please mark the thread as Answered. This makes it easier for others to find the solution to this problem when they search for it later. If you find a post particularly helpful, click the link indicating that it was helpful What to post in this forum I

Restoring a Service Application on Different Farm for Disaster Recovery


Hi All,

We are testing the Disaster REcovery scenario for SharePoint 2010 in multi-tenancy environment. The process I did is:

1. Created a sharepoint environment in a multi tenant scenario ( partioned the services while creating) and created few tenants with 1 or 2 site collections. (Parent Farm)
2. Created another environment with the same partioned mode. (DR Farm)
3. Tried to copy the site collection which is utilizing the Managed Metadata and restore it in DR farm along with the Parent Managed Metadata.

Everything is restored without error in the DR Farm (Site Collection and Service application and proxy). But, when I go to the term store (in tenant) I see a message like below:

"The Managed Metadata Service or Connection is currently not available. The Application Pool or Managed Metadata Web Service may not have been started. Please Contact your Administrator. "

Also, the document library's managed metadata column value which was referring to the Managed Metadata it's greyed out (Read-Only).

My question is:  How can I restore the service application and make it work and also how can i associate the site collection to use the Service Application which it was referring to previously.

I don't know if I need to restore the subscription also. I am not able to get enough information. In TechNet, w

How to implement backup/disaster recovery for our product?


Hi Guys,

Ive been tasked with researching adequate backup procedures for a bit of web software that we sell. Its basically a website and an express sql database that is deployed onto a customer server. Over the time the databse will fill up with conent and we want to be able to advise the customer how they can back our software up.

Im wondering we could do nightly backups of the sql server but can this be automated with sql server management studio express?

If not can we do replication or databse mirroring?

Anyway any help would be much appreciated not sure what the best approach is.



Sharepoint 2010 Passphrase Not Connected To Farm - Disaster Recovery



A few weeks ago i made a sql backup of all the sql 2008 database (just SharePoint dbs).
Lost that server. Had .baks on a backup drive offsite.
I restored the databases to a new windows server 2008/microsoft sql 2008 database server. I can connect to sharepoint_config.... but without knowing the passphrase I’m stuck.
I’m not sure what the passphrase is and resetting isn’t working (using SharePoint power shell ) due to me not being connected to that farm.

Anything i can do here? Thanks for any help that can be provided.

What is the best for Disaster recovery for Merge



I've got one Database Server sql 2005, which play also the role of the publisher ; with actually 50 databases.
Each database contains 2 publications (one for desktop, and the second for windows mobile).

This is merge replication.

The way of sync is done with IIS (sqlcesa.dll and replisapi.dll)

I want to be able to be ready if something occurs on my servers.

About the IIS, it's not a problem I guess I can easily duplicate them.
I've got also night backup (.bak) of all the database.

But about the SQL Server database with merge publication, how can I solve the troubles :"my sql server crashs" ?

I read something about peer to peer replication ; is it the solution ? I mean, i create a peer to peer replication between 2 servers on the datacenter.  Then I add checks on my applications to be able to switch from server A to B if problem.And if one crash, I just have to work with the second ; and as soon as the first server is reinstall I just reconfigue the peer to peer between the servers ?

Or is there other solution when there is replication on the server ? (I mean; if it was just a simple database, i'm sure there are easy steps for this).

I want to have a solution that will bring me a service level quality very high if something wrongs happens.



SQL disaster recovery



What is the best practise for SQL 2005 disaster recovery. Pls. assist.

Best Regards,


Prasanna Nayak

Data Recovery Software

Nokia mobile phone bulk SMS sending software sends unlimited text messages through a GSM based mobile phone connected with your computer system to other mobile phone. Bulk message broadcasting application sends business related messages, notifications, personal SMS, share market information, enterprise advertising news etc to any group or individual in a single click.
Group messaging wizard offers latest and advance technology to create and sends bulk text messages/SMS from your computer system or laptop/desktop via GSM based mobile phone to another mobile phone worldwide. Instant SMS sending software easily and smoothly works with all popular GSM mobile phone brands including LG, Nokia, Samsung, Sony Ericsson, Motorola etc. Nokia mobile phone mass SMS sending tool facilitates you to have strong relationship with your family, friends, customers etc.
GSM mobile phone SMS sending program is very useful utility for all small or large business enterprise to increase their business by sending event alerts, notifications, advertising to individual or group of customers. Mass messaging software provides solution to the user to send multiple SMS through GSM mobile phone connected through PC to nationally or internationally network based mobile phones.

SharePoint: Add a Recycle Bin to Windows SharePoint Services for Easy Document Recovery


Windows SharePoint Services helps improve collaboration and workflow while protecting documents and intellectual property. But one feature is conspicuously missing - an easy way to back up and restore deleted files from document libraries. In this article, the authors take advantage of the extensibility of WSS and its server-side and client-side object models to build a restore feature that works like the Recycle Bin in Windows Explorer.

Maxim V. Karpov and Eric Schoonover

MSDN Magazine February 2005

execute update timedout expires , table with trigger due to recovery of database


I have table A in database A  , in table A i have trigger to insert record to database B table A, each update and insert of database A -table A, triiger fire and insert record in database B table A, when i try to update some times asp.net application gives error

"Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding."

and then error log says System.Data.SqlClient.SqlException: Database 'database B is being recovered. Waiting until recovery is finished.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean ret

Password recovery by entering email not username



I am using the ASP.Net password recovery control.  By default the user needs to enter their username before an email gets sent out to them.

If it possible instead of entering the username, email is used instead?  Alot of my users forgets their username but not email.


merge replication system tables fragmentation issue

I have Merge replication going on in my environment. The problem is that system tables like MSmerge_content, MS merge _tombstone and MSmerge_genhistory are getting fragmented. We are rebuilding indexes time to time daily. But we want some good fix. Just send some good idea guys?

peer to peer replication, drop and add article of same name

We have peer-to-peer replication set up on our system (2005 EE). I would like to change the metadata of one of the tables (many of the tables actually, but right now I'm just trying to test out the process with just one table). As this is a high-availability system, I would like to stop the replication, make the changes on one node, verify that the changes are working, make the same changes on the other node, then re-enable replication. The ddl changes to the table are extensive enough that I have to clear them before executing. So I will handle re-populating the tables in a later step. Right now I'm just testing the process of stopping, doing ddl, then restarting. I am trying to implement this using scripts so as to minimize my clicking (and thus potential for mistakes) when doing it for real. I find that if I do the following process using the SSMS interface it goes smoothly with no errors (note that each step is conducted on both nodes unless specified): stop sync agents manually remove article: tblName1 with 'publications properties window' close 'publications properties window' make ddl changes to tblName1 (change column names, add columns etc. to a particular table) manually add article: tblName1 with 'publications properties window' re-enable agents But if I try the following, I get 'Peer-To-Peer topologies require identical articles in publications at all n

Transactional replication: Updates to one of my columns (sometimes) does not get replicated from the

hi, This is my scenario: I have a varchar(max) column on a table that is replicated to other servers. I have a stored procedure that does and update to this column and other columns on the table. This is done inside a transaction that also includes other updates. When I call the stored procedure, this one varchar(max) column's value is not replicated. When I just run the single update statement on its own, the value is replicated. Anyone know something about this? Thanks!    

Steps by Step document for configuration Merge Replication in 2005

Hi , Can anyone provide link to configure Merge Replication in 2005 with print screen.Also let me know the difference between Transcation level and Merge Replication. regards Vijay  

transactional replication and sp_MSupd tables

Hi thre, My target server keeps running sp_MSupd sp for different values in profiler and synch status shows "delivering replication commands" I keep waiting but this never ends. and ultimately we run a snapshot and it can't be applied. So recreate the whole replication again. It runs fine for a while but again, the sp_MSupd sp starts running on the target server and the replication goes down again. I don't know how to fix this. any advices?   Regards

Real-time data replication

Are there any ways to replicate sql server production database to a standby database? I notice that there is a feature called 'continuous replication', does it do in real-time? what is the time-lag? Are there any potential data loss (i.e., production transaction committed but production db corrupted before the transaction is sent to standby)? Is the standby database available for read access during the replication?
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend