?
Solved

Sharepoint server moving database

Posted on 2014-03-05
3
Medium Priority
?
374 Views
Last Modified: 2014-03-06
HI All,

My current sharepoint 2007 is running on sql 2005.  I want to move the database to new SQL 2008 R2 version.  
Can someone help me with the steps to migrate from one server to another server for database pelase
0
Comment
Question by:romeiovasu
[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
3 Comments
 
LVL 10

Expert Comment

by:Mohit Nair
ID: 39908546
First  you need to check for the database files which means mdf and LDF. You can go to SQL Server Management Studio and right click on the database, than select properties, than go to Files, you will see two files displayed in a table on is MDF file and Log file , check the path ! go to that folder.  You need to copy both mdf and ldf files and move to the new server. Before you copy the file you should stop the SQL database engine services from services.msc.
Save this file in any location. Now go to management studio on the new server with 2008 instance and right click databases folder. Select attach and navigate to the place where u have the mdf file copied.
Perform the same step for all other databases.

The shortest and easiest way..
0
 

Author Comment

by:romeiovasu
ID: 39908907
Then how can I point the sharepoint to new database.
0
 
LVL 38

Accepted Solution

by:
Justin Smith earned 2000 total points
ID: 39909209
Following mohit's steps above is only half the solution.  SharePoint needs to know the name of the new server.

The easiest thing to do is create a SQL Alias on your SharePoint machine.  You basically create an alias name for the existing server, and point it to the new server name.

http://sharepointpromag.com/sharepoint-administration/simple-guide-moving-sharepoint-content-databases-new-server
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…
When using a search centre, I'm going to show you how to configure Sharepoint's search to only return results from the current site collection. Very useful when using Office 365 with multiple site collections.
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

801 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