Re: can't move sharepoint by the instructions. AGAIN

Hi Brian,

Thanks for your update. I appreciate your time.

For the MSSQL$SBSMONITORING folder is too big, you should move the
Monitoring database to another location. You can refer to the Microsoft
white paper to process it. The procedure is very similar with that moving
Sharepoint database.

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

Besides I would like to introduce a solution to configure the SBSMonitoring
Database clean up job to decrease the monitoring database volume.

I. If you installed the SQL Server or the SQL Server Management Tools, to
configure the SBSMonitoring Database clean up job, please perform the below
steps:

1. Start SQL Enterprise Manager on the SBS Server

2. Expand Microsoft SQL Servers -> SQL Server Group

3. If you did not find the "YourServerName\SBSMONITORING (Windows NT)"
instance is listed, please use the following steps to add it.

a. Right click on the SQL Server Group and select New SQL Server
Registration
b. On the available server, please DO NOT choose local server. You should
manually input SERVERNAME\INSTANCENAME, i.e. SERVERNAME\SBSMONITORING
c. Follow the wizard and finish settings.

4. Then, expand YourServerName\SBSMONITORING (Windows NT) -> Management ->
SQL Server Agent -> Jobs

5. There should be a job named with SBS_Database_Cleanup

6. Double click to open it

7. Click Schedules tab, you can change the schedule time.

8. Click OK.

9. Run the 'Services.msc' on the command prompt, then restart the
SQLAgent$SBSMonitoring service.

II. If you don't install the SQL Server or the SQL Server Management Tools,
we may use the below command line to run the SBS_Database_Cleanup job or
update the job's schedule:

1. To run the SBS_Database_Cleanup job:

sp_start_job
http://msdn.microsoft.com/library/en-us/tsqlref/ts_sp_sa-sz_11uq.asp

2. To update the job's schedule:

sp_update_jobschedule
http://msdn.microsoft.com/library/en-us/tsqlref/ts_sp_ua-uz_9het.asp

I am appreciated your time and cooperation. If anything is unclear, please
feel free to let me know. I am looking forward to hearing from you.

Have a nice day!

Sincerely,

Jenny Wu
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.

