Ryan C. Price (2/10/2010)

---

Not that I want to encourage bad habits, but I seem to recall a discussion (I thought it was here @ SQL Server Central, but I can't...

What's the error?

If you don't verify your backups, it means you have no idea if they will restore when necessary....

Try Google.

Good search terms would be "enabling PAE Windows Server 2003" and "enabling AWE SQL 2005". Additionally you could look in Books Online.

Why is this urgent?

Don't understand your question. What do you mean by a 'real time server'?

The same books as are used for the MCTS 2008 Admin and MCITP 2008 Admin will be of value. I highly doubt you'll find a book specifically for an upgrade...

Don't understand your question. LSN stands for Log Sequence Number, it's a binary value that each and every change in a DB has. Files don't have LSNs, transactions do.

A user-generated dump can be manually generated. DBCC STACKDUMP. It might be worth running profiler to see what's running. Also, what's in the SQL error log? (If you're not sure...

This series may help you understand. http://www.sqlservercentral.com/articles/Indexing/68439/

No it does not. The log file records changes since the last log backup (in full/bulk-logged recovery)...

Nope. If...

Pretty much the same as explicit casts.

Can you post the code of that TVF and...

ben.mcintyre (2/9/2010)

---

In other words, there is simply no way of securing a database so that it cannot be fully unsecured if a copy falls into the wrong hands ? ...

Steve Jones - Editor (2/9/2010)

---

Perhaps I'm selling myself somewhat short. I know I do help people, and try to give them good info, but I'm certainly not the highly technical...

No, the article is neither good nor useful. Read over the prior comments to see why.