Post reply

PowerShell SCript to export almost everything from a list of servers

  • February 16, 2012 at 11:39 pm

    #264752

    Comments posted to this topic are about the item PowerShell SCript to export almost everything from a list of servers

  • February 17, 2012 at 6:51 am

    #1448467

    Give credit where credit is due

    http://www.simple-talk.com/sql/database-administration/let-powershell-do-an-inventory-of-your-servers/

  • February 17, 2012 at 11:08 am

    #1448674

    Some great ideas in this script. Thanks a lot for sharing. I really enjoyed reading this.

    Best wishes,
    Phil Factor

  • February 17, 2012 at 7:32 pm

    #1448852

    no doubt I pull a lot of stuff from a million different places and honestly did not intend this version to get posted. It takes a month to get a script published and I had made changes I intended to get put in but got busy. I have a total new version now with two scripts and I take all the fluff out up front to simplify the troubleshooting. I try to put them back in if I can but at the end of the day I try to get things out so others can use them.

  • February 18, 2012 at 3:14 am

    #1448881

    @gene,

    Just send Steve the updated version and he'll probably swap it for the current one. It makes sense just to have the latest and greatest version.

    Best wishes,
    Phil Factor

  • March 1, 2012 at 2:51 pm

    #1453907

    Found a little bug. It does not seem to work with named instances. I tried putting the name in braces, but it didn't help. If I were a Powershell guru I would attempt to fix it. That is the training I plan on getting next.

  • March 2, 2012 at 12:59 pm

    #1454351

    we put every instance on its own port such as 1433, 2433, 3433 so I dont have that issue, but if I get a chance I may look at it.

  • March 19, 2012 at 10:44 am

    #1461252

    Good read. Must have script in every DBA's toolbelts.

    Thanks for sharing

    ~Leon

  • October 17, 2013 at 11:09 am

    #1659422

    Great script! Works perfectly on Default Instances. I just can't get it to work on any of my Named Instances. Like Server\Database. I get connection error messages when connecting to the Instance and path errors when it tries to write the files. Have you been able to look into this issue? Thanks for the hard work you put into this, very useful!!

    Frederick (Fred) J. Stemp, Jr.
    Database Administrator / Database Developer
    Dealer Funding, LLC

    '...if they take my stapler then I'll set the building on fire...'

  • October 18, 2013 at 9:34 am

    #1659767

    Great scripts and useful for so many purposes.:-)

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply