#PSTip Backing up a SQL database using SMO
Note: This tip requires PowerShell 2.0 or above. In today’s tip, we shall see how we can use SQL Management Objects (SMO) in PowerShell to perform a SQL database backup.
Read MoreNote: This tip requires PowerShell 2.0 or above. In today’s tip, we shall see how we can use SQL Management Objects (SMO) in PowerShell to perform a SQL database backup.
Read MoreNote: This tip requires PowerShell 2.0 or above. Active Directory defines five FSMO roles: Schema master Domain naming master RID master PDC master Infrastructure master The first two: schema master and the domain naming master are per-forest roles.
Read MoreSo, in your script, you need to wait for a service until it reaches a specified status and performs an action based on the new state.
Read MoreWhen you assign the result of a service query to a variable, you must take into account one very important thing – the result is just a snapshot of the service state for a specific point in time.
Read MoreNote: This tip requires PowerShell 3.0 or above. Using WMI we can get a list of Wi-Fi adapters with the following command:
Read MoreNote: This tip requires PowerShell 2.0 or above. When automating SQL server database creation in PowerShell, we may want to give the end user an option to select from a list of available fixed disk drives and let the user select the drive that should …
Read More