DR for Crystal Enterprise and Business Objects

Have to build DR solution and subj is a part of it.

Maybe some one has done it already… share the experience please.

Dr in my case will between 2 different data centers, replication is san 2 san so on other side I have a warm standby that does not see san disks and will become active if and only if the primary data center is down, windows domain is the same, ip addresses, names of the servers are different. How a cluster will behave is interesting as well (I mean CE is on cluster, not geo distributed cluster).

I have CE90. I’m talking to their tech support that seems to be outsourced, they didn’t really produce in 5 days anything more then a part of their own documentation in pdf format for CE version I do not use J…

So I’m wondering maybe somebody had to walk similar path already…

I see you were already involved on the previous thread that discussed some of the general considerations for such SAN replication (it was titled SAN Replication and is at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=465113&SiteID=1). Unfortunately I'm not aware of any specific considerations for CE.

Downgrading MSSQL 2005 DB to MSSQL 2000 DB

Hello all,
Does anybody have any experience in trying to backup a DB from MSSQL
2005 and then restoring it on a machine with MSSQL 2000? Can it be
done? Is it completely impossible?
While at it - Is it possible to do the reverse without problems? Is
MSSQL 2005 100% back-compatible with MSSQL 2000, so I can just backup a
whole DB on MSSQL 2000, restore it on MSSQL 2005 and have it run as
smoothly?
Thanks in advance.You can go from 2000 to 2005 and the db will be upgraded to the 2005 format.
But once it is in the 2005 format you can not go backwards. The upgrade is
seamless in and of itself but there may be incompatibilities with your
existing code / app that you might have to deal with. You can use the
upgrade advisor to see first.
http://www.microsoft.com/downloads/details.aspx?familyid=63FCE120-5E87-4AF1-B080-CA461AEAFAA2&displaylang=en
--
Andrew J. Kelly SQL MVP
<Baudolino@.gmail.com> wrote in message
news:1128954487.426069.160440@.f14g2000cwb.googlegroups.com...
> Hello all,
> Does anybody have any experience in trying to backup a DB from MSSQL
> 2005 and then restoring it on a machine with MSSQL 2000? Can it be
> done? Is it completely impossible?
> While at it - Is it possible to do the reverse without problems? Is
> MSSQL 2005 100% back-compatible with MSSQL 2000, so I can just backup a
> whole DB on MSSQL 2000, restore it on MSSQL 2005 and have it run as
> smoothly?
> Thanks in advance.
>

Downgrading MSSQL 2005 DB to MSSQL 2000 DB

Hello all,
Does anybody have any experience in trying to backup a DB from MSSQL
2005 and then restoring it on a machine with MSSQL 2000? Can it be
done? Is it completely impossible?
While at it - Is it possible to do the reverse without problems? Is
MSSQL 2005 100% back-compatible with MSSQL 2000, so I can just backup a
whole DB on MSSQL 2000, restore it on MSSQL 2005 and have it run as
smoothly?
Thanks in advance.
You can go from 2000 to 2005 and the db will be upgraded to the 2005 format.
But once it is in the 2005 format you can not go backwards. The upgrade is
seamless in and of itself but there may be incompatibilities with your
existing code / app that you might have to deal with. You can use the
upgrade advisor to see first.
http://www.microsoft.com/downloads/d...displaylang=en
Andrew J. Kelly SQL MVP
<Baudolino@.gmail.com> wrote in message
news:1128954487.426069.160440@.f14g2000cwb.googlegr oups.com...
> Hello all,
> Does anybody have any experience in trying to backup a DB from MSSQL
> 2005 and then restoring it on a machine with MSSQL 2000? Can it be
> done? Is it completely impossible?
> While at it - Is it possible to do the reverse without problems? Is
> MSSQL 2005 100% back-compatible with MSSQL 2000, so I can just backup a
> whole DB on MSSQL 2000, restore it on MSSQL 2005 and have it run as
> smoothly?
> Thanks in advance.
>

Downgrading MSSQL 2005 DB to MSSQL 2000 DB

Hello all,
Does anybody have any experience in trying to backup a DB from MSSQL
2005 and then restoring it on a machine with MSSQL 2000? Can it be
done? Is it completely impossible?
While at it - Is it possible to do the reverse without problems? Is
MSSQL 2005 100% back-compatible with MSSQL 2000, so I can just backup a
whole DB on MSSQL 2000, restore it on MSSQL 2005 and have it run as
smoothly?
Thanks in advance.You can go from 2000 to 2005 and the db will be upgraded to the 2005 format.
But once it is in the 2005 format you can not go backwards. The upgrade is
seamless in and of itself but there may be incompatibilities with your
existing code / app that you might have to deal with. You can use the
upgrade advisor to see first.
http://www.microsoft.com/downloads/...&displaylang=en
--
Andrew J. Kelly SQL MVP
<Baudolino@.gmail.com> wrote in message
news:1128954487.426069.160440@.f14g2000cwb.googlegroups.com...
> Hello all,
> Does anybody have any experience in trying to backup a DB from MSSQL
> 2005 and then restoring it on a machine with MSSQL 2000? Can it be
> done? Is it completely impossible?
> While at it - Is it possible to do the reverse without problems? Is
> MSSQL 2005 100% back-compatible with MSSQL 2000, so I can just backup a
> whole DB on MSSQL 2000, restore it on MSSQL 2005 and have it run as
> smoothly?
> Thanks in advance.
>

Domain name change for MS SQL 2005

Any help will be appreciated.
To clarify few things I have no previous MS SQL experience, did some Oracle and MySQL work.
I will have to move one Win 2000 server with MS SQL 2005 running one database to our AD 2003 environment. I was wondering if anybody already went through that kind of scenario, and what was the procedure.
Thanks

let me understand the scenario

you have sql server 2005 running on Win 2000 ADS machine (Same physical machine) and you want to migrate windows 2000 to 2003 and transfer sql server 2005 to new ADS 2003 machine.

is this the requirement?

Madhu

|||I wasn't clear enough.
We have to move a windows 2000 server from one domain to another. That server has SQL 2005 installed and we are using it as our accounting database. We have to keep that server and it's 2005 SQL database functional on our domain. We will not upgrade that server to win 2003. Recently we acquired another company and this is the only problem that is stopping us from connecting both networks.