Yeah - standby mode will not work when logshipping from 2005 to 2008.

There is a query on this page that should help with that.

http://blog.sqlauthority.com/2007/08/09/sql-server-2005-list-all-the-column-with-specific-data-types/

FLU

That is normal.

Also, will you be upgrading the primary database?

clubbavich (1/19/2012)

---

I haven't used SSIS at all, so I'm may be completely wrong on this but, wouldn't it be MUCH cheaper to buy a copy of Developer Edition? How many...

Is the package being run from the same server or from a separate server dedicated to SSIS?

That is the way I interpret what Steve said. It's what I would do at this juncture as well.

Are your queries via stored proc to the table that holds this data or are they all ad-hoc?

The reports and application, are they custom reports for the application, are they SSRS reports read by the application, is it a different product entirely?

What you describe leads me to...

Hard questions to answer.

Some of it depends on the licensing you have with Microsoft. Some of it depends on Vendor support of applications you have. Some it depends...

Yes.

Here's another startup that is looking to provide the same kind of services.

http://dbastrikeforce.com/

Certify in 2008 (well the exams have been updated to include 2008r2) and then upgrade to 2012 later.

Have a look through this article for some steps in resolving this

http://www.sqlservercentral.com/articles/Transaction+Log/72488/

See my answer here.

http://www.sqlservercentral.com/Forums/Topic1238442-8-1.aspx?Update=1

Please just continue this conversation in one thread - it is really fragmenting the whole thing.