jcrawf02 (5/19/2014)

---

GilaMonster (5/16/2014)

---

It was finished January last year.

http://www.amazon.com/Memory-Light-Wheel-Time-Book/dp/0765325950/ref=tmm_hrd_title_0?ie=UTF8&qid=1400268202&sr=1-2

The Wheel of Time turns, and Ages come and pass.

What was, what will be, and what is,

may yet fall under the Shadow.

Let the...

Same thing. If there's memory pressure, SQL will discard pages from the data cache to make space...

Neither. It'll be discarded.

Next time the data is needed...

Probably some long-running transaction which had to be rolled back.

No. As far as I'm aware, no changes have been made to how DTA works for years.

The change in recovery model on the primary DB broke the log chain. You won't be able to take another log backup until you take a full/diff to restart the...

The Virtual File Stats DMV, like many of the stats you get from DMVs are stored in memory, are specific to an instance and are cleared when SQL restarts.

No where near enough information. We need at minimum the procedure definition and the table definitions, the execution plan as well would be extremely useful

That is the current plan, not sure exactly what time exactly. Was planning to beg for a lift through to Telford (and for Sunday too)

That article was written using SQL 2008, so yes.

Recovery process should be logged to the error log. Yes, you just have to wait.

https://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/

The statement you posted should bring it online, you'll just have to wait while SQL runs the recovery process.

If 2008 (100) is not in the list then you're connected to the SQL 2005 instance.

Honestly, seriously, recommend to your client (and your company) that they look for a DB specialist to help them with their DR and that they let you work on your...