August 23, 2012 at 10:01 pm
I need to send the backup completion report using an excel sheet or as PDF. How to achieve the task using the most easiest method?
I am using the below method:
1. Establishing a linked server from one server to all the other servers in the same domain.
2. Creating a table with the requisite columns in the main server which is the linked main server.
3. Creating a job which will first export the table contents on the same date and will send the contents using an excel sheet to the required distribution list'.
but, I am more concerned in creating all the linked servers. But without this, I am not sure how to send all the backup completion status details of all the servers to a single table.
Please suggest a best method and plan.
Thanks.
August 24, 2012 at 12:40 am
try to use
or if you have a MSSQL2008
Administer Multiple Servers Using Central Management Servers
I Have Nine Lives You Have One Only
THINK!
August 24, 2012 at 8:47 pm
How about using SSIS to pull the data from all the sql instances and send an excel document from it?
Maybe setup a table with all the server names and then have SSIS enumerate through and pull the report from each server into a master report table. No linked server required, just maintain the table of server names.
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D
August 24, 2012 at 11:19 pm
Hello,
I know about SSIS, however, if you could share such scripts in steps, I can modify and make use of it.
But yes, creating so many linked server might not be very well, from a security point of view.
Kindly help.
Thanks.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply