You could make your own. If you run this against any instance in your environment it will return an XML document that you can then save as a file for...

Michael Valentine Jones (9/26/2012)

---

I am trying to imagine a real world situation where IF/ELSE nested so deeply would be the way to go, instead of some other logical construct.

You should...

No problem. These dang written words. I thought for sure you had it after this comment:

As I have been trying to say (unsuccesfully) it all depends when the LS broke...

paruchuri4 (9/26/2012)

---

I am not considering about space but some databases are generating 0Kb size when they are taking backup for that purpose i need to know the size, if the...

Tara-1044200 (9/26/2012)

---

How can i make sure any login on the server can view only the database that they have access to.

I did remove "view any database" permissions at the server...

Yes, and it takes years to get to the bottom of it. Oh yeah, and Microsoft...

Jai-SQL DBA (9/26/2012)

---

Hi,

I want to understand the Logshipping reestablishment Scenerio After a Failover.Below Mentioned are the details of the Environment for the Better Understanding.

Server A: Primary Server

Server B:...

One other note. If you're compressing your backups then all estimates will be off because compression rates are data-dependent. In round numbers though I see about a 90% compression rate...

It's not an exact science but it should give you an idea. Why are you worried about the diff between a 1MB backup and 10MB space used? if you're that...

Here is a good primer to set you in the right direction asking the important questions:

Designing a Recovery Strategy for StackOverflow (December 16, 2009) by Brent Ozar[/url]

Have you explored Change Tracking?

Change Tracking Overview

Heh, that looks nicer. I'll have to try it out. Maybe I'll update my toolkit-script. Thanks.

Jeff Moden (9/25/2012)

---

What I'd like to know is.... why does someone need to know what size the backup is? SQL Server figures that out and if there's not enough...

Perry Whittle (9/25/2012)

---

Yes, but bear in mind...

Ah, courses and not exams. I would take the 2008 course if you have no choice to take the 2012 course. There are hardly any features available in 2008 that...