No guns at work. Chances are we're run out of developers and have to go code things ourselves. Now truncheons....

I thought this was a little silly shooting the podcast, or...

A full backup doesn't back up the log. There might be log entries of the database is under heavy use as the backup is running as there could be the...

We'll probably feel like we're in a purple haze as more apps get built with this thing!

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!