I've used revlogin in a 2012 to 2014 migration, worked fine.

You can write the extended event session to a ring buffer, that's queryable. The perfmon counter will work as well if you just want a count.

The log can't be reused while a backup is happening, so it suggests that, at the time you do the backup, the DB is very active (or maybe running index...

Nothing.

Checkpoint_queue is a wait type, the checkpoint process is normally in that wait state, waiting for some work to do.

Again, no idea because we don't know the definition of the table or what the data in it looks like. Whatever you have there is custom, not something that's in...

Then you're going to need to script objects, export data and recreate the DB from scratch (and some stuff may fail to script or export due to the corruption)

Once you...

Restore from your last good backup. Damaged system table, that DB is toast, not repairable.

Cardinality Estimator most likely, not Compact Edition. 🙂

Maybe. Maybe not. Depends on how much overhead the repeated compilations add.

Date error tossed over to the docs team, I've also asked about the download as I also can't figure out where to download the file.

I doubt it's anything to do with the app. RStudio doesn't have query designer features, R (the language) just connects to SQL using ODBC and passes over whatever query the...

Try this: http://www.sqlservercentral.com/articles/Restore/95839/. Otherwise there should be restore scripts available online that check folders for the log restores.

Not quite.

You're going to have to manually add the restore based on your full backup, rather than the virtual one, and the diff will only be useful if the virtual...

No. Paul White.

Shahin (7/21/2016)

---

De datbase has a table that calls LoginRecords and there I can see when users login and logout.

So I think I should be able to run a query to...