Theoretically when the retention period...

This problem has been driving me nuts for a month! I finally recognized what it was doing, thanks for posting the fix, hopefully I can take care of it...

(I started writing this probably over a week ago and somehow never posted it!)

I just completed a further test. I have a server that has only had 2005 installed...

--There are no files being written to the directory specified in the maintenance plan.

--Looking at the dbo.backupset table, there is no activity at the time the job runs or when...

That's easy, I would be dead. I was born with a heart problem, and even 10-20 years earlier, I probably wouldn't have made it out of infancy.

But assuming I...

The DB was patched from SP1, not RTM. I won't deploy RTM for production.

The corruption of Master was immediate and prevented SQL Server from starting. I have not...

No R2, thanks for the info though. Right now one production 2008 with a second coming online soon, and a smattering of 2000 and 2005.

I'm guessing it's a fluke...

Gail definitely rocks, I met her at PASS a couple of years ago and attended one of her panels.

And doing file names with embedded date is so massively beneficial that...

GilaMonster (10/20/2010)

Yes.

It's not data loss that Wayne's suggesting mirroring for. It's downtime. Sure, you could...

We've never had a data loss with our SAN, we have had disks failed and replaced, but that's never resulted in downtime. Our previous NAS box died bigtime, but...

If you need 24/7 uptime with a database of that size, you should definitely explore mirroring nd other high availability techniques. Do you have a server with enough storage...

My prefered methodology is to do regular transaction log backups like you're doing, a full backup at night, a differential at noon, then overwrite the transaction log with the first...

Had some insider information there? 😉 I'm not so...

Another server in another data center is not an option, we just have the one server room at this time. That might become a possibility at some point in...

When you create your classifier code, can you assign pools according to database? We're looking at copying our ERP database to a different server for reporting purposes and, since...