Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Need Help With Moving SharePortal Portal to a New Farm

  Asked By: Felicia    Date: May 22    Category: Sharepoint    Views: 897

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.

Share: 

 

2 Answers Found

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

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

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.




Tagged: