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

Can not register SERVERNAME\SBSMONITORING. Connection failed.
SERVERNAME changed to real server name.


""Jenny wu [MSFT]"" wrote:

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

Relevant Pages

  • RE: w3wp.exe unable to start properly and mail delivery very slow
    ... I will be here waiting for your updates, please feel free to post back. ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ... |> internal NIC as the DNS server on both client computer and SBS server. ...
    (microsoft.public.windows.server.sbs)
  • Re: Nagging Autorization issue for Companyweb after ISA04 install
    ... Check the companyweb CNAME entry in the DNS Server. ... Does the situation occur when you access companyweb from the ISA ... > 'Microsoft Firewall' service. ... > This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • Re: Email enable doc lib
    ... server to test the issue. ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ... Please try to logon Public folder list using URL: ...
    (microsoft.public.windows.server.sbs)
  • Re: WSUS Problem - Help Needed
    ... You met the following error when using WSUS 3.0 SP1 Server Clean Up Wizard: ... Verify that SQL server is running on the WSUS Server. ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • RE: SQL Server Access
    ... Microsoft CSS Online Newsgroup Support ... | Thread-Topic: SQL Server Access ...
    (microsoft.public.windows.server.sbs)