Date: 08/31/05 (SQL Server)    Keywords: database, sql, microsoft

I use Microsoft SQL Server 2000, for use with Microsoft Great Plains. Right now, I am working on building a backup server, incase the main server goes down (which has happened 2 times in the past 6 months).

My question is, is there a way to restore a database using a script that could be run from a Windows Command Box (cmd.exe)?

If you need more information, just let me know.

Thank you very much,

Peace,
Kevin

Source: http://www.livejournal.com/community/sqlserver/32532.html