Improve company productivity with a Business Account.Sign Up

x
?
Solved

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

Posted on 2011-03-23
1
Medium Priority
?
638 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
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

Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Understanding the various editions available is vital when you decide to purchase Windows Server 2012. You need to have a basic understanding of the features and limitations in each edition in order to make a well-informed decision that best suits …
I tried to use the SharePoint app to Import a Spreadsheet and import an Excel sheet into a Team site made in SharePoint 2016. But that just resulted in getting an error message 'Unknown Error'...
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 …
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…

608 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