transaction log shipping sql server 2005 to 2008
Posted
by Andrew Jahn
on Server Fault
See other posts from Server Fault
or by Andrew Jahn
Published on 2010-05-26T12:42:02Z
Indexed on
2010/05/26
12:51 UTC
Read the original article
Hit count: 502
I have a reporting setup with SSRS on our sql server 2005 database. Because sql server 2008 is not supported by the main program which populates our database we are stuck with 2005 on our prod database. Unfortunately when I run our weekly check reports the web interface constantly times out because the server cant do the conversion to PDF. I've read that sql server 2008's SSRS is ALOT better with memory management. I was wondering if I can do some kind transact log shipping subscription publication from 2005 to 2008? Am I chasing a dream here.
Currently I have to open up the ssrs project in visual studio and run the reports inside because it doesn't ever time out when doing the pdf conversion, only times out if I try to run it through the ssis web interface.
© Server Fault or respective owner