-1 CI

-1 NCI

-1 PK (which is non clustered Index and surrogate key)

So a total of 3 indexes.

The CI is 400GB which is 6 billion records so I was wrong, is...

Lynn Pettis (7/19/2016)

---

sql-lover (7/19/2016)

---

I did. It has EXECUTE, like I said. I verified this via GUI and...

I did. It has EXECUTE, like I said. I verified this via GUI and TSQL. The store...

Phil Parkin (6/7/2016)

---

Some pratting about is required to handle the single quotes embedded in your SQL, before it can be passed to an executor proc.

One way is to replace all...

This is cool! Let me take a look.

Can you post actual TSQL with it??? Got some syntax errors when trying that.

Lynn Pettis (6/3/2016)

---

Based on this, the next question is when are the Nimble backups scheduled? If at the top of the hour, schedule your backups to run fifteen minutes...

Daily DIFFs on each database, each server, yes, usually midnight or so.

Sor for instance, if I have database ABC, XYZ on server1. I take a FULL backup on Sunday, everything...

Lynn Pettis (6/3/2016)

---

sql-lover (6/3/2016)

---

Lynn Pettis (6/3/2016)

---

sql-lover (6/3/2016)

---

Lynn Pettis (6/3/2016)

---

I may be blind, but I went to your other thread to see if you answered my question there regarding the Nimble...

Lynn Pettis (6/3/2016)

---

sql-lover (6/3/2016)

---

Lynn Pettis (6/3/2016)

---

I may be blind, but I went to your other thread to see if you answered my question there regarding the Nimble backups and could...

Lynn Pettis (6/3/2016)

---

I may be blind, but I went to your other thread to see if you answered my question there regarding the Nimble backups and could not find anything....

Lynn Pettis (6/2/2016)

---

Two things I'd do. One, schedule my SQL backups such that the timing does not interfere with the Nimble backups. Two, configure the backups such that...

Bump!

WOW! Nobody?

I opened a call with RedGate Backup support team and they confirmed they use VDI for their backups, which is also used by Nimble VSS backups. Following a suggestion made...

Shelley Allen (5/23/2016)

---

I have a DB that is 1.81TB. Normally when a FULL backup is done, the .bak file is over 1TB. However, when I do a Full...