Best & Easy way to migrate
==========================
* On to the Old Moss Server it's running on SQL Embedded Edition (Named Pipe)
There is a possible way to take the database out from the SPS1 server &
Place it on to the DBServer
* On the SPS1 Server goto HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft
SQL Server\MSSQL.1\MSSQLServer\SuperSocketNetLib\Np
& Copy the Pipename value e.g \\.\pipe...
* Download Microsoft SQL Server Management Studio Express
http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en
* After installation whe you open the application it will popup with
servername & user credentials screen
* Change the server name to (paste named pipe Address that we Copied from
the regisrty) & Click on ok
* Right Click on the databases & take a backup
* Now you can restore these databases on the Deicated SQL Server DBServer
* On the SPS2 server create a Web Application on desired port
* After creating the web application you will have to remove the database
associated with it
So On SPS2 Box Open Central Administration Site >>> Application management
Remove the associated database from the newly created web application
* Attaching the database which were restored on DBServer
On SPS2 box open CMD & goto 12\bin folder &
stsadm -o addcontentdb -url http://servername:port# -databasename
restoredatabasename
* After operation is Completed perform in IISRESET
* Happy browsing
Sorry for late Response as was not aware of this Site... But came here
searching for something ...
Post by Sniper manAll,
I using the SharePoint Service 3.0 for our document management. Now, I
want to migrate the existing SharePoint Service database to SQL 2005, how to
upgrade to SQL server 2005? Please help
Thanks,
Vincent