Question - What advantages does this method have over the detatch/reattach method of moving files around?

I've always just detatched/reattached whenever I move a database, and the time consuming part is...

I ran into that with some of my servers a couple of years ago. If I recall correctly, our hardware team was doing full server-level backups (or maybe just...

I'd try to run Perfmon against your source and destination disks and see if either of them are giving you less performance than you think they should.

Putting it in an EXEC('') seems to have done the trick. Thanks!

Hmm. Didn't catch that bit about "and the connection isn't closed" in BOL. Thanks.

I'll give the "wrap it in an exec" route a whirl and see what happens.

Thanks!

Hadn't even thought about that...that's a good thing to check. I haven't installed any, but I do have Visual Studio 2010 and Visual Studio 2008, as well as TFS...

There is sp_estimate_data_compression_savings - but that estimates savings you will get if you turn on database compression. Not sure if the numbers there would give you a super accurate...

Probably the best way to figure that out would be to install developer edition, restore your database on it, then do a compressed backup of it.

Keep in mind that a...

I'm having this same problem. I'm not using AWE, but tried giving the service account the "lock pages is memory" rights just to rule it out as a cause.

It's...

mrTexasFreedom (9/29/2011)

Wow. What kind of maniacs embedded that hidden pitfall...

Might check that the "enabled" checkbox is checked in the operator properties, and that you don't have a pager on-duty schedule set up that is preventing the e-mail from sending.

You'll need to stop the mirroring session prior to the restore, and you'll need to redo your mirroring session after the restore.

I'm pretty sure if you try to...

paul.knibbs (6/17/2011)

It doesn't--I had to look it up as well....

SQL 2005 BOL doesn't list DaysUntilExpiration as an option. SQL 2008 BOL does. Might be why some people are missing it. (It's why I missed it anyway)

Cool! I never realized you could put AT in your EXEC statements. Neat!

Thanks!

Jason