Jeff Moden (3/30/2015)

---

krypto69 (3/30/2015)

---

Thanks Grant.

Long story, but it's financial data and I'm new there so can't complain..yet.

Kinda figured those were my only options. Shame I can't use my high avail...without read only.

Think I will build package to refresh data two or three times daily.

Thanks again!

If it's all on a SAN and the particular SAN is capable, the "SAN Snapshots" may be what you need. 300GB takes literally just seconds when correctly setup. The databases also turn out to be "writeable" with the understanding that any and all data on such copies can and will be overwritten on the next snapshot, which should be at least once per night.

I've never personally set such a thing up but I've seen the results of when someone who knows what they're doing does and it's a joy.