Browse by Tags
All Tags »
replication (RSS)
One of the client referred about the error during the execution of Upgrade Advisor: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Initial thoughts lead to checking the SQL Server timeout
Read More...
Sometime ago I have blogged about MSDN labs- SQL Server Virtual Labs - fully featured virtual environment for testing! and I recommend and encourage all of my users to use Virtual labs and webcasts - use them for a better practice on product . Similar
Read More...
One of our client had such requirement to cater a load balancing for their application and needed to upgrade to higher versions of SQL Server & Operating systems. The current setup at their end is a SQL Server 2000 Active/Passive Cluster and the transactions
Read More...
At first I was amused to see the title and there is lot more information which is granular that you need to know. Replication is intended to be a way of distributing data automatically from a source database to one or more recipient databases. As such,
Read More...
One of my Dev. DBA asked me this question about whether we need to use NOINIT or INIT for a differential backup schedule. Think about availability option in this case, you can overwrite the existing differential backup using INIT clause but when it comes
Read More...
I feel like there is lot of confusion ( new users ) in deciding which build to apply after the re-release of SQL Server 2005 Service Pack2 during the month of March 2007. So here is the list of references I would like to share in explaining what is what
Read More...
What happens to the Replication when the SQL instance failover to the mirroring server as it is involved in Database Mirroring session? Choosing Transactional Replication is best choice in the setup of Database Mirroring if you would like to provide such
Read More...