Tag: SMO (Page 5/5)

#PSTip Backing up SQL transaction log using SMO

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

Read More

#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…

Read More

#PSTip List all fixed disk drives visible to SQL Server instance

Note: This tip requires PowerShell 2.0 or above. When automating SQL server database creation in PowerShell, we may want to…

Read More

#PSTip Change SQL Server MaxServerMemory configuration using SMO

Note: This tip requires PowerShell 2.0 or above. As database administrators, we might want to configure SQL MaxServerMemory setting to…

Read More

#PSTip Generate T-SQL script to clone database tables using SMO

Note: This tip requires PowerShell 2.0 or above. In an earlier tip, we looked at how we can use SMO…

Read More

#PSTip Generate T-SQL script for cloning a SQL database

Note: This tip requires PowerShell 2.0 or above. As database administrator, you may want to create a database on development…

Read More