I’m new to my current company and we have a System Administrator but no DBA. In the past I’ve taken care of DBA related issues at other companies. I’ve run into and corrected database corruption in ...

I have a SQL Server 2008 R2 mirror setup running in high safety with automatic failover (synchronous, witness). Over two different nights, the mirror and the primary will be shut down and re-racked. ...

I'm trying to understand what effect database mirroring can have on replication in SQL Server 2008.
Here is current environment: (don't ask me why it was done this way or to change it)
Server A: SQL ...

I am considering to turn off the transaction safety to maximize the performance.
Before that i am interested in finding the current status of transaction safety. Is there any command that we can get ...

I've been trying to enable TDE in a mirrored SQL Server 2008 R2 configuration. Enabling TDE is not so difficult, though when I enable TDE on the principal, the mirror database goes in to a suspended ...

We are trying to figure out which of the below statements is correct when talking about SQL Server mirroring:
The master database server executes the query, and takes the resulting transactions and ...

I have an SQL Server 2008 R2 Standard with around 80 databases, 18 of which are a synchronous mirror primary.
I'm having a lot of complaints about database speed lately, so I've started digging with ...

I have principal server:A and mirror server:B with DB Name: "DBTest"
On the server A there is a username (SQL auth.) call: user1 and is mapped to "DBTest".
the Same is on Server B, same username and ...

I have two SQL server 2012 instances and I want to configure mirroring between the 2 servers with database.
My questions are:
How can it automatically change host of one if the other one was dropped ...

Let's assume that two SQL Server instances (S1 and S2) are in synchronous mirroring or in a synchronous Availability Group. Now the following happens:
A write happens on S1 and transaction commit is ...

So we have a couple of SQL Server instances involved on mirroring without witness and operating mode is asynchronous in all cases.
After we set put mirroring in place, we started facing connections ...

Is there a way to use SQL Server Replication without a network connection?
My would-be publisher is an SQL Server 2005. It is on the "outside" as it is connected to my company's primary LAN, which is ...

The last time my company had tried to mirror some databases, everything worked great until one morning they came in and the primary database in one of the mirroring schemes was just blank. They had ...

I'm a software dev with little experience managing SQL Server so please bear with me.
We are developing a piece of software that needs to be highly available, with a significant degree of resilience. ...

Our web application suffers DB query timeouts a few times a day at random times. Can you help to work out the cause, e.g. deadlocks, mirroring (disk or network), etc?
We have two identical database ...

I want to keep several tables in two different databases mirrored. Both databases are within the same server, and both are SQL Server dbs. This mirroring only affects the data they contain, not the ...

I have a query about microsoft sql server. I'm looking for migrating ms sql server from one vendor to another vendor(Datacenter). I'm looking to have a mirror configuration between servers since my ...

We have a live sql server in one location, running MS SQL Server 2005 Enterprise on Microsoft Windows Server 2008. We have a similar server in an alternative location (connected by vpn) serving as a ...

We've got a very simple mirroring setup here: just a principal DB and mirror DB, no witness, running in high-performance mode with SET PARTNER SAFETY OFF.
This problem has happened to us twice now: ...

I have two SQL Server 2008 R2 instances installed on same Server and the engine log on as Network Service account which is set by installation.
there is a database TestDB on both instances. I try to ...

As part of a SQL Server deployment, it was proposed to use Database mirroring as a redundancy option as well as allowing for Reporting and MI to be detached from the Operational DB.
The proposal is ...

we are developing an application for a company and this company has 3 branches, we design a SQL server for our application we can put this server in one of the branches but as the connection between ...

How is it possible that the time to send value is greater then the mirror commit overhead? The mirror operates under full safety so this means that the commit is only done @ principal when the commit ...