Hi, I have Database mirroring setup between two SQl 2005 servers (no witness). Using Tsql, I want to find if there is a user database on both primary and mirror server. I can use the following on mirror: select * from sys.databases where state <>1 and database_id>4 What should i use for Primary server? Any help? Regards Manjot ...
I have an application that I would like to have support SQL Server Mirroring. However, the architecture is currently such that multiple WCF services and DB connections will be enlisted in a single MSDTC transactions, and Microsoft states that MSDTC is not supported when using Mirroring. Their explanation is not terribly informative: ...
OK so I've been tasked with upgrading an application which involves updating schema in a sql server 2005. Now I've been told their dr environment has a mirrored database. I've read the msdn article on mirroring but am unclear how it impacts my upgrade. Do I: a) want to stop the mirroring (someone mentioned a wizard, but I'm not sure h...
Hi, I'm currently setting up replication in order to produce a database that will be used to run reports and take load of the main database. According to the guide at: http://msdn.microsoft.com/en-us/library/ms151799(v=SQL.90).aspx You setup mirroring, which we use for high availability after the publisher has been configured. I was ...
Hi SO, I am a programmer who has done a very bad thing and somehow didn't select the WHERE clause before hitting F5 on an update query in SQL Server 2008. I know this isn't a programming question but it is a question from a desprate programmer ... Is there anyway to get the one column's data back from the transaction log or a log kept ...