Hello all,
Due to some specific needs, I would like to carry out the following
scenario:
- I have 2 production servers, one with SQL Server 2005, the other with SPS
2003 installed,
- there's a portal site accross those two servers and it works OK, except
that the SPS Backup and Restore feature is broken so there's no SPS backup
but there are MDF and LDF files ready to be copied.
Now, I would like to make a copy of the aforementioned portal site on a test
machine with its own SQL Server 2005 and SPS 2003 installation (in the same
LAN, I want to use the same site, prof and serv databases transferred to the
test machine) but operating under a new URL.
In fact, I would like to get two portal sites with two different URLs but
with the same content.
What is the best practice to achieve that?
Thank you in advance,
Hrvoje
I don't know much about SQL 2005 but here is the procedure I would
follow under 2000:
Take a backup of the three databases
Take a copy of any customisations applied to the portal (from the file
system)
On the target machine:
Restore the SQL databases
Create a new IIS web site for the portal to live in
In Sharepoint > Central Admin choose create portal, then select the
restore option
Point to the restored databases and set the authentication
Let the portal restore
Reapply customisations to the file system
Then deal with the different URL (ie configure host header in IIS,
DNS, then set the alternate access mappings etc in Sharepoint
Richard
-----------------------------------------------Reply-----------------------------------------------
Hello Richard and thank you for your reply.
I had the same idea but it always ended in an error when trying to restore a
portal site from the existing databases:
"Portal creation failed Microsoft.SharePoint.SPException: The database
schema is too old to perform this operation in this SharePoint cluster...."
However, my database is not too old and I've taken care that both SQL Server
builds and SPS versions are the same on both machines....I don't know what
to do.
Kind regards,
Hrvoje
"richard.markiewicz" <richard.markiew
@eshareuk.com> wrote in message
...
>I don't know much about SQL 2005 but here is the procedure I would
> follow under 2000:
> Take a backup of the three databases
> Take a copy of any customisations applied to the portal (from the file
> system)
> On the target machine:
> Restore the SQL databases
> Create a new IIS web site for the portal to live in
> In Sharepoint > Central Admin choose create portal, then select the
> restore option
> Point to the restored databases and set the authentication
> Let the portal restore
> Reapply customisations to the file system
> Then deal with the different URL (ie configure host header in IIS,
> DNS, then set the alternate access mappings etc in Sharepoint
> Richard
Add to del.icio.us |
Digg this |
Stumble it |
Powered by Megasolutions Inc
