STS FAQ - How do I transfer my STS MSDE database from...

Section:

SubSection:

Number:

Title:

How do I transfer my STS MSDE database from one location to another?

Body:

The following complicated method was carried out successfully by one newsgroup member.

"Basically the process is:

1. Stop SQL server
2. Reinstall MSDE to point to the new drive location.
3. Verify/modify registry for SQL data file locations.
4. Copy old DB files to new location.
5. Start SQL server
6. Use SQL admin utility to connect to the master db
(since MSDE does not come with one, I found a freebie called SQLExecMS; see link below)
7. Create new DB for each site and point to new file location.
8. Use MSDE import/export utility to copy SQL data and objects from
old db to new db.
9. Use SPTS admin page to change DB name to new DB created in step 7.
10. Detach old DB from master db using the SQL admin utility.
11. Repeat steps 7-10 as needed for each site.

I successfully moved 5 sites using this process. Be sure to only COPY
the original DB files as mentioned in step 4. It may be necessary to attach to them at some later time if some data is corrupted or not available by other means."

(FAQ writer) I have not tried this myself

-----------

Another alternative approach mentioned in the newsgroup was as follows

1. Follow the technote

(http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sharepnt/deploy/upgrdmigrate/spmigrat.asp)

until you get to the section "Migrating Data Stored in the SQL Server Databases". Skip the first two sections on backing up and restoring the SQL database. The backup step is being completed nightly on our server to "c:\mssql7\backup\nightly_backup.bak" and is being captured to tape. Copy the most recent backup file to the destination server. Don't attempt to restore yet.

2. Complete the steps in the section "Assigning the Database". Rename the database to match the server's database such as "server_LM_W3SVC_1_Collab"

3. Restart web services or reboot the server.

4. Open SharePoint's Administration web page and do a Restore pointing
to the BAK file from the server.

5. Complete the last section in the technote "Upgrading the Site".

6. Open SharePoint on the new server!!

(FAQ writer) I have not tried this either.

Link:

http://www.geocities.com/laplassoft/

11.2 - How do I transfer my STS MSDE database from one location to another?

Attachments:

Created at 5/27/2005 6:56 PM by Jim

Last modified at 5/27/2005 7:02 PM by Jim