Our IT team also does team lunches, but we stepped it up a notch. We asked people in our team to participate in the Spartan Sprint race. Even...

Over the years we have been expected to produce more, do the work of more than one person, etc. But, over the weeks, months, years, there are busy times...

Cool.... so to confirm what you're saying. My production (principle) server pushes log shipping to server B while pushing mirroring to server C. How much of an impact...

I will need to meet with higher ups to determine amount of exceptable data loss.... we are running mirroring in a synchronous mode, we do not use the Witness.

I don't...

We really don't have a budget.... we would need to justify the need and see if they will approve. We need to recover within an 8 hour window, with...

I posted this question under the wrong forum.... I am using SQL Server 2008 R2.

That was the ticket.... when creating the endpoint, using a unique port number for that named instance was the answer. Now my witness is configured.

Thanks.

Melissa

I had read suggestions about not using the FQN... I put an alias in the hosts file. The reason this is difficult, is because I named the SQL Server...

An entire book about mirroring.... is there that much to go through on the topic? Does your book give all the T-SQL examples? And.... if I buy the...

When trying this command,

ALTER DATABASE SharePointDB

SET WITNESS = 'TCP://MirrorDB/SQLServerWitness:5033';

GO

I get the following error...

Msg 1449, Level 16, State 5, Line 1

ALTER DATABASE command failed due to an...

I'm almost certain I tried the forward slash.... but I will give it another try. Is there examples of this in the book you recommended?

I am also trying to setup Mirroring with failover, the witness instance is on the same server as the mirror instance. My mirror has the default instance name, and...