Earlier installments of this series illustrated how to ping the host, how to check all of the windows services related to SQL Server and how to check the hardware and operating system information. Part 4 of this series demonstrates how to get hard disk and network adapter information from the host machine.
This new series examines methods and procedures to check the status of the Operating system, SQL Server instances and databases, using Windows PowerShell. Part One illustrates how to create a PowerShell script to ping the host machine and how to source the PowerShell function and call the function.
PSH script to unload table schema, dri, permissions and data to file(s).
Exports and imports SQL Server 2000 Enterprise Manager groups and server registrations using Powershell.
Learn how to perform administrative tasks by accessing the SQL Server 2005 WMI Providers using Window PowerShell.
This installment of the series illustrates how to use PowerShell scripts in conjunction with SMO and parameters to Generate an SQL Server Script.
Learn how to use PowerShell in conjunction with SMO to Generate an SQL Server Script.