GilaMonster (7/9/2015)

---

They're places to put backups. No performance advantage.

May I suggest you get a new keyboard, since your current one appears to have either a broken shift key or a...

Brandie Tarvin (7/9/2015)

---

So I've been a DBA for eleven years now. In the past three days, I have learned twelve new things I never knew (but should have known) about...

So, something like this?

CREATE TABLE #temp (

ID INT NOT NULL,

[Date] DATE NOT NULL

);

INSERT #temp (ID, [Date]) VALUES

(1, '2000-05-03'),

(1, '2001-06-10'),

(1, '2014-04-02'),

(1, '2014-07-29'),

(1, '2015-07-15'),

(4, '2001-05-07'),

(4, '2013-08-01'),

(4, '2014-02-05'),

(4, '2015-07-05'),

(4, '2014-08-01'),

(9, '2002-05-01'),

(9, '2000-04-02');

INSERT...

In this case, wouldn't an island of one year count...

Coming back to see what's happening and I find myself lost. What exactly are you trying to return? The maximum number of consecutive years? The number consecutive years...

That depends on your businesses RPO/RTO/SLA agreements. It isn't something we can just say this is the minimum data...

First, your test environment should mirror your production environment to give you a better sense of what will happen in production.

Second, you say in production it uses 600G of space...

Again, what we don't know is how this all is supposed to work. All we know is that a stored procedure is supposed to be run continuously to import...

Please, pray tell, how are we supposed to tell someone how big to create their database and what autogrowth setting should be used!

Talk to the developers building the application...

There is no way we can tell you everything about always on in a forum. You are...

It depends. One thing, don't use a percentage.

It depends on the expected size of the database plus...

Not enough information to really help. If you run it as a scheduled job and have it scheduled to run every minute, for instance, if the job is still...

wa220 (7/8/2015)

---

Just so you know, I looked you up, I didnt realise i was talking to someone who has given me so much help over the years (from you website)....

In addition to the t-log backups running as frequently as the amount of data you are willing to lose, it also depends on managing the size of your transaction log....