--------------------
>Thread-Topic: can't move sharepoint by the instructions. AGAIN
>thread-index: AcXq+7RSgUL/IOFIRni2+tQhIdgTsg==
>X-WBNR-Posting-Host: 72.11.91.140
>From: =?Utf-8?B?QnJpYW5NdWx0aUxhbmd1YWdl?=
<BrianMultiLanguage@xxxxxxxxxxxxxxxxxxxxxxxxx>
>References: <4CC70980-C3A8-48B8-9830-772791294E45@xxxxxxxxxxxxx>
<lPS5zCp5FHA.2672@xxxxxxxxxxxxxxxxxxxxx>
<9A0C1237-3FF4-4F71-9463-E4D647D664DC@xxxxxxxxxxxxx>
<#mX00U45FHA.2560@xxxxxxxxxxxxxxxxxxxx>
<532DF108-37DA-45FC-B5FC-7945EA8983D9@xxxxxxxxxxxxx>
<a0UrUnb6FHA.832@xxxxxxxxxxxxxxxxxxxxx>
<FF84EBDB-20A2-4A3F-83A5-5110EC0E0232@xxxxxxxxxxxxx>
<OBUqwuq6FHA.392@xxxxxxxxxxxxxxxxxxxxx>
>Subject: Re: can't move sharepoint by the instructions. AGAIN
>Date: Wed, 16 Nov 2005 14:18:43 -0800
>Lines: 305
>Message-ID: <D51F5CCF-8F25-4EE4-A825-5270C7FCA1B9@xxxxxxxxxxxxx>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 8bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.windows.server.sbs
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.windows.server.sbs:222985
>X-Tomcat-NG: microsoft.public.windows.server.sbs
>
>C:\Program Files\Microsoft SQL Server\MSSQL$SBSMONITORING
>This directory takes up 1.13gigs.
>
>""Jenny wu [MSFT]"" wrote:
>
>> Hi Brian,
>>
>> Thanks for your update!
>>
>> What is your meaning of "don't know why they SQL directory is one gig in
>> size "? Do you mean the MSSQL$SHAREPOINT folder (C:\Program
Files\Microsoft
>> SQL Server\MSSQL$SHAREPOINT) is so big although you have not such volume
of
>> Sharepoint database?
>>
>> If that so, please take a look at the following articles to try to
shrink
>> the Transaction Log:
>>
>> INF: How to Shrink the SQL Server 7.0 Transaction Log
>> http://support.microsoft.com/kb/256650/EN-US/
>>
>> Note: the article can also apply to SQL server 2000.
>>
>> INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC
SHRINKFILE
>> http://support.microsoft.com/kb/272318/EN-US/
>>
>> Have you reinstalled sharepoint service and MSDE already? Please let me
>> know the result.
>>
>> I appreciate your time! I am happy to be assistance of you and look
forward
>> to your update!
>>
>> Have a nice day!
>>
>> Sincerely,
>>
>> Jenny Wu
>> 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.
>>
>> --------------------
>> >Thread-Topic: can't move sharepoint by the instructions.
>> >thread-index: AcXqPVaijx0fXmQNSLKfuEWRVVop+A==
>> >X-WBNR-Posting-Host: 72.11.91.140
>> >From: =?Utf-8?B?QnJpYW5NdWx0aUxhbmd1YWdl?=
>> <BrianMultiLanguage@xxxxxxxxxxxxxxxxxxxxxxxxx>
>> >References: <4CC70980-C3A8-48B8-9830-772791294E45@xxxxxxxxxxxxx>
>> <lPS5zCp5FHA.2672@xxxxxxxxxxxxxxxxxxxxx>
>> <9A0C1237-3FF4-4F71-9463-E4D647D664DC@xxxxxxxxxxxxx>
>> <#mX00U45FHA.2560@xxxxxxxxxxxxxxxxxxxx>
>> <532DF108-37DA-45FC-B5FC-7945EA8983D9@xxxxxxxxxxxxx>
>> <a0UrUnb6FHA.832@xxxxxxxxxxxxxxxxxxxxx>
>> >Subject: Re: can't move sharepoint by the instructions.
>> >Date: Tue, 15 Nov 2005 15:36:02 -0800
>> >Lines: 310
>> >Message-ID: <FF84EBDB-20A2-4A3F-83A5-5110EC0E0232@xxxxxxxxxxxxx>
>> >MIME-Version: 1.0
>> >Content-Type: text/plain;
>> > charset="Utf-8"
>> >Content-Transfer-Encoding: 8bit
>> >X-Newsreader: Microsoft CDO for Windows 2000
>> >Content-Class: urn:content-classes:message
>> >Importance: normal
>> >Priority: normal
>> >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>> >Newsgroups: microsoft.public.windows.server.sbs
>> >NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>> >Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
>> >Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.windows.server.sbs:222590
>> >X-Tomcat-NG: microsoft.public.windows.server.sbs
>> >
>> >Thanks to all.
>> >I restored the files from backup to the original location.
>> >I still don't know why they SQL directory is one gig in size.
>> >Given the small data size of sharepoint and its frailty, we just
>> >uninstall/reinstall Sharepoint and SQL.
>> >
>> >
>> >
>> >""Jenny wu [MSFT]"" wrote:
>> >
>> >> Hi Brian,
>> >>
>> >> Thanks for your update! For your information, I understand that now
>> >> situation is that when you try to re-attach sharepoint database, you
got
>> >> error.
>> >>
>> >> Based on my experience, this issue may occur if:
>> >>
>> >> 1) The file is actually get corrupted during the transition.
>> >> 2) The source file is corrupted somehow.
>> >> 3) Disk cluster defect.
>> >> 4) SQL Server startup account doesn't have necessary permission to
write
>> to
>> >> the drive, as a result, it cannot create tempdb.
>> >>
>> >> Please let me know if you have moved the Sharepoint database to
another
>> >> drive according to previous post successfully.
>> >>
>> >> Also, please make sure that the account which is used to startup SQL
>> Server
>> >> service has write permission on the both partitions. By default, the
>> >> SQLAgent$Sharepoint service is started by Local System account, so
>> please
>> >> make sure that the System account has Full Control permission on both
>> >> Partitions.
>> >>
>> >> And also please use CHKDSK to check both Partitions and then try it
>> again
>> >> (detach the database, move and attach it again) to see if there is an
>> >> update.
>> >>
>> >> If you still can not re-attach sharepont database, please refer to
the
>> >> following article to recovery your Sharepoint services. I suggest you
>> >> strictly follow guide to process it:
>> >>
>> >> 827701 How to perform a disaster recovery operation of SharePoint
>> Services
>> >> http://support.microsoft.com/?id=827701
>> >>
>> >> I appreciate your time. I am happy to be assistance of you and look
>> forward
>> >> to your update!
>> >>
>> >> Have a nice day!
>> >>
>> >> Sincerely,
>> >>
>> >> Jenny Wu
>> >> 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
>> >>
>> >> --------------------
>> >> >Thread-Topic: can't move sharepoint by the instructions.
>> >> >thread-index: AcXpRhRXUVGc+nkQTi+9WppR3qyoSQ==
>> >> >X-WBNR-Posting-Host: 72.11.91.140
>> >> >From: =?Utf-8?B?QnJpYW5NdWx0aUxhbmd1YWdl?=
>> >> <BrianMultiLanguage@xxxxxxxxxxxxxxxxxxxxxxxxx>
>> >> >References: <4CC70980-C3A8-48B8-9830-772791294E45@xxxxxxxxxxxxx>
>> >> <lPS5zCp5FHA.2672@xxxxxxxxxxxxxxxxxxxxx>
>> >> <9A0C1237-3FF4-4F71-9463-E4D647D664DC@xxxxxxxxxxxxx>
>> >> <#mX00U45FHA.2560@xxxxxxxxxxxxxxxxxxxx>
>> >> >Subject: Re: can't move sharepoint by the instructions.
>> >> >Date: Mon, 14 Nov 2005 10:06:04 -0800
>> >> >Lines: 227
>> >> >Message-ID: <532DF108-37DA-45FC-B5FC-7945EA8983D9@xxxxxxxxxxxxx>
>> >> >MIME-Version: 1.0
>> >> >Content-Type: text/plain;
>> >> > charset="Utf-8"
>> >> >Content-Transfer-Encoding: 8bit
>> >> >X-Newsreader: Microsoft CDO for Windows 2000
>> >> >Content-Class: urn:content-classes:message
>> >> >Importance: normal
>> >> >Priority: normal
>> >> >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>> >> >Newsgroups: microsoft.public.windows.server.sbs
>> >> >NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>> >> >Path:
TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl
>> >> >Xref: TK2MSFTNGXA02.phx.gbl
microsoft.public.windows.server.sbs:222134
>> >> >X-Tomcat-NG: microsoft.public.windows.server.sbs
>> >> >
>> >> >Here's the error when I try to reattach at the original location
where
>> all
>> >> >the files still are.
>> >> >2> go
>> >> >Msg 5105, Level 16, State 2, Server CLISBS\SHAREPOINT, Line 1
>> >> >Device activation error. The physical file name ' C:\Program
Files\Micr
>> >> >SQL Server\MSSQL$SHAREPOINT\Data\STS_Config_log.ldf' may be
incorrect.
>> >> >
>> >> >"Kathy" wrote:
>> >> >
>> >> >> Are you sure you typed the OSQL line in order to get the OSQL
command
>> >> prompt
>> >> >> (as these aren't DOS commands, but you quoted a DOS error
message)
>> >> before
>> >> >> entering the sp_attach_db line?
>> >> >>
>> >> >> Kathy
>> >> >>
>> >> >> "BrianMultiLanguage"
<BrianMultiLanguage@xxxxxxxxxxxxxxxxxxxxxxxxx>
>> >> wrote in
>> >> >> message news:9A0C1237-3FF4-4F71-9463-E4D647D664DC@xxxxxxxxxxxxxxxx
>> >> >> > Since these DOS commands aren't reliably working, why not just
back
>> up
>> >> the
>> >> >> > whole directory of C:\Program Files\Microsoft SQL Server,
uninstall
>> all
>> >> >> sql,
>> >> >> > reinstall the SQL in the new location, restore the data from
backup.
>> >> >> > ?
>> >> >> >
>> >> >> > ""Jenny wu [MSFT]"" wrote:
>> >> >> >
>> >> >> > > Hi Brian,
>> >> >> > >
>> >> >> > > Thanks for posting here! I am Jenny, I have answered your
>> question on
>> >> >> > > another thread. Please try to run the command as follows:
>> >> >> > >
>> >> >> > > OSQL -E -S CLISBS\sharepoint <Enter>
>> >> >> > > > sp_detach_db "STS_Config" <Enter>
>> >> >> > > > exit <Enter>
>> >> >> > >
>> >> >> > > How about the result?
>> >> >> > >
>> >> >> > > For your convenience, I list the steps as blow, please
strictly
>> >> follow
>> >> >> to
>> >> >> > > test:
>> >> >> > >
>> >> >> > > IÃ?â??Ã?£Ã?â??Ã?® To stop the Internet Information Services
(IIS) Web
>> sites for
>> >> >> Windows
>> >> >> > > SharePoint Services
>> >> >> > >
>> >> >> > > To prevent users from accessing SharePoint sites while you are
>> moving
>> >> >> the
>> >> >> > > databases, stop the related IIS Web sites. If you have created
>> >> >> additional
>> >> >> > > SharePoint sites, you should stop those Web sites as well.
>> >> >> > >
>> >> >> > > II. To verify that the SharePoint instance of WMSDE is running
>> >> >> > >
>> >> >> > > III. To connect to the SharePoint instance of WMSDE (MSDE) and
>> detach
>> >> >> > > detach the WSS config and config databases (Replace
"servername"
>> with
>> >> >> the
>> >> >> > > name of your server):
>> >> >> > > Before moving the SharePoint instance of WMSDE, you must
connect
>> to
>> >> the
>> >> >> > > instance and detach the two databases used by the instance.
>> >> >> > >
>> >> >> > > Bring up a command console, and then run:
>> >> >> > >
>> >> >> > > OSQL -E -S servername\sharepoint <Enter>
>> >> >> > > > sp_detach_db "STS_Config" <Enter>
>> >> >> > > > go <Enter>
>> >> >> > > > sp_detach_db "STS_servername_1" <Enter>
>> >> >> > > > go <Enter>
>> >> >> > >
>> >> >> > > *Note: Please replace servername of STS_servername_1 with the
>> name of
>> >> >> your
>> >> >> > > server!
>> >> >> > >
>> >> >> > > IV. In Windows Explorer, move all the databases (*.mdf, *.ldf)
to
>> the
>

.

Relevant Pages

  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Move the monitoring database
    ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ... | Thread-Topic: Move the monitoring database ... | for Windows Small Business Server 2003" document only specifies moving ...
    (microsoft.public.windows.server.sbs)
  • Re: SBS setup fails
    ... done I'll attempt the database reinstall and report back. ... | Subject: Re: SBS setup fails ... | Microsoft CSS Online Newsgroup Support ... | This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • Re: Backup still not working
    ... So you may try to rebuild the RSM database if the ... > rename the existing files in this folder to a .old file extension, ... > this time unchecks "First Storage Group" under Microsoft Exchange Server. ... > 1) Open SQL Server Enterprise Manager. ...
    (microsoft.public.windows.server.sbs)
  • RE: Scecli and jet database event 1005 and 1202 repeating
    ... This issue occurs if the local Group Policy database file is corrupt. ... Microsoft CSS Online Newsgroup Support ... Open the %SystemRoot%\Security folder, create a new folder, and then ...
    (microsoft.public.windows.server.sbs)