faisalfarouqi (1/19/2013)

---

Thanks. a lot once again, and really do appreciate what you guys say. I'll try to figure out how best I can utilize the info provided by "sestell1". Pls. pardon my ignorance, but I would really like to know how do others get backup information from all of the instances configured in their for e.g: if there are more than 50+ servers, I hope nobody does that manually going and checking on each of the servers, they might be using some kind of a script right? or either a 3rd party tool to do the work for them.

However, I am surprised to know that no one actually has set this thing up int their environment.

I need to really code things off by myself, rather than placing a request for the same.

Regards,
Faisal

sestell1 (1/19/2013)

---

I imagine everyone has their own approach to this.

Your approach of using linked servers will definitely work.

I use a C# application I wrote that lets me run T-SQL code against a select list of servers and provides a combined result set.
I also have an Excel spreadsheet with a macro that essentially does the same, but puts results in individual worksheets. I don't manage anywhere near that number of servers though.

Someone else I know uses registered servers somehow to run T-SQL against multiple servers.

As opc.three mentioned, you could probably do this through a Powershell script as well.

I don't know, but I'd guess Redgate offers some sort of tool for this sort of thing.

faisalfarouqi (1/19/2013)

---

Thanks. a lot once again, and really do appreciate what you guys say. I'll try to figure out how best I can utilize the info provided by "sestell1". Pls. pardon my ignorance, but I would really like to know how do others get backup information from all of the instances configured in their for e.g: if there are more than 50+ servers, I hope nobody does that manually going and checking on each of the servers, they might be using some kind of a script right? or either a 3rd party tool to do the work for them.

However, I am surprised to know that no one actually has set this thing up int their environment.

I need to really code things off by myself, rather than placing a request for the same.

Regards,
Faisal

faisalfarouqi (1/29/2013)

---

Thanks. to all you guys.

I've finally come up with a script that does the trick for me, and can be helpful for others as well. Now, here are the problems which I am facing...currently I just want to have the differential backups to be specified only if there is one on the server in the report, and it shouldn't print out diff backups in the report if there isn't any. Secondly, I want the report to be nicely formatted, so it looks good to the eyes, anything in html would do for me.

I've attached the script with this post, and I hope now people can actually provide me with some inputs on how to achieve it in a more neat & tidy manner. You can run this in your environment, and can modify the code to suit my needs mentioned above. Pls. revert this to me, as I am in need to get this formatted, and avoid those differentials & log backups if they aren't really there.

--Pls. note I've also attached how the report looks when it arrives in your mail box.

I hope this helps, and now you guys can make me achieve this in a better way.

Regards,
Faisal