1. Is there a command line tool using which I can backup and restore a SQL Server database ?
2. Is there a command line tool using which I can detach and attach a SQL Server database ?
I need to write a DOS batch file that can use these command line tools to give a simplied way to a novice user to perform these operations, without going through Enterprise Manager.
Pls. give some examples for syntax if possible