As in other scripts in this series, we start by loading the SQL extensions. Then we define our input parameters; in this case, we'll take the server name and the database name that we need to restore.

Learn how Data Transformation Services (DTS) can help you import, export, and/or transform data from various sources to single or multiple locations in Microsoft SQL Server 2000.