This is a great topic! Buying what is really needed is often overlooked. Really, one of the big reasons that VM solutions are making such a strong play (aside from...

Cool Ryan! Thank you!

Thanks Ryan. I just edited the original post as I realized it wasn't clear to me. 🙂

No question, use the backup and restore method. The replication piece will work but you have the overhead, which would be continual, you have the maintenance of the distributor and...

You should try not to cross post (post the same question in more than one category). I probably should have updated this one as it is the more appropriate group...

From online BOL:

IF UPDATE (column)

Tests for an INSERT or UPDATE action to a specified column and is not used with DELETE operations. More than one column can be specified....

First of all, can't the reporting queries include the nolock option or use the read uncommitted isolation level?

Indexing properly for the reports could be one solution. They could also...

Can't say that I have seen it but I wonder what you would see if you were to run a trace on the Oracle side for that spid. Wondering if...

Agreed Steve. Funny how working with people is very much like parenting. If you give someone a CLEAR set of guidelines / instructions and hold them accountable to that you...

Thought that I was going to start the same thing. I work for a company remotely. When I started I had moved to the area that the company was in...

You should be able to right click on the database, select tasks, select restore > database. Select the "From Device" Radio button and then point to the appropriate file and...

Tuning indexes on tables associated with replication can be a bit fun. You do need to make sure that the indexes you have in place for queries are necessary as...

By the way, did you get the "done" message at the end of the configuration run or did it fail?

See Lynn's question. Very valid.

Other than that it certainly seems like some reinstalling would be the next steps in order to get those working.

Yeah, run it with the other. It can't get any more "not working" right? 🙂