This is genius!! Testing it out now. Thanks!

Yeah, I was going to try cleaning up the tables manually, but this was the only publication on the server and I was under time constraints, so I used the...

I ended up completely removing replication manually from the publisher/distributor by following the steps listed here: http://support.microsoft.com/kb/324401. That completely removed the distributor database and all publication info. I...

Yeah, the problem is, this is an accounting database and I don't have a clue what all the missing data might be. I tried manually initializing the subscription over the...

Maybe this will help: http://datazulu.com/blog/post/Sql2008-R2-Upgrade-Fail.aspx

Also, have seen problems when a trial version of SSIS was installed and had expired. In this case, uninstall SSIS to fix.

Shaun

Yo may also want to look at why you are rebuilding the indexes. Is this a batch that just rebuilds them blindly on a set schedule? You may want to...

Thank you happycat59!!! I don't know if I read it somewhere or just figured it must be true, but for some reason, I had it in my head that for...

Thanks George.. Good point about the 2008 conversion. I was developing a test today and probably would have run into that problem 🙂

I may have to go the third party...

This isn't a DR machine though. It's being used for reporting purposes and exists solely because of our slow data link, so that people at one site can run reports...

Thanks for the replies.

Lowell - I've not used log shipping before, so maybe I am not clear on the details. I thought log shipping required the WITH STANDBY option of...

Unfortunately, those views no longer exist in SSMS. I miss them too. You'll have to open a query tab and use the sp_who and sp_who2 system stored procedures (or a...