Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

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

Tech or Treat! - Giveaway

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

Question has a verified solution.

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

Background Information Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
For anyone that has accidentally used newSID with Server 2008 R2 (like I did) and hasn't been able to get the server running again because you were unlucky (as I was) and had no backups - I was able to get things working by doing a Registry Hive rec…
This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

618 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