Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Need to copy a WSS 3.0 database to a SQL Server 2005 x64?

Posted on 2011-03-01
3
Medium Priority
?
582 Views
Last Modified: 2012-08-13
Hi, I need to copy or export/import a WSS 3.0 database to a SQL Server 2005 x64 server.

Here is my setup(environment):
Current WSS 3.0 server:
Server 2003 R2 x32 Standard using the built-in database of SharePoint Services 3.0

New Servers:
Server 2008 R2 Standard running SharePoint Foundation 2010 farm that the database is on another server running SQL server.

Server 2008 R2 Standard running SQL Server 2005 SP4 that will host the database for the SharePoint Foundation 2010 server.


Thanks to a guru here, I have this link
http://technet.microsoft.com/en-us/library/cc287738(office.12).aspx
that explains the steps.  

However, I have concerns about removing the web application associaton, because I would just like to copy the current database and keep it up and running on the current server while I finish tweaking and getting the new server up and running.

So, can I remove the web application association just long enough to copy the database content from the server and then reassociate it to the web application and everything be running as if nothing happened from the users view?  Or maybe even boot the server in safe mode to copy the database content and then reboot in normal mode?

Thanks in advance.
0
Comment
Question by:rsnellman
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 3

Accepted Solution

by:
mordi earned 2000 total points
ID: 35010349
Hi,
You may remove the web application association , copy the database files to other server and then reassociate it to the web application and everything will be running as if nothing happened from the users view.
In parallel you can setup and test your new 2008 environment till it is ready to go live.
0
 

Author Comment

by:rsnellman
ID: 35017505
Awesome.  OK, one more question.  How do I reassociate the web application?  I have never done this and before I proceed I want to know all the steps so I have no surprises, which will help minimize the downtime of the WSS.

Thanks.
0
 
LVL 3

Assisted Solution

by:mordi
mordi earned 2000 total points
ID: 35019525
Please follow the detailed procedure as explained in this link:


http://technet.microsoft.com/en-us/library/cc287634.aspx
0

Featured Post

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A safe way to clean winsxs folder from your windows server 2008 R2 editions
A while back, I ran into a situation where I was trying to use the calculated columns feature in SharePoint 2013 to do some simple math using values in two lists. Between certain data types not being accessible, and also with trying to make a one to…
This tutorial will show how to push an installation of Backup Exec to an additional server in both 2012 and 2014 versions of the software. Click on the Backup Exec button in the upper left corner. From here, select Installation and Licensing, then I…
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question