points are awarded back. #1 changed to be different.

Apologies. The interface for adding answers makes it hard to compare and it seemed like they were different in looking at things....

To use the files for your development, you need the SQL Server service (from the dev site post). That means you need to install SQL Server. You can install any...

I'm with Perry. One of the things that causes problems with DR and restores is usually complexity that you struggle with under pressure. Or someone else misunderstands.

I'd set backups with...

First, I'm not sure if we have a language barrier, but it's hard to understand what you mean as you aren't writing clearly. Please be sure you check spelling and...

I got it back from the proj mgr that we read unencrypted pages, then compress them, then encrypt the result (if you choose to do so).

As Jeff mentioned, the indexes matter. If you don't have good ones, then this can be problematic. Please include the DDL for indexes and the tables, with your sample data....

I'm checking on the technical details of the Red Gate product to see. The issue is that it depends on how the VDI interface sends out pages, and where in...

You'll have to provide more details on what these tables look like, including the DDL And PK/FK definitions.

You connect tables, not databases, so I'm not sure how you are describing...

Ed Wagner (11/10/2014)

---

Good question. Whenever I create keys, I back up the SQL I use to create them. This way I know how to recreate it exactly the...

Apologies. A few things on the SPAM:

1. We had a hiccup in the spam process and it was disabled over the weekend. Hence many of you (and me) getting...

Andrew..Peterson (11/10/2014)

---

"There were more people looking to secure their systems, though a surprising number of people using TDE had never attempted a DR restore. Please, please, do this. Make sure...

There's no magic here. You need to transfer the data. If you have large amounts of data in an mdf, then whether you use backup/restore, replication, SAN mirroring, etc, you...

Grr, I hate bye weeks

The only way to get an SA password if you don't have it is to have admin rights on the local hosts. Restart the SQL Server in single user mode...

TomThomson (11/6/2014)

---

Good question.

It raises an issue about the quality of this wizard: why on earth doesn't it read metadata for the target table and set lengths accordingly? It...