I'd add the new rows before deleting the old ones. You can use SET IDENTITY_INSERT for this. I'd do an insert..select from the old row, replacing the identity with the...

Good links, but short answers:

HA is about ensuring availability of a resource, this often uses multiple nodes to ensure we can access a resource if one node...

I was speculating, and certainly understand the strange circumstances. I like saving scripts of what I've done, and glad you used Notepad. Heplful to reproduce things.

The only use I've seen is two servers that would move data to each other and each used 2, with one generating odd numbers and one even. It was a...

I'd be concerned that someone mucked with storage coincidentally.

I'd also make sure if you're doing this, you use a script and save it, just to be sure you...

Do you mean the data from msdb.dbo.backupset? Are you attempting to use this to make a restore easier?

Easy one, but you are welcome

At times, but often when switching disks, some disks needed writing. Easy to confuse which one you're working with.

I remember those days. I also remember typing format a: too many times with the wrong disk in the drive and regretting my actions.

Outside storage has advantages, and plenty of disadvantages. Loss, forgetting to keep it, security issues of plugging, probably more.

It's not good or bad. It's just a choice, and...

I had forgotten this until I stumbled upon it.

Great story.

I had a financial company that contracted for DR and once a year we had to drag tapes over and  restore our systems. It was always...

There are certainly uses, and plenty of people keep a decent level of video or images on phones.

I shot 30-40GB yesterday for a volleyball match and might...