Automating Routine Server-to-Server Administration Tasks
Anytime you deploy multiple computers that run SQL Server or multiple instances of SQL Server within an organization, you will need a way to handle routine server-to-server administration tasks. For example, if you have a database on one server, you might need to copy users from one server to another. SQL Server 2008 allows you to automate routine server-to-server administration tasks using scripts. You can write the scripts to the Query Editor or save them to a file for later use.
The server-to-server administration tasks you can automate include
Copying users, tables, views, and other objects from one database to another
Copying alerts, jobs, and scheduled jobs from one server to another ...
Get Microsoft® SQL Server® 2008 Administrator's Pocket Consultant 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.
