Home | Site Map | Cisco How ToNet How To | Wireless |Search | Forums | Services | Donations | Careers | About Us | Contact Us|

Move WSS 3.0 databases to a full SQL version

Network Sharing , TCP/IP, Internet, Wireless, Exchange, IIS, ISA and Print

Move WSS 3.0 databases to a full SQL version

Postby guest » Sat Apr 26, 2008 11:26 am

Q: I have WSS v3 running on SBS 2003. I was told that WSS running SQL Embedded edition has a database limitation. I am planning to install SQL full version on the SBS. What are the requirements and How to do it?

A: the migration process can be outlined in the
following four steps:

Step One: Backup the web application and check the database
Step Two: Detach the Content Database
Step Three: Re-attach the content database to the new SQL Server
Step Four: Connect the Content Databases again

For the detailed steps, please refer to the information below:

Step One: Backup the web application and check the database
======
1.1 Start SharePoint 3.0 Central Administration and Click Operation Tab.
1.2 Click "Perform a Backup" under Backup and Restore.
1.3 Check the Farm to including all elements and make notes of all the
configuration database and content database name.
1.4 Select "Continue to Backup Options" and select "Full" backup, type the
file path for backup file location.
1.5 After finishes, check the file path for backup file location.

Step Two: Detach the Content Database
======
2.1 Download and install the SQL client and the Sqlcmd utility. These tools
are available in the latest feature pack for Microsoft SQL Server 2005. For
more information about the feature pack for Microsoft SQL Server 2005,
visit the following Microsoft Web site:
<http://www.microsoft.com/downloads/details.aspx?FamilyID=df0ba5aa-b4bd-4705
-aa0a-b477ba72a9cb&DisplayLang=en>

