| Author |
Topic |
|
cedlin
Starting Member
7 Posts |
 Posted - 2009-12-24 : 09:10:21
|
| Dear all... I could not find an answer on the following no matter how hard I searched on Internet.Would the following SQL server configuration work?Primary Server = SQL Server 2000 within LANMonitor Server = SQL Server 2008 within LANSecondary Server = SQL Server 2005 off-siteMerry Christmas...Chris |
|
|
cedlin
Starting Member
7 Posts |
Posted - 2009-12-24 : 09:27:51
|
| Just a clarification:I know SQL Server 2005 with NO RECOVERY option works as a Secondary Server. The exact question of mine is if SQL Server 2008 can be used as a monitor server. |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-12-27 : 08:19:03
|
| Bear in mind that running SQL 2000 with SQL 2005 as the log shipping secondary is potentially problematic if you do need to fail over to the secondary. While it will work as a secondary, should the primary fail requiring you to use the secondary, there'll be no easy way to get the primary back. A SQL 2005 backup cannot be restored onto SQL 2000.--Gail ShawSQL Server MVP |
|
|
|
cedlin
Starting Member
7 Posts |
Posted - 2009-12-27 : 16:39:54
|
| Hi Gail, thanks for your answer. We'll not use the 2005 for fail over. It is simply for off site backup reasons for we have it off site for another application that requires 2005.We want to use the 2008 for reporting services and as monitoring server for log shipping if supported. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-12-28 : 04:35:00
|
| Off site backup? I don't really understand what you're doing with this setup. So you have no disaster recovery setup here?--Gail ShawSQL Server MVP |
|
|
|
cedlin
Starting Member
7 Posts |
Posted - 2009-12-29 : 04:02:22
|
| Hi Gail, in a way it is a disaster recovery backup. I understand that there are somewhat forced, not-too-straightforward ways to restore 2005 backups to 2000. This is ok for us based on the factors we considered such as RTO, etc.The real complicating factor for me is to figure out if we can use 2008 as a monitor server. I know that 2000 and 2005 works but if we can use 2008, it will be very helpful. I cannot find any information on this. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-12-29 : 06:01:24
|
quote:
Originally posted by cedlin
Hi Gail, in a way it is a disaster recovery backup. I understand that there are somewhat forced, not-too-straightforward ways to restore 2005 backups to 2000.
If by 'forced, not-too-straightforward ways' you mean scripting all the objects out, exporting all the data and then recreating the DB from scratch on the lower version. then yes. It's certainly not something I'd ever consider for a DR scenario as the work necessary if the secondary site is ever used is just prohibitive. How big's the DB in question here? If it's more than a hundred or so GB, then the time and work required to 'downgrade' will be enormous.As for the 2008, I don't offhand know and I doubt many people have tries such a mis-matched version log shipping because of the problems in failing back from a higher version.What I'd suggest is that you set up a lab environment (with virtual machines if necessary) and test the scenario out.Personally, I would strongly recommend matched versions, at least for the primary and secondary. Why are you considering mis-matched versions?--Gail ShawSQL Server MVP |
|
|
|
cedlin
Starting Member
7 Posts |
Posted - 2009-12-29 : 10:43:19
|
| Yes, scripting, exporting and importing on 2000. The DB size is about 50 GB.I got this environment handed over to me that apparently had evolved without much planning. An old version of ERP application that runs on 2000, and EDI software that requires at least 2005 and a 2008 reporting services environment that we can possibly replace with 2005.The requirement is that we have an off-site backup to comply with audit/legal requirements. I am trying to avoid new installations and want to get away with what we have at the moment. Thanks for all the help... I'll work on a test environment and will post the results to this forum. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-12-29 : 11:26:26
|
| Do some tests regarding the 2005-2000 'downgrade' see how long it really takes.I suppose it's not possible to upgrade the ERP to a version that supports SQL 2005? Does the current version not work at all on 2005?--Gail ShawSQL Server MVP |
|
|
|
|
SQL server log shipping and SQL Server versions