?
Solved

Can you use Microsoft SQL Server Management Studio Express with SharePoint Services 3.0?

Posted on 2011-03-23
1
Medium Priority
?
625 Views
Last Modified: 2012-05-11
Hi, I am working on migrating our SharePoint Services 3.0 that is using the Internal Database product that comes with it, which I believe to be SQL Server 2005 Express.  

I was wondering if I could use the Microsoft SQL Server Managemet Studio Express tool to make a backup copy of the database and then move it to the new SQL Server 2005 SP4 x64 machine to restore it to be on the new SharePoint Foundation 2010 machine?

I just was wondering if this would be a smoother, cleaner migration of the Express database then using the disassociation of the web app on the machine and then just copy and pasting the database to the new machine.

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
1 Comment
 
LVL 14

Accepted Solution

by:
GeorgeGergues earned 2000 total points
ID: 35198654
That is doable

Install management tool on the sharepoint server ,, backup the SQL DB and copy yo destination for Restore


Best of luck.
0

Featured Post

Office 365 Training for Admins - 7 Day Trial

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

I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
A procedure for exporting installed hotfix details of remote computers using powershell
This tutorial will walk an individual through locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …
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…
Suggested Courses

762 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