2.2 Control Panel -> Administrative Tools -> find the "SQL Server 2005
Embedded Edition (MICROSOFT##SSEE)" service and ensure it is already
started.
2.3 Click Start -> Run -> Type "cmd" (without quotation marks). Run the
following command:
sqlcmd -S \\.\pipe\mssql$microsoft##ssee\sql\query -E
2.4 Detach the database with following command:
exec sp_detach_db 'db_name' (db_name is content database name that you
would like to move database file to)

Note: If you install SQL Server on the same server running WSS 3.0, you
don't need to perform the step 2.5.

2.5 When it finishes, move the database files from
%systemroot%\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data (by default, you may further
verify it) to the new server. (both the .mdf and .ldf files are required to
be moved)

Step Three: Re-attach the content database to the new SQL Server
======
3.1 On the new server, Start SQL Server 2005 Management Studio with the SQL
Server
2005 instace.
3.2 Right-Click Databases and click Attach.
3.3 Click Add and add the .mdf and .ldf moved.
3.4 Re-attach the old content database to new SQL Server 2005.

Step Four: Connect the Content Databases again
=======
4.1 Start SharePoint 3.0 Central Administration in the new server and Click
Application Management Tab.
4.2 Create a new web application without create site collection.
4.3 Select the new created web application and click "Content Databases".
4.4 Click "Add a content database"
4.5 Type the Database Server Name and the Content Database name (you have
just moved).
4.6 Click OK to re-connect the content database to web application.
4.7 If you encounter any error message to add content database, please use
stsadm tool to add the content database. At the command prompt, type the
following command to attach the content database, and then press ENTER:
> cd %commonprogramfiles%\microsoft shared\web server extensions\12\bin
> stsadm -o addcontentdb -url http://URLofWindowsSharePointServicesSite
-databasename DatabaseName -databaseserver DatabaseServer.

Note The placeholders in this command are defined as follows:

a. http://URLofWindowsSharePointServicesSite is the URL of the SharePoint
site that hosts the content database.
b. DatabaseName is the name of the database that you want to attach to the
new Web application.
c. DatabaseServer is the name of the computer that hosts the content
database.

For more information, please reference the following article in Microsoft
Knowledge Base:

Move content database from Windows Internal Database to a SQL Server
instance (Windows SharePoint Services)
http://technet.microsoft.com/en-us/libr ... 87738.aspx

How to move SQL Server databases to a new location by using Detach and
Attach functions in SQL Server
<http://support.microsoft.com/kb/224071>
Tablet and Smartphone Setup Guide
http://www.quicksetupguide.com

Troubleshooting Vista Wireless
http://chicagotech.net/
guest
 
Posts: 10191
Joined: Mon Nov 27, 2006 1:10 pm

Postby guest » Tue Jun 24, 2008 8:16 pm

You would
like to move the WSS v3 database from the default location to a different
driver.

If this is not correct, please let me know.

We have such documentation providing the detailed steps on how to move WSS
database, however, it is for WSS v2. You can take a look at this article
below:

How to change the location of the Windows SharePoint Services database files
http://support.microsoft.com/?id=843580

For WSS v3, I would like to recommend you reference the following steps to
change the database location.

#1. Back up all the database file
=======================
1.1 Start SharePoint 3.0 Central Administration and Click Operation Tab.
1.2 Click "Perform a Backup" under Backup and Restore.
1.3 Check the Farm to including all elements and make notes of all the
configuration database and content database name.
1.4 Select "Continue to Backup Options" and select "Full" backup, type the
file path for backup file location.
1.5 After finishes, check the file path for backup file location.

#2. Disconnect the Content Databases in SharePoint 3.0 Central
Administration page
=======================
2.1 Download and install the SQL client and the Sqlcmd utility. These tools
are available in the latest feature pack for Microsoft SQL Server 2005. For
more information about the feature pack for Microsoft SQL Server 2005,
visit the following Microsoft Web site:
<http://www.microsoft.com/downloads/details.aspx?FamilyID=df0ba5aa-b4bd-4705
-aa0a-b477ba72a9cb&DisplayLang=en>

2.2 Control Panel -> Administrative Tools -> find the "SQL Server 2005
Embedded Edition (MICROSOFT##SSEE)" service and ensure it is already
started.
2.3 Click Start -> Run -> Type "cmd" (without quotation marks). Run the
following command:
sqlcmd -S \\.\pipe\mssql$microsoft##ssee\sql\query -E

#3. Detach the database and move database file to another drive
=======================
3.1 Detach the database with following command:
exec sp_detach_db 'db_name'
(db_name is content database name that you would like to move database file
to)

3.2 At the 2> prompt, type Go, and then press ENTER.

3.3 When it finishes, move the database files from
%systemroot%\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data (by default, you may further
verify it) to drive D. (both the .mdf and .ldf files are required to be
moved)

#4. Attach the database and re-connect the Content database using STSADM
tool.
===============================
First attach the database with following command:
exec sp_attach_db 'db_name'

At the 2> prompt, type Go, and then press ENTER.

Now you can use the Stsadm.exe command-line tool with the addcontentdb
operation to re-add the content database. Then, restart the SQL Server 2005
Embedded Edition service.

To do this, follow these steps:

1. Use the Stsadm.exe command-line tool with the addcontentdb operation to
re-add the content database. To do this, follow these steps:

a. Click Start, click Run, type cmd in the Open box, and then click OK.
b. Type the following lines at the command prompt. Press ENTER after each
line:
cd /d %commonprogramfiles%\Microsoft Shared\Web Server Extensions\12\Bin
stsadm -o addcontentdb -url URL -databasename DatabaseName
c. Type exit to close the command prompt.

2. Restart the SQL Server 2005 Embedded Edition service. To do this, follow
these steps:

a. Click Start, point to Administrative Tools, and then click Services.
b. In the list of services, right-click SQL Server 2005 Embedded Edition,
and then click Stop.
c. Right-click SQL Server 2005 Embedded Edition, and then click Start.

Reference:
=========
How to move SQL Server databases to a new location by using Detach and
Attach functions in SQL Server
http://support.microsoft.com/kb/224071

sp_detach_db (Transact-SQL)
http://msdn2.microsoft.com/en-us/library/ms188031.aspx

sp_attach_db (Transact-SQL)
http://msdn2.microsoft.com/en-us/library/ms179877.aspx
Tablet and Smartphone Setup Guide
http://www.quicksetupguide.com

Troubleshooting Vista Wireless
http://chicagotech.net/
guest
 
Posts: 10191
Joined: Mon Nov 27, 2006 1:10 pm


Return to Networking

Your Ad Here

Who is online

Users browsing this forum: No registered users and 4 guests