Tag: SMO (Page 3/5)

#PSTip Deleting a SQL mirroring endpoint with SMO and PowerShell

Note: This tip requires PowerShell 2.0 or above. In earlier tips, we looked at how we can get all SQL…

Read More

#PSTip Creating a SQL TCP mirroring endpoint with SMO and PowerShell

Note: This tip requires PowerShell 2.0 or above. In today’s tip, we will see how we can use PowerShell and…

Read More

#PSTip Check if a SQL endpoint exists or not

Note: This tip requires PowerShell 2.0 or above. Before we make an attempt at creating a new database mirroring endpoint,…

Read More

#PSTip List all endpoints in a SQL deployment

Note: This tip requires PowerShell 2.0 or above. When working with SQL Server database mirroring, it is desired to understand…

Read More

#PSTip Retrieving SQL database last backup dates using SMO

Note: This tip requires PowerShell 2.0 or above. For regular reporting and auditing purposes, it is always desired to capture…

Read More

#PSTip Adding local users to SQL Server Logins using SMO

Note: This tip requires PowerShell 2.0 or above. There was a question on StackOverflow about adding local users to SQL…

Read More