Solved

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

Posted on 2011-03-23
1
609 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 500 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply 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…

920 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now