Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Sharepoint database migration 1
- Thread starter arol
- Start date
-
1
- #2
Thomas2000
Technical User
Hello,
have you reconfigured in SharePoint Central Admin to use the new configuration database? It can be a bit tricky migrating or moving the configuration database.
If you backup the configuration database on the original server and then on the new sql server you create a new database, and then restore the configuration database to that one.
Then you will have to reconfigure in SharePoint Central Admin and point it to the new SQL server and database. Just make sure you have the old one still in place just incase something does not work on the new machine.
I have done this before and at some times I had problems that SPS could not connect to the new server. So make sure that the same account used in on the old server has rights to the new SQL database (server)
Just so I have not missunderstood you. It is when you have used the Backup Database in EnterPrise Manager and then try to restore it that it does not work? Or is it when you try to reconfigure it in SharePoint Central Administration?
Regards,
Thomas
have you reconfigured in SharePoint Central Admin to use the new configuration database? It can be a bit tricky migrating or moving the configuration database.
If you backup the configuration database on the original server and then on the new sql server you create a new database, and then restore the configuration database to that one.
Then you will have to reconfigure in SharePoint Central Admin and point it to the new SQL server and database. Just make sure you have the old one still in place just incase something does not work on the new machine.
I have done this before and at some times I had problems that SPS could not connect to the new server. So make sure that the same account used in on the old server has rights to the new SQL database (server)
Just so I have not missunderstood you. It is when you have used the Backup Database in EnterPrise Manager and then try to restore it that it does not work? Or is it when you try to reconfigure it in SharePoint Central Administration?
Regards,
Thomas
- Thread starter
- #3
I'm actually using sharepoint in conjunction with Project server. when I restore the sharepoint databases to the new server I get an error about sites referenced not being present in the config database
when I look at sites table in config database, the sites still point to the old server
when I look at sites table in config database, the sites still point to the old server
- Thread starter
- #4
!!!Help!!
I am installing Project server 2003 to use sharepoint services. This is a single server install combining iis, project server and sql 2000
This is intended as an upgrade to an existing server with different hardware.
I have no problems restoring the project database from the old server to the new server as long as i delete the old login and create a new one.
However When I restore the content and configuration databases to the new server, I can't seem to connect to the content database from sharepoint administration page.
Any suggestions
I am installing Project server 2003 to use sharepoint services. This is a single server install combining iis, project server and sql 2000
This is intended as an upgrade to an existing server with different hardware.
I have no problems restoring the project database from the old server to the new server as long as i delete the old login and create a new one.
However When I restore the content and configuration databases to the new server, I can't seem to connect to the content database from sharepoint administration page.
Any suggestions
Thomas2000
Technical User
Hello,
The content database should not be very hard to reconfigure. In the Central Admin, in the DB section where you can chose to configure connections to content databases, you can add your new content database on the new machine as another content database and then chose to connect the site(s) that you want to use.
What kind of errors do you get when you try to change the content database? Have you made sure that the account used to connect to the Databases has enough rights on the new SQL server? There is a section in the Windows SharePoint Administrators guide that lists scripts how you change this properly (it is under the section Changing Application pool identity for a virtual server, scroll down and you will see how to change the db rights in a proper way)
Also in a previous post you say that the sites points to the old server, are you using DNS resolution for the sites? then you will have to change the DNS entries aswell to point to the new server.
Regards,
Thomas
The content database should not be very hard to reconfigure. In the Central Admin, in the DB section where you can chose to configure connections to content databases, you can add your new content database on the new machine as another content database and then chose to connect the site(s) that you want to use.
What kind of errors do you get when you try to change the content database? Have you made sure that the account used to connect to the Databases has enough rights on the new SQL server? There is a section in the Windows SharePoint Administrators guide that lists scripts how you change this properly (it is under the section Changing Application pool identity for a virtual server, scroll down and you will see how to change the db rights in a proper way)
Also in a previous post you say that the sites points to the old server, are you using DNS resolution for the sites? then you will have to change the DNS entries aswell to point to the new server.
Regards,
Thomas
- Status
Similar threads