Tag: SMO (Page 4/5)

#PSTip List SQL database mirroring partner using SMO

Note: This tip requires PowerShell 2.0 or above. In an earlier tip, we looked at how to verify if a…

Read More

#PSTip Verify if a SQL database is mirrored or not

Note: This tip requires PowerShell 2.0 or above. When using SQL SMO to work with mirroring configuration, it is essential…

Read More

#PSTip Failing over a mirrored SQL database using SMO

Note: This tip requires PowerShell 2.0 or above. After I configure SQL mirroring, I usually perform some checks to ensure…

Read More

#PSTip Enumerate all SQL Server instances in a network

Note: This tip requires PowerShell 2.0 or above. Ever thought about how you can list of all SQL Server instances…

Read More

#PSTip Changing SQL database AutoShrink property using SMO and PowerShell

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

Read More

#PSTip Restoring a SQL Database using SMO

Note: This tip requires PowerShell 2.0 or above. In a couple of earlier tips on using SMO, we looked at…

Read More