Thank you for your reply. I have read both pages, and I know more about log shipping than I did before, but I did not find a solution to my problem. Thanks again for your help.
>>Is it possible to successfully engage log shipping on an active database?? I have it set up, but because there always seems to be an active connection (at least one), the log shipments never occur. Is there a way around this??
>
>
>Check
http://www.sql-server-performance.com/sql_server_log_shipping.asp and
http://www.mindsdoor.net/SQLAdmin/LogShipping.html
Thank You
Rollin Burr
Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.