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: 550
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