Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds


  Asked By: Madeline    Date: Oct 11    Category: Sharepoint    Views: 534

Anyone know how to backup the SPS environment if I am going to use a new SQL
backend (from SQL2000 to SQL2005)



10 Answers Found

Answer #1    Answered By: Maegan Ellison     Answered On: Oct 11

What I've done is backed up the existing SQL 2000 (PROF, SERV, SITE dbs)
and restored it on SQL 2005. Then go into Central Administration and
instead of creating a new portal, I did a restore.

Just did this over the weekend and the portal is working fine.

Answer #2    Answered By: Yahaira Shannon     Answered On: Oct 11

Did you delete the portal prior to restoring?

How about the config database?

Answer #3    Answered By: Doris Leach     Answered On: Oct 11

I did a restore on a new box (no existing portal) with a dedicated SQL server as
the backend. Out of all the restore that I have done, I've never had to restore
the config db. So you want to leave your portal alone but migrate all data from
a SQL 2000 server to a SQL 2005 server, is this correct?

Answer #4    Answered By: Sumitra 2004     Answered On: Oct 11

Yes. I want to leave my front end alone. Just changes to the back end.

Answer #5    Answered By: Bhairavi Damle     Answered On: Oct 11

I've only done this on my development environment  and I was successful.
In a live environment, I've always had to do a complete restore, both
front end and back end SQL.

1. Back up the PROF, SERV and SITE databases. Restore these 3
databases on your SQL 2005 server.
2. Disconnect from your existing config database. If you are
successful in disconnecting, the next page that should show up is the
same page asking you if you want to create a new config database or
connect to an existing one. Select create a new config database
3. Point to the new SQL 2005 server and give a name for your config
4. Go into the "create a portal" page and select restore a portal.
5. Point to the 3 databases on the SQL 2005 server.
6. It should restore successfully

Somebody else might chime in on these procedures.

Answer #6    Answered By: Leeann Hull     Answered On: Oct 11

Will this work if you have custom images, icons, and webparts created?

Answer #7    Answered By: Vaasu Radhakrishna     Answered On: Oct 11

Custom images and icons will migrate but I'm not sure about the custom
web parts. I think you need to manually bring them over to the new

Answer #8    Answered By: Brinda Bca     Answered On: Oct 11

Do I have to change the compatibility of the databases after restoring it to
a 2005 server?

Answer #9    Answered By: Sheryl Velez     Answered On: Oct 11

What do you mean by "change the compatibility of the databases"?

Didn't find what you were looking for? Find more on SQL2005 Or get search suggestion and latest updates.