>>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?
currently 2000, but in planning for 2005.
Thank You
Rollin Burr
Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.