>Thanks for your input Keith. Sorry it took me so long to get back. Your final statement was the best key.


>>A quick bit of advice that I can give is that if you want to completely replace a database periodically, then log shipping by itself is not enough. You would have to send a database backup to the 'new' server to re-initialize it.

If that is the case I would disconnect the db from the server, make a copy of it's data and fog files then reconnect it. Now copy those files to the new server and connect them at the newer server.

Logshipping can make a backup db at one of those other sites.

Is this 2005 or 2000?