Jon Galloway has a quick, consise post on how to restore a SQL Server 2000 database from a backup. I have all of this encoded, plus a something things, in ToolMS; but it’s good to keep it on on file.

[JonGalloway.ToString()] DOS batch script to restore a SQL 2000 database and grant permission to ASPNET account