attaching new LUns to a Windows server 2008 on will automatically offline the disks as part of the Diskpart offline policy. This is mainly to avoid the situation where more...

jayoub (12/12/2014)

---

I have a problem with two SQL Server 2008R2 SP3.

I get the following error when i try to add a database or make a backup or attach...

Can you post the results of the following, replace "yourdb" with the name of the principal database names that have the issue

SELECTDB_NAME(database_id)

, mirroring_safety_level_desc

, mirroring_witness_state_desc

FROM [sys].[database_mirroring]

WHERE database_id IN (DB_ID('yourdb'),DB_ID('yourdb'),DB_ID('yourdb'))

So you have multiple Principal servers?

Are all the...

Manual or automatic failover are not available for asynch mirror sessions, do you have any?

Where asynch is in force you'll need to set Safety on, run from the principal

ALTER DATABASE...

are the sql server services running??

suedunham2 (12/15/2014)

---

My recommendation to my manager is to base recovery on .bak and .trn files. However the .mdf and .ldf files can be backed up without being detached and I...

Have you checked the state of the mirror endpoints? As a matter of course I would restart them.

yes, unfortunately TDE negates backup compression.

Shahzadi (11/26/2014)

---

The only drawback is that if somehow secondary server goes offline for an hour or so, log shipping will not catchup. but in normal log shipping everything comes backup...

what did you do in the end?

it shouldn't be a problem where the instances are already installed, ideally you would want to setup your cluster and soak test before you start deploying applications (clustered or non...

you don't have to set a gateway on your NIC if you don't want to, but you won't have any ability to go outside your own network.

During cluster creation the...

so, if i'm reading corect now you're not deploying a failover cluster instance of sql server you're deploying standalone instances and intend to use AlwaysOn availability groups, is that correct?

Can...

This is not performed exclusively on its own, it's part of a serious of steps and includes setting the underlying RAID stripe size and partition offset.

What work have you done...