Ah, but if it were only the cost of the OS you'd be right. How long was the list of Win2000 compatible software that would not work under XP? How...

Here's something strange to try: Set the SQL Server Agent to run with your account and see if you can get the scheduled job to run.

Two words: Planned Obsolescence

Since Microsoft does not charge for updates, upgrades, etc...to existing systems (OS or Server) it eventually comes to a point where Microsoft is no longer making money...

You mentioned this is one a cluster. I assume you are using Microsoft Cluster Services (MSCS). Is this an active-active or active-passive? Is it possible that the T drive is...

A few quick questions:

You mention multiple connections. Are any of these to oracle servers or do any of them require a client be installed on the SQL server to make...

Yeah, the SQL-Litespeed-Disk-Tape process is great. Small, fast backups that work very closely to the native SQL backups.

Love LiteSpeed.

You are right. The correct order is the issue.

Say you alternate TLog backups to tape and to disk every hour for 16 hours during the day. 8 go to tape,...

I think we are blurring the line between business rules and data integrity rules.

DRI probably should not be used to enforce business rules beyond the very basic ones that...

Database backups to tape and TLog backups to disk should be okay. What you cannot do is backup TLogs to tape sometimes and TLogs to disk sometimes. This will cause...

Here's a question: How do you backup to disk and to tape without losing checkpoint information?

I assume you are not doing transaction log backups and your databases are not...

All I can tell you is that I spent the better part of 3 months trying to get it to work (this was NetBackup 4 for Windows) and we eventually...

James, have you verified with the hosting provider that they allow you to connect via port 1433 from the Internet. They may not allow those connections.

Their support people may be...

I guess the correct answer is "it depends". The right way should be a blend of good practice, data integrity and business need.

Likewise, no one should ever say "DRI...

I agree. I've never seen a database with cascading deletes turned on. Nowadays, it is pretty much taboo to really delete anything anyway versus just marking it deleted so it...

Quick Survey:

How many people here use DRI and have never worked with a database system that didn't have DRI capability?

How many people here do not use DRI and started their...