Cannot move Sharepoint database

Here's my cheat sheet, do this often



Moving Sharepoint:

Iisreset /stop

Net stop sptimer

osql -E -S %computername%\SharePoint

EXEC sp_detach_db 'STS_Config', 'true' GO EXEC sp_detach_db 'STS_Server_1',
'true' GO Copy database to new partition

EXEC sp_attach_db 'STS_config', 'd:\New_Location\STS_config.mdf',
'd:\New_Location\STS_config_log.LDF' GO EXEC sp_attach_db 'STS_server_1',
'd:\New_Location\STS_server_1.mdf', 'd:\New_Location\STS_Server_1_log.LDF'
GO Net start sptimer

Iisreset /start



wrote in message

> Hi,
> I'm trying to move my Sharepoint data files (following the instructions
> in the "Moving Data Folders for Windows Small Business Server 2003");
> however I ran into the following problem:
>
> Under IIS, for the 3 sharepoint related websites, I only have
> companyweb and Microsoft Sharepoint Administration. I do not have the
> 3rd website mentioned in the article -- Sharepoint Central
> Administration.
>
> I attempted to follow the instructions, nevertheless, and stopped the 2
> websites. When I then tried to detach the data files, I got the
> following:
>
> C:\>osql -E -S MYSERVER\Sharepoint -Q "sp_detach_db 'STS_MYSERVER_1'
> "
> Msg 3701, Level 16, State 1, Server MYSERVER\SHAREPOINT, Line 1
> Cannot detach the database 'STS_MYSERVER_1' because it is currently in
> use.
>
> I don't know how it can be in use as I have closed all relevant
> programs or windows (Server Console, IExplorer, etc). Could it be that
> I do have the Sharepoint Central Administration but it is not a
> website?
>
> Any advice much appreciated.
> Thank you,
>
> Greg
>
 >> Stay informed about: Cannot move Sharepoint database 

Hi Greg,

Thank you for posting in SBS newsgroup.

I am sorry for the delayed response due to weekend. Please understand that
the newsgroups are staffed weekdays by Microsoft Support professionals to
answer your systems and applications questions. Your understanding is
greatly appreciated!

From your description, I understand the issue to be: You encounter error
when you detach SharePoint database and you also have not SharePoint
Central Administration in IIS. If I have misunderstood your concerns,
please do not hesitate to let me know.

Do you mean you are following the document to move the SharePoint data?

Moving Data Folders for Windows Small Business Server 2003
http://www.microsoft.com/downloads/details.aspx?FamilyID=A1D0AF69-1287-4225-
BD8B-59C89F44984B&displaylang=en

If so, the problem may be caused by the corruption of the Companyweb due to
you have missed SharePoint Central Administration. Currently you can try
the following steps to see how thing goes:

Please make sure you have keyed the -E, -S, and -Q command line parameters
as capital letters.

c:> OSQL -E -S servername\sharepoint <Enter>
> sp_detach_db ''STS_Config'' <Enter>
> go <Enter>
> sp_detach_db ''STS_servername_1'' <Enter>
> go <Enter>

If the issue still occurs, you may need to reinstall the companyweb
following the KB articles and then move the data:

829114 How to remove and how to install the Windows Small Business Server
2003 SharePoint Services companyweb Web site
http://support.microsoft.com/default.aspx?scid=kb;EN-US;829114

829113 How to restore a Windows SharePoint Services CompanyWeb database
after the intranet component and SQL Server or MSDE 2000 have been removed
on Windows Small Business Server
http://support.microsoft.com/default.aspx?scid=kb;EN-US;829113

827701 How to perform a disaster recovery operation of SharePoint Services
Companyweb and SharePoint Services Databases
http://support.microsoft.com/default.aspx?scid=kb;EN-US;827701

829112 How to back up and restore http://companyweb data in Windows Small
Business Server 2003
http://support.microsoft.com/default.aspx?scid=kb;EN-US;829112

Please feel free to let me know if you have any further concerns or
questions regarding the issue.

I appreciate your time and look forward to hearing from you.

Best regards,

Crina Li (MSFT)

Microsoft CSS Online Newsgroup Support

Get Secure! - www.microsoft.com/security

=====================================================
This newsgroup only focuses on SBS technical issues. If you have issues
regarding other Microsoft products, you'd better post in the corresponding
newsgroups so that they can be resolved in an efficient and timely manner.
You can locate the newsgroup here:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx

When opening a new thread via the web interface, we recommend you check the
"Notify me of replies" box to receive e-mail notifications when there are
any updates in your thread. When responding to posts via your newsreader,
please "Reply to Group" so that others may learn and benefit from your
issue.

Microsoft engineers can only focus on one issue per thread. Although we
provide other information for your reference, we recommend you post
different incidents in different threads to keep the thread clean. In doing
so, it will ensure your issues are resolved in a timely manner.

For urgent issues, you may want to contact Microsoft CSS directly. Please
check http://support.microsoft.com for regional support phone numbers.

Any input or comments in this thread are highly appreciated.

