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

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: upgrade sharepoint database to SQLserver - connect error
    ... 2005 database after he move the sharepoint data from MSDE to SQL 2005. ... This newsgroup is primarily for issues involving deployment, configuration, ... | I am trying to move my SharePoint data bases from MSDE to the Sql Server. ...
    (microsoft.public.windows.server.sbs)
  • Re: cant move sharepoint by the instructions.
    ... What is your meaning of "don't know why they SQL directory is one gig in ... Have you reinstalled sharepoint service and MSDE already? ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • RE: SQl Server after upgrade
    ... Open SQL Query Analyzer. ... Microsoft CSS Online Newsgroup Support ... you may want to contact Microsoft CSS directly. ...
    (microsoft.public.windows.server.sbs)
  • Re: The Web site that is referenced here is not in the configuration database.
    ... And please double check if you have configured scheduled tasks on the SQL ... You can also post the question in our WSS newsgroup or SQL server newsgroup ... you may want to contact Microsoft CSS directly. ...
    (microsoft.public.windows.server.sbs)
  • Re: I broke Sharepoint :(
    ... Now you don't have MSSQL$SHAREPOINT and SQL instance, ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
Loading