Okay so I am new to the SQL arena! Just wanted to get that out of the way!
I have just set up a new SBS 2000 Server and am using SQL 2000 on it. I need to move a database from the old server, using SQL 7, to the new one. I have a backup of the old server db. However, I need to use the move command when restoring because the backup was done from drive D: and the new system is on drive c:.
I can't seem to figure out the proper syntax for a batch file to use osql to restore/move the database. Any suggestion would be appreciated.