Chapter 4. Basic SQL Server Administration
In this chapter, we will look at how to accomplish typical SQL Server administration tasks by using PowerShell. Although you were introduced to SQL Server-specific cmdlets in the previous chapters, these cmdlets are still quite few. Many of the tasks that we will see can be accomplished by using SQL Server Management Objects (SMO). As we encounter new SMO classes, it is best to verify the properties and methods of that class using Get-Help
, or by directly visiting the TechNet or MSDN website.
The topics covered in this chapter include how to perform the following tasks:
- Listing databases and tables
- Adding files and filegroups
- Scripting database objects
- Attaching and detaching databases
- Backing up and restoring ...
Get PowerShell for SQL Server Essentials now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.