migrating the logins isn't difficult. Let me know if you have any problems.

Ok, After re-reading all of the posts I have a few more questions.

1. You stated that you created the 2ndary db and then set up logshipping.

Did you allow the wizard...

It's all good! LogShipping is working perfectly. I had to do the transfer logins manually, but have found that our script works better...

Name                                                   Size                         Type 

<database1>                                        2 155 801 kB               File    

<database1>_db_200409260302.bak         2 011 282 kB               Bak File

<database2>                                        1 002 123 kB               File  

<database1>_db_200409250207.bak         1 040 032 kB               Bak File

<database2>_db_200409260312.bak         1 024 403 kB              Bak File

From what...

Microsoft States that in order to achieve successful logshipping that the O/S and the SQL should be at the same levels. That isn't to say it's not possible to ship,...

Microsoft States that in order to achieve successful logshipping that the O/S and the SQL should be at the same levels. That isn't to say it's not possible to ship,...

Been there done that. Main thing you need to do if you aren't seeing the "In Sync" on the monitor, but you can see the logs have been applied, you...

I have had a successful role reversal with log shipping. I did have many issues with regards to log shipping. Please be sure to check that you have the FIXED...

Thanks guys. I have done some research but at this time, I need something more of an SDBA tool rather than an ADBA tool. I will check out the Microsoft...