Go 4 Sharepoint

Search:

Welcome: Guest!

Sharepoint Forum

Home » Forum » Sharepoint

Ask a question

RSS Feeds

Need Help With Moving SharePortal Portal to a New Farm

Asked By: Felicia Hunter Date: May 22, 2006 Category: Sharepoint Views: 234

I tried the methodology by Daniel Orchard (Mindsharp Premium
Content) for moving (actually copying) our production portal to
another farm 6 or 7 times. It always fails on the restore of the 3
databases SITE, SHARE, and PROF. The log file
says: "GetDatabaseByName Failed. Trying to obtain path from master
database."

1. Both Farms are patched exactly the same.
2. Using the same domain service account for both.
3. The service account has the exact permissions need in SQL Server.
4. Both farms are using SQL Server 2000 - not 2005.
5. The target farm is a VM. SS 2000 is on the same VM as the new
farm.
6. The only database that successfully gets moved is the teamdbs
database.

Tagged:need help with moving shareportal portal to new farm

2 Answers Found

Answer #1 Answered By: Alexis Ellis Answered On: May 22, 2006

Open SQL Server Enterprise Manager. Check the database path to make sure it is the same as your Config_db. If it is not, then that may be the problem. If you change the path, then you will need to restart SQL Server.

Answer #2 Answered By: Percy Beach Answered On: May 22, 2006

What you could actually do is run the manual restore commands that SPSBackup uses. If you look in the failed restore log you will see the SQL Restore commands it uses. If you open query analyzer you can run them from there. This should then restore the databases. Once done you will then need to choose the restore option from the Create Portal page and use those Database names. This should restore. The only time I have seen an issue is if the Virtual server you have backed up (i.e. using Host headers) does not exist on the new server farm.

Didn't find what you were looking for? Find more on Need Help With Moving SharePortal Portal to a New Farm Or get search suggestion and latest updates.