embed embed share link link comment comment

Embed This Video close
Share This Video close
bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark
embed test
Rate This Video embed
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading ... Loading ...
Tags For This Video tags
rate rate tags tags related related lights lights

Scripting out SQL Server for Documentation and Disaster Recovery

Speaker:

George Walkey

Abstract:

Most DBAs need to 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 exportable and 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 moving or recovering a SQL server instance 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, and Server Triggers

Bio:

SQL Server DBA, Developer, IT Manager, Business Owner from the Richmond, VA USA Area
Interested in pushing the limits of both hardware software and my own brain

Recorded At:

SQL Saturday OKC 2015

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>