Post reply

can anyone give me tips how to use powershell with respect to sql server 2008

  • June 18, 2013 at 5:01 am

    #295455

    can anyone give me tips how to use powershell with respect to sql server 2008

  • June 18, 2013 at 5:45 am

    #1624969

    wow an awfully broad subject there;

    take a look at the forum dedicated to Powershell and SQL server here

    from there, you can see there are broad categories of uses, but one of the biggest is gathering information from multiple servers; SSMS is single-server-centric until you open up the Registered Servers utilities.

    Powershell has easy access to Windows Management Instrumentation (WMI) , so you can get a lot of OS details and other statistics about your servers that way.

    you can use it for backup and restore strategies, scripting out of database DDL Objects, and so much more.

    do you have any specific questions?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 1 through 2 (of 2 total)

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