database-mirroring
FailOver causes "The underlying provider failed"
We implemented database mirroring for WCF and set up failover partner in connectionstring as following[详细]
2023-03-28 08:54 分类:问答Don't quite understand SQL Server transaction logs
I\'ve read up on SQL Server transaction logs, but still not entirely comfortable with how to use/manage them. I get that they are important for things like transaction rollbacks, mirroring, replicatio[详细]
2023-03-04 20:00 分类:问答Can off-line changes in seperate client-side IndexedDB databases be merged when the browsers get back on-line?
IndexedDB in Firefox 4 allows us new potential for making apps for client-side database querying and storage, while both off-line and on-line. This is a very new alternative and very interesting, sinc[详细]
2023-02-06 16:49 分类:问答Reporting Services and SQL Server Mirroring
In an installation with 2 SQL Server 2008 SP2 S开发者_如何学Ctandard servers we use mirror to have failover partner for the databases.[详细]
2023-02-01 02:03 分类:问答sql server 2005 mirrored database transaction log file maintenance
Ok so for standard, non-mirrored databases, the transaction log is kept in check either simply by having the database in simple mode or by doing regular backups. We keep ours in simple as we have SAN[详细]
2023-01-22 16:38 分类:问答SQL Server 2008 Mirrored DB Update Rollback - Crisis
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.[详细]
2023-01-21 22:24 分类:问答Configuring replication after mirroring - is this possible?
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.[详细]
2023-01-14 09:56 分类:问答Upgrading sql server database that is being mirrored - how to?
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 o[详细]
2023-01-12 08:41 分类:问答Why is MSDTC not supported when using SQL Server Mirroring & Automatic Failover?
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 MSDT[详细]
2023-01-07 12:44 分类:问答TSQL to know if database mirroring is setup for both PRimary and secondary server
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.[详细]
2023-01-04 12:23 分类:问答