Sylv3r Posted October 18, 2008 Posted October 18, 2008 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
apearce Posted October 18, 2008 Posted October 18, 2008 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. 1
Sylv3r Posted October 18, 2008 Author Posted October 18, 2008 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
apearce Posted October 18, 2008 Posted October 18, 2008 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 1
meastaugh1 Posted October 19, 2008 Posted October 19, 2008 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.
john Posted October 19, 2008 Posted October 19, 2008 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.
Sylv3r Posted October 25, 2008 Author Posted October 25, 2008 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>
meastaugh1 Posted October 25, 2008 Posted October 25, 2008 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. 1
Domino Posted October 25, 2008 Posted October 25, 2008 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
Sylv3r Posted October 25, 2008 Author Posted October 25, 2008 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.
Sylv3r Posted October 25, 2008 Author Posted October 25, 2008 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>
meastaugh1 Posted October 25, 2008 Posted October 25, 2008 I think you need to use an apostrophe ' and not a grave accent `.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now