Can we perhaps send the customers and OPs through DBCC TimeWarp instead? Move them to tomorrow, 2020?

Yes. You can't get around it. Either you send the changes through in the log with backups (log shipping), log reads (database mirroring), or a full backup (reset log shipping).

The...

Ben,

You bring up good points. There are some protections against copying files (TDE), but physical access is an issue. However these days, lots of remote access allows you to log...

Thanks, I appreciate the complements. Nice to know that I'm still answering a few that you don't know. I suspect fewer every day

Perhaps I'm selling myself somewhat short. I know I do help people, and try to give them good info, but I'm certainly not the highly technical MVP that some of...

If you transfer the rebuilds, those logs and the rebuilds, transfer to the standby. It's a lot, but it's probably less than sending over the full again.

Nope, no crossing the line. Polite statement and I agreed with it.

Didn't see that, but please do.

I was tempted to leave it. I'm still waiting for someone to go for an interview and have one of these comments come up. Especially...

Roy,

Apologies on behalf of the community. I have removed the comment, which was inappropriate. I did not mail the guy since I don't think it would do any good. He...

There are definitely ways around this, but the standard install, the "secure by default", IMHO misses out here. I've not worked with products that secure "administrator" from the sysadmins, and...

Gary's argument for the award (and Jack's) are the problem I've seen with the MCSE, MCDBA, etc. over the years. HAving one doesn't mean you have expertise in clustering, replication,...

It's not that I did not realize an Admin could do something like attach a debugger or copy files. It's the fact that it is so easy for an anonymous...

You can read about the exam here: http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-450

Most prep materials do cost money, and you should think of this as an investment.

Just starting to investigate this command. Does the setting of "cosmic string count" on the server have any effect?

I'm with Bru and others. Set it to grow by a decent percentage (use MB) of the original size.

So for a 10GB db, I'd think about whether I expect...