Quick random question that isn't really worthy of its own thread. Given that the log redo process in an AlwaysOn Availability Group secondary can be likened to a continuous restore,...

Did you definitely install a SQL instance and not just the tools? They can be installed separately, so it can be a bit confusing. If you look in your Windows...

As in a . (period if you're American?)

Does it work if you just put a dot in?

Gary Varga (1/4/2017)

---

Today "Leave" means "Leave" according to IDS. Brilliant.

I can apply the same logic to show my excellent SQL...

That's a very good point.

In the msdb backup tables can you see if both backups were invoked by the same user, etc? Under username.

Ah, ok, you said host.

select SERVERPROPERTY ('InstanceName')

What does that give you?

Try this:

select SERVERPROPERTY ('MachineName')

I'm a big fan of setting quarterly goals rather than resolutions. On a personal note I never make massive changes in January; it's a bleak enough month already without making...

Geoff.Sturdy (12/29/2016)

---

we in the UK voted to remove our country from the EU - pretty much for the same reasons that the founding fathers rebelled against Imperial rule from...

Same for me- after a couple of updates the problem went away.

Agreed, but some seem to be disproportionately low- there's a contractor Sr DBA in London down at $450, which is a fairly low contract day rate for London, which makes...

anjaliagarwal5 (1/3/2017)

I also tried to right click on the database and selected Restore database. I selected "Device" and pointed to my backup file and then I choose the Database name,...

No, as the other posts state, you do have to do some of the legwork yourself, by process of elimination.