Automating Routine Server-to-Server Administration Tasks
Anytime you deploy multiple SQL Servers 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 may need to copy users from one server to another. SQL Server 2005 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.
The subsections that ...
Get Microsoft® SQL Server™ 2005 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.
