Or use a single backup job, drop parameters in a table, let the job run pick up parameters (db name, type of backup, path to file, etc.) from the table....

I thought that the backup would run under the context of the service account for SQL Server. You submit the request under your SQL login, but the service account for...

You need to track the usage of space over time to know if you need to add more space. In general you want enough space to last 2-6 months, so...

Did you upgrade or not? You cannot have two default instances, yet you say you had a 2000 default and chose default not upgrade during the install.

I suspect that you...

You could detach and attach, but I suspect you'll need to alter the log shipping jobs at some point. The log restores should pick up, but not sure how that...

Each file has to be a query. It seems you have that. You use SQLCMD to just execute that query. The file contains the same thing that you would execute...

😛

The servers are on US time, Colorado (Mountain) actually. So things won't switch until I do 🙂

I wouldn't be surprised to get upgrades coming every 1-2 years now. However it will put stress on everyone if you don't have upgrades that go back to 4-5 years...

There shouldn't be issues with running this mode. Your database functions as though it were a 2000 server, although the structures are different. In the 3 years this has been...

Last time you were unmotivated? Or it was slow? Hopefully it was the former, though I suspect the latter.

The cloud is here, and get ready to start debugging a few tables spread throughout the cloud and not performing well!

I'm not sure what 7.5 is, from my understanding that was cancelled in favor of 8.0. Nevertheless, the point is there.

Microsoft constantly looks to try and get people to upgrade....

Easy, easy. Go easy on the politics here.

Feel free to start a thread in Not about SQL forum if you wish to debate it.

Glad you liked the question. Something triggered this in my mind and I thought it was a good one.