Guys This is a bit OT, but i know there are a few SQL server experts on the list. I'm backing up a SQL server 7 DB and ftp'ing it over from one server to another using a batch file. One the receiving server (also 7) I need a scheduled task (for example) which will use the file to restore the database forcing over the existing database (basically ensuring the 2 DBs are synched). There doesn't appear to be a way to schedule this in enterprise manager like there is with the backup. So anyone know how to do this? I found the script below on google, but I can't make any sense of it. For example where I specify the BAK file that I previously uploaded use MASTER go Restore Database MASTER From Tape='\\.\Tape0' With File=2, NOUNLOAD go
Thanks Mark -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
