Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 591
  • Last Modified:

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

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
rsnellman
Asked:
rsnellman
  • 2
2 Solutions
 
mordiCommented:
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
 
rsnellmanAuthor Commented:
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
 
mordiCommented:
Please follow the detailed procedure as explained in this link:


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

Featured Post

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now