Tag Archives: SMO

Restore a SQL Database Using SQL Server Management Objects (SMO) and PowerShell

At some point in your career with SQL, there may come a time to perform a restore of the database (and maybe transaction logs depending on your situation). Given that we covered how to back up a SQL database, we … Continue reading

Posted in powershell, SQL | Tagged , , , , | 1 Comment

Backup a SQL Database Using SQL Server Management Objects (SMO) and PowerShell

In my next article on my SQL and PowerShell series, I will talk about using the SQL Server Management Objects (SMO) to back up a SQL database. If you recall in my previous article on SQL Databases, you saw how … Continue reading

Posted in powershell, SQL | Tagged , , , | 1 Comment

Exploring SQL Databases Using SQL Server Management Objects (SMO) and PowerShell

Continuing with my little SQL and PowerShell series, I am going to talk about how you can use PowerShell to explore SQL databases using SMO. As shown in the previous articles, I will make my initial connection to a SQL … Continue reading

Posted in powershell, SQL | Tagged , , , | 5 Comments

Exploring SQL Server Using SQL Server Management Objects (SMO) and PowerShell

Continuing on from my previous article where I showed you how to make an initial connection to a SQL server using SMO, this article aims to dive deeper into the Microsoft.SqlServer.Management.Smo.Server object to view the configuration and available methods of … Continue reading

Posted in powershell, SQL | Tagged , , | Leave a comment

Connecting to a SQL Server Using SQL Server Management Objects (SMO) and PowerShell

In a previous article, I showed you how to find all of the SQL servers and instances using a function that queries the registry. Moving on from this, I will now show how you can connect to a SQL server … Continue reading

Posted in powershell, SQL | Tagged , , | 1 Comment