File sharing sites like the one I removed are copyright...

Glad it went over well. This one was hard to write without trying to trick people. I wanted it to make you think, but be solvable without misleading anyone.

And we'll always have those errors. Cables pulled out of servers, something dropped, something spilled.

You haven't necessarily defined a problem that well so far and there have been some questions asked that you haven't answered.

I would look at Target Server Memory for all instances...

RTO applies to the system, and it could be defined in various ways. However #4 doesn't say all clients or every client. An outage could easily be unevenly distributed. A...

Craig Farrell (5/4/2011)

---

Hm, I see where you're going in that case. I'll have to rethink a few things, thank you. The idea of production data on a workstation...

JP Dakota (5/3/2011)

---

According to Pierre Dorion at TechTarget.com - The RTO, as its full name implies, is a goal or an ideal time in which you need a specific function...

Craig Farrell (5/3/2011)

---

Steve, I've found that 99% of servers have their USBs locked down at the server side, if you can even access the data-center these days as a...

Eric M Russell (5/3/2011)

---

It is possible for a database application (not using AI but just basic SQL ranking, fuzzy indexes, and reference tables) to return the correct result for the...

I probably do, but so the OP knows, plenty of queries on a normal system will spike at 100% CPU. That's not necessarily a problem.

Nothing is ever written to the backup file. It is read-only. The sparse files created will store any changes made.

The time to restore on a USB drive will vary (SB2, USB3 interface). eSata will be quicker, but it's time.

For Virtual Restore it's very quick. No data is copied and...

One thing to think about is keeping a 1TB USB drive around for times like this. Make the restore happen on that volume, then try to resize the database.

Another alternative...

Second vote for SQL in a nutshell for SQL.

If you want SQL Server, pick up any SQL Server 2008 admin book. They're all about 80% the same. Go through it...

Congrats, Gail. Well deserved, I'm sure. I missed it online, but I will try to make it live.