=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
| From:
| Newsgroups: microsoft.public.windows.server.sbs
| Subject: Cannot move Sharepoint database
| Date: 21 Jul 2006 14:34:59 -0700
| Organization: http://groups.google.com
| Lines: 30
| Message-ID:
| NNTP-Posting-Host: 69.183.166.230
| Mime-Version: 1.0
| Content-Type: text/plain; charset="iso-8859-1"
| X-Trace: posting.google.com 1153517704 14257 127.0.0.1 (21 Jul 2006
21:35:04 GMT)
| X-Complaints-To: groups-abuse.DeleteThis@google.com
| NNTP-Posting-Date: Fri, 21 Jul 2006 21:35:04 +0000 (UTC)
| User-Agent: G2/0.2
| X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.2; SV1;
..NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
| Complaints-To: groups-abuse.DeleteThis@google.com
| Injection-Info: s13g2000cwa.googlegroups.com; posting-host=69.183.166.230;
| posting-account=SmaC3w0AAAAdkhZ4C20th-1aoAb-x9x1
| Path:
TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTFEEDS01.phx.gbl!newsfeed00
..sul.t-online.de!t-online.de!border2.nntp.dca.giganews.com!border1.nntp.dca.
giganews.com!nntp.giganews.com!postnews.google.com!s13g2000cwa.googlegroups.
com!not-for-mail
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.windows.server.sbs:283226
| X-Tomcat-NG: microsoft.public.windows.server.sbs
|
| Hi,
| I'm trying to move my Sharepoint data files (following the instructions
| in the "Moving Data Folders for Windows Small Business Server 2003");
| however I ran into the following problem:
|
| Under IIS, for the 3 sharepoint related websites, I only have
| companyweb and Microsoft Sharepoint Administration. I do not have the
| 3rd website mentioned in the article -- Sharepoint Central
| Administration.
|
| I attempted to follow the instructions, nevertheless, and stopped the 2
| websites. When I then tried to detach the data files, I got the
| following:
|
| C:\>osql -E -S MYSERVER\Sharepoint -Q "sp_detach_db 'STS_MYSERVER_1'
| "
| Msg 3701, Level 16, State 1, Server MYSERVER\SHAREPOINT, Line 1
| Cannot detach the database 'STS_MYSERVER_1' because it is currently in
| use.
|
| I don't know how it can be in use as I have closed all relevant
| programs or windows (Server Console, IExplorer, etc). Could it be that
| I do have the Sharepoint Central Administration but it is not a
| website?
|
| Any advice much appreciated.
| Thank you,
|
| Greg
|
|
 >> Stay informed about: Cannot move Sharepoint database 

Hi, Crina Li,
Thank you for your response. I had already tried the OSQL commands and
detach -- just as you list them, but as I said in my original email, I
cannot detach my ''STS_servername_1'' as it says it is in use. This I
assume is related to my missing Sharepoint Central Administration in
IIS.

I am hesitant to reinstall my companyweb. At this point, since
Sharepoint is not taking up that much space, it is not worth the
effort, just so that I can move it. Meanwhile, though, can you tell me
what functionality or features I may be missing by not have the
Sharepoint Central Administration?

Thank you,

Greg
 >> Stay informed about: Cannot move Sharepoint database 

Hi Greg,

Thanks for your update.

Currently, please try to stop the Sharepoint time service and then detach
the database again to see how thing goes. Also please make sure you have
not accessed companyweb related web site on SBS and client computer.

If the issue still occurs, please perform a clean boot on SBS:

1. Click Start, click Run, and then in the Open box, type "MSCONFIG"
(without the quotation marks). Click OK.
2. In the System Configuration Utility (MSConfig) window, click to select
the Selective Startup button.
3. Click to clear the check mark from the "Load startup items" below
Selective Startup.
4. Click the Services tab, click to check the "Hide All Microsoft Services"
box, and remove all the check marks from the remained Non-Microsoft
Services. Please note that the Exchange services could be marked as
non-Microsoft. Please do not disable those services.
5. Click OK to close the MSConfig window. Click Yes when you are asked to
restart your computer in order to enable the changes.
6. After restarting, please check whether this issue will reoccur.

Regarding Sharepoint Central Administration, I can not confirm how you
delete it and it may affect companyweb. Sharepoint Central Administration
is a HTML Administration pages to help you manage your SharePoint web site.
It is created during Windows Sharepoint Services Setup. Please check if you
have the C:\Program Files\Common Files\Microsoft Shared\Web Server
Extensions\60\template\admin\1033 Directory on SBS.

Thanks for your time and I look forward to hearing from you.

Best regards,

Crina Li (MSFT)

Microsoft CSS Online Newsgroup Support

Get Secure! - www.microsoft.com/security

=====================================================
This newsgroup only focuses on SBS technical issues. If you have issues
regarding other Microsoft products, you'd better post in the corresponding
newsgroups so that they can be resolved in an efficient and timely manner.
You can locate the newsgroup here:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx

