Hi,

I need to set up a back server to replicate the MCMS data. From what i know,
I could export the sdo file and transfer it to the backup system. but I got
certain worries

1. I had seen in this forum that the maximum size the sdo file can go
(without the patch else 2GB) is 700 MB?

2. Is there any way I could programmatically perform a sdo import to the
backup system when i import the sdo file into the main server?

3. Is there any way when user make any changes to the MCMS database such as
creating a new page, be updated on both the main and backup server?
(similarly for any resources added)

3. What is the best method other than this which I think could work and is a
better solution?

Thanks!
Best Regards,
JJ

[ Post a follow-up to this message ]

Hi JJ,

1) that is correct

2) SDO files can be imported using import scripts using the site deployment
API. See the MCMS documentation for details and code samples

3) no this is not possible. Only one database can be connected to the same
server at the same time. If this is really a backup server you should use
SQL log-shipping to forward the updates to the  backup server.

Cheers,
Stefan

--
This posting is provided "AS IS" with no warranties, and confers no rights

New to MCMS?
Check out this book: Building Websites Using MCMS: http://tinyurl.com/6zj44
Check out the new book as well: Advanced MCMS development:
http://tinyurl.com/8ugwj
----------------------


"JJ" <JJ@discussions.microsoft.com> wrote in message
news:A386C1F7-9EB0-4474-9B23-F34DC418570F@microsoft.com...
> Hi,
>
> I need to set up a back server to replicate the MCMS data. From what i
> know,
> I could export the sdo file and transfer it to the backup system. but I
> got
> certain worries
>
> 1. I had seen in this forum that the maximum size the sdo file can go
> (without the patch else 2GB) is 700 MB?
>
> 2. Is there any way I could programmatically perform a sdo import to the
> backup system when i import the sdo file into the main server?
>
> 3. Is there any way when user make any changes to the MCMS database such
> as
> creating a new page, be updated on both the main and backup server?
> (similarly for any resources added)
>
> 3. What is the best method other than this which I think could work and is
> a
> better solution?
>
> Thanks!
> Best Regards,
> JJ

[ Post a follow-up to this message ]