Both scenarios, either 5 minutes or 0 minutes, depending whether you can back up the tail of the log or not.

Personally at this point in time, I'd be planning for 2016 and starting the testing now (on the CTP), and you MUST test. There have been too many core changes...

Then call Microsoft and ask. No one here can tell you the...

Anyone? Although this looks to me like a case of 'give me the answer I want'.

http://www.sqlservercentral.com/Forums/Topic1757296-3411-1.aspx

It's not whether you see it as production data or not. Developer edition is licensed for development and testing only.

Developer is licensed for development and testing purposes only, and it's licensed per user, not per server, so anyone why uses the server must have a developer license.

2) is testing,...

Ray K (1/31/2016)

---

For now, I've been applying mainly to SQL Saturdays within driving distance, but if my wife will let me spend the money on a plane ticket, maybe I...

That's exactly what the WHERE clause I wrote for you will do.

Oh, and to emphasise, you MUST use the OPTION(RECOMPILE) clause as well.

If @ZoneId is set to 1, then you want just the one row, if it's null you want all 4?

WHERE (@ZoneID IS NULL OR ZoneID = @ZoneID)

OPTION(RECOMPILE)

The option(recompile is very...

Yes, but it's going to be hard to give specifics without seeing the code.

There's nothing there to optimise. It's a read of an entire table. There's no predicates that can...

This will return the string before the last backslash. It'll work if there's more than 2.

DECLARE @Str VARCHAR(200) = 'W:\ABC\F1.bak'

SELECT LEFT(@Str, LEN(@Str) - CHARINDEX('\', REVERSE(@Str)))

Ed Wagner (1/31/2016)

---

WayneS (1/31/2016)

---

GilaMonster (1/30/2016)

---

Oh,...

And have you? What are the results?

What's the exact message you're getting from the log backups?

With that little information, no.

What does the alert even mean?