GilaMonster (4/6/2016)

---

Full backups do not ever truncate the transaction log

b) incremental backup does not include transaction log,...

GilaMonster (4/6/2016)

---

You need to get it, because those are numbers you'll be held to when/if a disaster happens....

Hi Gila,

Thanks for your reply. please do not misunderstand me, I do not meant to give you a brief answer on the RPO and RTO.

It is because I do not...

spaghettidba (4/5/2016)

---

IMHO Log Shipping is still the best option for DR in many situations.

If you thing that the time gap between backup/restores is an issue, maybe you're looking for...

GilaMonster (4/5/2016)

---

We're missing the most critical information needed for a DR design.

What's your RPO and RTO?

What kind of disasters are you protecting against (for example, clustering won't protect against a...

Perry Whittle (4/2/2016)

---

It's not the WSFC that requires the shared storage, it's the application you provision on top that...

OMG, thanks for the link!

Grant Fritchey (3/30/2016)

---

the version numbers are strictly internal management mechanisms for SQL Server. They're not something you need to worry about under normal conditions. Why are you so focused on...

Hi Tom,

Ahh.. I think I got you..

So XSN numbers are assigned to transactions (e.g. BEGIN transactions), but they are not assign as part of the row version until commit.

Right ?

Regards,

Noob

Hi Grant,

Thanks for the information.

Just curious .. in case you know the answer.. for MSFC without shared disk, do they need a quorum ?

Regards,

Noob

Grant Fritchey (3/30/2016)

---

szejiekoh (3/30/2016)

---

Grant Fritchey (3/30/2016)

---

Availability Groups require the clustering service to be running, but they don't require an actual failover cluster to be created. So no shared storage is...

Grant Fritchey (3/30/2016)

---

Availability Groups require the clustering service to be running, but they don't require an actual failover cluster to be created. So no shared storage is required. Just the...

Hi Tom,

Thanks for your explanation and sorry for the late reply. Wanted some dedication time to this thread.

The original version keeps its existing XSN number (or is assigned the lowest...

Hi Grant,

Thanks!

Grant Fritchey (3/28/2016)

---

If you set up your backups to go to multiple files, you will need those files for the restore. Using multiple files, on multiple drives, is a mechanism...