Interesting article with a nice flow.

Thanks

Come to think of it - it seems like he just wanted us to hold his hand and do it for him maybe 😀

Elliott W (2/16/2010)

---

Grrrr..

Do people not know how to read these days..

Between me and another prominent poster we provided an answer and a link to exactly do the answer. And...

You're welcome.

Limitations and performance implications.

An answer and a resource on how to do it was posted. Is the question different than...

contractors

rambilla4 (2/10/2010)

---

Hi,

Did anybody create log shipping & ship the log file to secondary based on fixed size instead of every 5 mins or 15 mins? For example if the log...

I am curious to know if there was any query improvement on the subsequent runs of the query. Are these times the first run of the query?

Then you will need to add odometer reading to the query that Gail provided.

ROW_NUMBER() OVER (PARTITION BY Vehicle.VehicleID ORDER BY Odometer Desc, RPTUTCDATE DESC)...

I think the important thing to note is that the most assured method to know which SQL server is a VM or not, one should coordinate with the SysAdmin team....

You're welcome.

2nd or 3rd time in the last couple of days that I have seen it. It is sometimes easier to just give a reference.

Nice question indeed. Thanks for submitting it.

Robert is correct on this. To control log file size in log-shipping, backup the log more frequently.