You can't restore up-version and leave the DB in standby and be able to restore further logs. You'll have to restore WITH NORECOVERY. With that change, your plan will work.

You've...

Not directly answering the question, but Azure SQLDW is not just a...

A uniqueidentifier isn't ideal for a clustered index (search term: fragmentation), but it's not all that likely that it's the root cause of the deadlocks.

Stop using the 1204 traceflag, that's...

Pages can be read multiple times. If a page is read 5 times during a query's processing, that's 5 logical reads.

Index on foreign keys is a good place to start, but it may not be the best index to have. It's only really needed if rows in the parent table...

Where are you getting that error from? It doesn't look like a SQL server error message.

It would probably be something doing a scan of a large table. Look at execution plans for table scan/index scan.

Go to 16.

Upgrading to SQL 2014 is the same work as upgrading to 16, and leaves you with an older version, fewer features and less time before it's out of...

Please note: 4 year old post

Not necessarily. It could be anything in the IO stack from buggy filter drives to faulty cables, faulty switch, problems with...

Clean installs are always preferred. Easier to revert back if anything goes wrong to start.

On the 2012-2014 side, you MUST test before you do that upgrade. One of the changes...

Tbh, don't bother calling Microsoft. They'll tell you to restore your last good backup. They won't help with data recovery (not allowed to) and probably won't be much more help...

You would restore the full, the latest differential (not all of them) and all log backups after that (leaving the DB in the RESTORING state), then set up the log...

Thom A (12/20/2016)

---

Getting a...

Siberian Khatru (12/20/2016)

---

I can find a backup of the actual mdf/ldf pair after the delete and presumably before the tran log is backed up -- that's the only way to...