#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. As database administrators, we might want to configure SQL MaxServerMemory setting to ensure the SQL service does not occupy all available physical memory.
Read MoreNote: This tip requires PowerShell 2.0 or above. A SQL Server instance, by default, deploys a few system databases such as Temp DB, MSDB, Master, and Model DB.
Read MoreNote: This tip requires PowerShell 2.0 or above. In an earlier tip, we looked at how we can use SMO in PowerShell to generate T-SQL scripts for cloning databases.
Read MoreNote: This tip requires PowerShell 2.0 or above. As database administrator, you may want to create a database on development or test servers with similar settings as on the production server.
Read MoreNote: This tip requires PowerShell 2.0 or above. If you have ever backed up a SQL Server database, you will know that the default backup location is set to the Program Files folder where SQL is installed.
Read More