If you must use one physical server, I'd do one instance. Two instances can be tricky and it sounds like you don't really know how this works. In that case...

With 2005 and 2008, they aren't necessarily required for auditing. Actually you could argue that Profiler/trace means they weren't needed previously either. They do many auditing easier in many cases,...

dbcc shrinkfile.

Only shrink it to the size you need for peak size between log backups. Not what's used now.

As soon as you upgrade to refrigerators to cool the beer, I'll take you up on that.

Actually if you're near Cambridge, let me know. I'm likely to be over there...

You cannot reset your password, but you can change it on expiration.

Not sure I'd hire anyone who chose the last option as anything other than a joke. Not sure I'd...

Roger,

Thanks for the update. Good to see the SQL team is watching and responding to the community.

I'd argue with the Patriot Act, I wouldn't trust the other side any more.

one instance, SQL Server can manage resources within itself.

multiple instances - resource contention, tempdb separation.

I wouldn't necessarily look to put a warehouse on the same instance as other databases. Typically...

Make sure you maintenance plan logs to the file system so you get more details. We can help if you don't understand them.

Very strange. Copy only backup? Was this model by any chance?

Any other data in the logs?

Diff backups run well and Mike has a great explanation.

Note that diffs grow larger each time because each diff grabs data since the last full, not since the last diff.

The backup process throws pages out as quickly as it can. It has no tolerance for delays because of the nature of the backup. It is NOT anything like a...

They all do about the same thing. Performance? They'll all be close. You might have some machines faster with one, not on others.

I work for Red Gate, but I've considered...

They all do about the same thing. Performance? They'll all be close. You might have some machines faster with one, not on others.

I work for Red Gate, but I've considered...

either something else was running or you had a conflict.

Are you backing up to new files all the time? Could have corrupted a file and that might stick the...