+ Post New Thread
Results 1 to 12 of 12
How do you do....it? Thread, Moving a Sharepoint database in Technical; Has anybody moved their default Sharepoint database from the SSEE install to another server running SQL 2005? I want to ...
  1. #1

    Sylv3r's Avatar
    Join Date
    Jul 2005
    Location
    Co. Durham
    Posts
    3,213
    Thank Post
    372
    Thanked 379 Times in 337 Posts
    Rep Power
    148

    Moving a Sharepoint database

    Has anybody moved their default Sharepoint database from the SSEE install to another server running SQL 2005?

    I want to leave one server running the Sharepoint, IIS etc but the database on its own server.

    They are quite a few guides around, but they all seem to mention different possibilities of moving the database. Does anybody have a tried and tested way of doing it that has worked for them?

    Thanks

  2. #2
    apearce's Avatar
    Join Date
    Feb 2008
    Location
    Birmingham
    Posts
    417
    Thank Post
    36
    Thanked 176 Times in 111 Posts
    Rep Power
    43
    you might think twice after you have heard/read this. ;-)

    SharePoint is the worst product to move when it comes to the database.

    You have to back up your site, delete it, rebuild it with 2 servers (web/application server and database server) and then restore it.

    Have a look at this post.
    Chris Hernandez's Blog : Migrating Microsoft Office SharePoint Server (MOSS) from Standalone to Farm Install

    A.

  3. Thanks to apearce from:

    stariq (15th November 2008)

  4. #3

    Sylv3r's Avatar
    Join Date
    Jul 2005
    Location
    Co. Durham
    Posts
    3,213
    Thank Post
    372
    Thanked 379 Times in 337 Posts
    Rep Power
    148
    Quote Originally Posted by apearce View Post
    you might think twice after you have heard/read this. ;-)

    SharePoint is the worst product to move when it comes to the database.

    You have to back up your site, delete it, rebuild it with 2 servers (web/application server and database server) and then restore it.

    Have a look at this post.
    Chris Hernandez's Blog : Migrating Microsoft Office SharePoint Server (MOSS) from Standalone to Farm Install

    A.
    Your right, its not as straight forward as I had hoped. Is it any easy to keep the database on the same server but to move it to a different drive? I am just concerned that with the database on the c:\ it won't be long before the drive runs out of space. Drive d:\ has 200gig free.

    I can either leave it running the free SQL server or upgrade to Microsoft SQL 2005 also.

    Thanks

  5. #4
    apearce's Avatar
    Join Date
    Feb 2008
    Location
    Birmingham
    Posts
    417
    Thank Post
    36
    Thanked 176 Times in 111 Posts
    Rep Power
    43
    have a look at this post.

    SharePoint looks at the database service rather than directly at the database - all application that use sql do actually, so you might be able to do the fellowing

    How to move SQL Server databases to a new location by using Detach and Attach functions in SQL Server

    Alex

  6. Thanks to apearce from:

    vikpaw (2nd October 2013)

  7. #5
    meastaugh1's Avatar
    Join Date
    Jul 2006
    Location
    London/Hertfordshire
    Posts
    890
    Thank Post
    69
    Thanked 85 Times in 70 Posts
    Rep Power
    32
    You might find these specific instructions for moving SQL internal database between drives: Saurabh: How do you move the "Windows Internal Database" (embedded SQL Server 2005 Express) to a different drive than C:

    Have used it successfully in the past.

  8. #6

    john's Avatar
    Join Date
    Sep 2005
    Location
    London
    Posts
    10,619
    Thank Post
    1,499
    Thanked 1,053 Times in 922 Posts
    Rep Power
    304
    Could you not just do as I did and expand the C Drive into the space you D takes? I extended my RAID array into another 2 disks and then expanded the C Drive using a Linux boot CD (referenced on here somewhere ages ago for expanding / shrinking partitions in relation to dual booting). The system was fine after doing it and had no issues and meant I added another 150 gig of space to the C Drive for it to eat into.

  9. #7

    Sylv3r's Avatar
    Join Date
    Jul 2005
    Location
    Co. Durham
    Posts
    3,213
    Thank Post
    372
    Thanked 379 Times in 337 Posts
    Rep Power
    148
    Does anybody know why I get the following error message when trying to detach the DB?

    C:\Program Files\Microsoft SQL Server\90\Tools\Binn>sqlcmd -S \\.\pipe\mssql$mic
    rosoft##ssee\sql\query -e
    1> exec dp_detach_db WSS_Content_90e86af1-7af5-47e8-8825-ca925695eee2
    2> GO
    exec dp_detach_db WSS_Content_90e86af1-7af5-47e8-8825-ca925695eee2

    Msg 102, Level 15, State 1, Server STB-SVR-SBLG\MICROSOFT##SSEE, Line 1
    Incorrect syntax near '-'.
    1>

  10. #8
    meastaugh1's Avatar
    Join Date
    Jul 2006
    Location
    London/Hertfordshire
    Posts
    890
    Thank Post
    69
    Thanked 85 Times in 70 Posts
    Rep Power
    32
    This would suggest that it's because the hyphen is an invalid character in the database name, therefore you need to put the database name in square brackets.

  11. Thanks to meastaugh1 from:

    Sylv3r (25th October 2008)

  12. #9

    Domino's Avatar
    Join Date
    Oct 2006
    Location
    Bromley
    Posts
    4,168
    Thank Post
    217
    Thanked 1,280 Times in 798 Posts
    Blog Entries
    4
    Rep Power
    511
    you could ghost the c:\ drive, repartition and then reinstall?

    I've used the stsadm tool to move an entire install to a different server. it took a day of messing around, but worked 100% afterwards

    Mauro Cardarelli : Quick Tutorial on Moving a WSS Site

  13. #10

    Sylv3r's Avatar
    Join Date
    Jul 2005
    Location
    Co. Durham
    Posts
    3,213
    Thank Post
    372
    Thanked 379 Times in 337 Posts
    Rep Power
    148
    Quote Originally Posted by meastaugh1 View Post
    This would suggest that it's because the hyphen is an invalid character in the database name, therefore you need to put the database name in square brackets.
    That was it thanks.

  14. #11

    Sylv3r's Avatar
    Join Date
    Jul 2005
    Location
    Co. Durham
    Posts
    3,213
    Thank Post
    372
    Thanked 379 Times in 337 Posts
    Rep Power
    148
    Damn this is getting annoying now.... Getting another error message, Do I need to put the square brackets anywhere? I have tried the obvious places but still no joy.

    1> EXEC sp_attach_db @dbname = N`WSS_Content_90e86af1-7af5-47e8-8825-ca925695eee
    2`, @filename1 = N`d:\sharepointdb\WSS_content_90e86af1-7af5-47e8-8825-ca925695e
    ee2.mdf`, @filename2 = N`d:\sharepointdb\WSS_Content_90e86af1-7af5-47e8-8825-ca9
    25695eee2_log.ldf`
    2> GO
    Msg 102, Level 15, State 1, Server STB-SVR-SBLG\MICROSOFT##SSEE, Line 1
    Incorrect syntax near '`'.
    Msg 132, Level 15, State 1, Server STB-SVR-SBLG\MICROSOFT##SSEE, Line 1
    The label 'd' has already been declared. Label names must be unique within a query batch or stored procedure.
    1>

  15. #12
    meastaugh1's Avatar
    Join Date
    Jul 2006
    Location
    London/Hertfordshire
    Posts
    890
    Thank Post
    69
    Thanked 85 Times in 70 Posts
    Rep Power
    32
    I think you need to use an apostrophe ' and not a grave accent `.

SHARE:
+ Post New Thread

Similar Threads

  1. SharePoint Database size
    By imiddleton25 in forum Virtual Learning Platforms
    Replies: 4
    Last Post: 29th July 2008, 01:02 PM
  2. Moving Sleuth database to another server.
    By Kyle in forum Educational Software
    Replies: 0
    Last Post: 10th December 2007, 10:05 AM
  3. Moving the EduGeek Database
    By Ric_ in forum General EduGeek News/Announcements
    Replies: 28
    Last Post: 20th July 2007, 08:19 AM
  4. HELP!!!! - Database
    By lalalalalalalalalalala in forum How do you do....it?
    Replies: 1
    Last Post: 21st March 2007, 09:03 PM
  5. Replies: 4
    Last Post: 28th February 2007, 09:37 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •