Thanks for the answer. I guess it's basically block level replication between 2 servers...

Thanks to both of you. I've tried it using details from ConnectionStrings and with "Failover Partner", neither seemed to work.

It looks like there's a SQL Server 2008 add on for...

Hi Nakul,

I'm hoping you're still monitoring this thread. I'm looking for some help in making a UDL connector mirror aware. In the "All" tab I've entered "Failover Partner=<servername\instance>" but this...

I never even noticed the typo, my brain just equated "v3=v2" to "v2=v3" and saw them as the same thing.

Guess it's a good job I'm tired

Yes, otherwise you're simply regenerating the encryption based on the existing certificate.

Argh... Shot down in flames by your sharp eyed skills

You're right of course. I have actually only used it against Data files in the past, and now I'm hoist...

You can try shrinking it with NO TRUNCATE, which should move all the free space to the end, then shrinking again with TRUNCATE_ONLY to get rid if the free space.

I've...

You're not changing the certificate, you're simply regenerating the encryption. To change the certificate you would have to use:

USE [DB_NAME];

GO

ALTER DATABASE ENCRYPTION...

Not until Denali gets released. Currently you can only have a single mirror. If you want two locations then you have to mirror to one and log ship to the...

True, if he's letting the schedule run it, but if he's doing a right-click and execute job, then I think it would use his permissions.

You're right though, without more information...

Sounds like the package is using your authentication when you're logged in to Management Studio, and presumably the Agent account authentication when your not, and I would guess the Agent...

UPDATE:

We've tested this now and found ut to be consistent behaviour, if the database named in the job step:

EXEC @ReturnCode = msdb.dbo.sp_add_jobstep @job_id=@jobId, @step_name=N'Step Name',

@step_id=1,

@cmdexec_success_code=0,

@on_success_action=1,

@on_success_step_id=0,

@on_fail_action=2,...

We've just (today) encountered a situation where SQL Agent jobs do actually appear to be "Mirror Aware". We have a set of backup jobs for databases running on the principal...

Great question Hugo.

I enjoyed doing the math, even though I got it wrong through a silly calculation error, but it was fun having a dive into the Math behind the...

The new SQL boxes we're moving to now (with hyperthreading) report 80 cores, (I believe they are running 2 - 20 core processors). If this means that we would move...