So, the backup provided by the vendor will not restore if the destination is backend storage. But it will restore into SQL Server if you use the NAS storage.

SQL...

Sean Lange (7/30/2014)

---

SQLRNNR (7/30/2014)

---

Sean Lange (7/30/2014)

---

SQLRNNR (7/30/2014)

---

Sean Lange (7/30/2014)

---

Lynn Pettis (7/30/2014)

---

Second, it comes down to using the right tool for the job and learning what those tools are and how...

For those that are curious, here is a blog rundown of that attack vector by Andreas.

http://www.insidesql.org/blogs/andreaswolter/

Sean Lange (7/30/2014)

---

SQLRNNR (7/30/2014)

---

Sean Lange (7/30/2014)

---

Lynn Pettis (7/30/2014)

---

Second, it comes down to using the right tool for the job and learning what those tools are and how to use them....

Sean Lange (7/30/2014)

---

Lynn Pettis (7/30/2014)

---

Second, it comes down to using the right tool for the job and learning what those tools are and how to use them. If all...

In addition to what Matt has said, you could load up a server side trace to try and capture better visibility into what is happening.

Lynn Pettis (7/30/2014)

---

SQL Guy 1 (7/30/2014)

---

Ah, if I understand right, you are in US army deployed in Afghanistan?

And the local agencies they are local to Afghanistan or to...

Grant Fritchey (7/30/2014)

---

Koen's excellent recommendations on compression are really the only way to reduce the size of data stored other than deleting the data.

Your other options are to try...

I am in favor of separating the large fact tables into their own filegroups - based on better data and analysis.

I don't necessarily think that the fact tables should each...

Markus (7/30/2014)

---

SQLRNNR (7/30/2014)

---

Markus (7/30/2014)

---

SQLRNNR (7/30/2014)

---

Markus (7/30/2014)

---

SQLRNNR (7/30/2014)

---

The database that they provided, was it enabled for encryption by chance? It is worth checking with the vendor if their database is...

Markus (7/30/2014)

---

SQLRNNR (7/30/2014)

---

Markus (7/30/2014)

---

SQLRNNR (7/30/2014)

---

The database that they provided, was it enabled for encryption by chance? It is worth checking with the vendor if their database is TDE enabled.

Also...

As an aside, I'd avoid shrinking the data file if at all possible. Shrinking has negative consequences that we try to avoid (like fragmentation).

Markus (7/30/2014)

---

SQLRNNR (7/30/2014)

---

The database that they provided, was it enabled for encryption by chance? It is worth checking with the vendor if their database is TDE enabled.

Also worth comparing...

The database that they provided, was it enabled for encryption by chance? It is worth checking with the vendor if their database is TDE enabled.

Also worth comparing with them...

Because we love to shorten things.:hehe:

Search Argument