Talk in English - US at SQLSaturday #615 Baltimore 2017
Track Name:
Enterprise Database Administration & Deployment
Checkout the code: http://www.sqlsaturday.com/SessionDownload.aspx?suid=17192
Short URL: https://joind.in/talk/b4fb4
(QR-Code (opens in new window))
Most DBAs use multiple native and third party tools to fully document SQL Server instances yet still dont get all the objects. Even using Visual Studio and Database Projects, not all objects are exported because they live at the server level, above the database. Using Powershell, we will script out an organized set of files that can be checked into any Source Control system and or used for Disaster Recovery purposes. Objects exported include: SQL Agent Jobs/Alerts/Schedules, NT Service Credentials, SSIS-MSDB, SSIS-Catalog, SSAS Cubes, SSRS Reports, Logins, Server Configs, Linked Servers, DB Mail Operators/Accounts, Server Triggers and much more
Comments
Comments are closed.