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

transaction log shipping sql server 2005 to 2008

Posted by Andrew Jahn on Stack Overflow See other posts from Stack Overflow or by Andrew Jahn
Published on 2010-05-26T12:08:34Z Indexed on 2010/05/26 12:11 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.

© Stack Overflow or respective owner

Related posts about sql-server-2005

Related posts about sql-server-2008