When opening a new thread via the web interface, we recommend you check the
"Notify me of replies" box to receive e-mail notifications when there are
any updates in your thread. When responding to posts via your newsreader,
please "Reply to Group" so that others may learn and benefit from your
issue.

Microsoft engineers can only focus on one issue per thread. Although we
provide other information for your reference, we recommend you post
different incidents in different threads to keep the thread clean. In doing
so, it will ensure your issues are resolved in a timely manner.

For urgent issues, you may want to contact Microsoft CSS directly. Please
check http://support.microsoft.com for regional support phone numbers.

Any input or comments in this thread are highly appreciated.

=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
| From:
| Newsgroups: microsoft.public.windows.server.sbs
| Subject: Re: Cannot move Sharepoint database
| Date: 29 Jul 2006 13:42:08 -0700
| Organization: http://groups.google.com
| Lines: 17
| Message-ID:
| References:
|
| NNTP-Posting-Host: 69.183.166.230
| Mime-Version: 1.0
| Content-Type: text/plain; charset="iso-8859-1"
| X-Trace: posting.google.com 1154205733 6577 127.0.0.1 (29 Jul 2006
20:42:13 GMT)
| X-Complaints-To: groups-abuse RemoveThis @google.com
| NNTP-Posting-Date: Sat, 29 Jul 2006 20:42:13 +0000 (UTC)
| In-Reply-To:
| User-Agent: G2/0.2
| X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.2; SV1;
NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
| Complaints-To: groups-abuse RemoveThis @google.com
| Injection-Info: h48g2000cwc.googlegroups.com; posting-host=69.183.166.230;
| posting-account=SmaC3w0AAAAdkhZ4C20th-1aoAb-x9x1
| Path:
TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTFEEDS01.phx.gbl!newsfeed.c
w.net!cw.net!news-FFM2.ecrc.de!news.glorb.com!postnews.google.com!h48g2000cw
c.googlegroups.com!not-for-mail
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.windows.server.sbs:285354
| X-Tomcat-NG: microsoft.public.windows.server.sbs
|
| Hi, Crina Li,
| Thank you for your response. I had already tried the OSQL commands and
| detach -- just as you list them, but as I said in my original email, I
| cannot detach my ''STS_servername_1'' as it says it is in use. This I
| assume is related to my missing Sharepoint Central Administration in
| IIS.
|
| I am hesitant to reinstall my companyweb. At this point, since
| Sharepoint is not taking up that much space, it is not worth the
| effort, just so that I can move it. Meanwhile, though, can you tell me
| what functionality or features I may be missing by not have the
| Sharepoint Central Administration?
|
| Thank you,
|
| Greg
|
|
 >> Stay informed about: Cannot move Sharepoint database 

Nice Post.
SharePoint is a product by Microsoft and is used to build up information portals in the company. The portal allows people to connect with the information presented in the organization.
Thanks.
 >> Stay informed about: Cannot move Sharepoint database 

Moving Sharepoint:

Iisreset /stop

Net stop sptimer

osql -E -S %computername%\SharePoint

EXEC sp_detach_db 'STS_Config', 'true' GO EXEC sp_detach_db 'STS_Server_1',
'true' GO Copy database to new partition

EXEC sp_attach_db 'STS_config', 'd:\New_Location\STS_config.mdf',
'd:\New_Location\STS_config_log.LDF' GO EXEC sp_attach_db 'STS_server_1',
'd:\New_Location\STS_server_1.mdf', 'd:\New_Location\STS_Server_1_log.LDF'
GO Net start sptimer

Iisreset /start



<> wrote in message
news: oups.com...
> Hi,
> I'm trying to move my Sharepoint data files (following the instructions
> in the "Moving Data Folders for Windows Small Business Server 2003");
> however I ran into the following problem:
>
> Under IIS, for the 3 sharepoint related websites, I only have
> companyweb and Microsoft Sharepoint Administration. I do not have the
> 3rd website mentioned in the article -- Sharepoint Central
> Administration.
>
> I attempted to follow the instructions, nevertheless, and stopped the 2
> websites. When I then tried to detach the data files, I got the
> following:
>
> C:\>osql -E -S MYSERVER\Sharepoint -Q "sp_detach_db 'STS_MYSERVER_1'
> "
> Msg 3701, Level 16, State 1, Server MYSERVER\SHAREPOINT, Line 1
> Cannot detach the database 'STS_MYSERVER_1' because it is currently in
> use.
>
> I don't know how it can be in use as I have closed all relevant
> programs or windows (Server Console, IExplorer, etc). Could it be that
> I do have the Sharepoint Central Administration but it is not a
> website?
>
> Any advice much appreciated.
> Thank you,
>
> Greg
>
 >> Stay informed about: Cannot move Sharepoint database 

For the SharePoint database we need to move, we need to perform the following actions:
-Right click the database
-Click on Properties
-Select Files from the left hand pane
-Make note of the Path
-Click on Cancel
-Right click again the database
-Select Tasks -> Detach.
 >> Stay informed about: Cannot move Sharepoint database