RE: NOLOCK due to data movement
- From: halsoftware <halsoftware@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 9 Apr 2007 20:34:03 -0700
It is unfortunate that you do not understand that this is an SBS problem.
The default instance of SQL 2005 is working fine. It is the SHAREPOINT
instance that has the problem. I cannot extend or upgrade a virtural server,
the SBS Sharepoint Central Administration has the same type error (601).
This problem occured when the Small Business Server 2003R2 at the SR1 level
was upgraded to SR2. We kinow there have been other problems with the SR2
upgrade, some solved and others in limbo. This problem never occured before
the SR2 upgrade for SBS.
However I will solve this on my own and I thank youi for reply. I do not
expect any more communication on this issue. This issue is closed.
Thank you,
Hal
========================================
"Robert Li [MSFT]" wrote:
Hi,.
Thanks for updating.
Please understanding our newsgroup is mainly focused on SBS support.
Although SQL server is installed on SBS, if SQL server has problem, for
example, the manage console cannot be open, the service cannot be started,
that's recommended to open a new post in microsft.public.sqlserver
newsgroup. Thanks for your understanding.
If you need further assistance, please don't hesitate to let me know.
Best regards,
Robert 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.
--------------------
<Thread-Topic: NOLOCK due to data movement
<thread-index: Acd6uoud7uHCpgVzRPiX9WkTgxMTKQ==
<X-WBNR-Posting-Host: 207.46.199.61
<From: =?Utf-8?B?aGFsc29mdHdhcmU=?= <halsoftware@xxxxxxxxxxxxxxxxxxxxxxxxx>
<References: <8DCB4695-8F85-4E92-AE6B-9F816C100DB7@xxxxxxxxxxxxx>
<OPtPDDpeHHA.4368@xxxxxxxxxxxxxxxxxxxxxx>
<Subject: RE: NOLOCK due to data movement
<Date: Mon, 9 Apr 2007 08:20:02 -0700
<Lines: 187
<Message-ID: <6E0A2374-5EEF-40EA-B8BF-78EA3836B625@xxxxxxxxxxxxx>
<MIME-Version: 1.0
<Content-Type: text/plain;
< charset="Utf-8"
<Content-Transfer-Encoding: 7bit
<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.2757
<Newsgroups: microsoft.public.windows.server.sbs
<Path: TK2MSFTNGHUB02.phx.gbl
<Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.windows.server.sbs:28570
<NNTP-Posting-Host: tk2msftsbfm01.phx.gbl 10.40.244.148
<X-Tomcat-NG: microsoft.public.windows.server.sbs
<
<How can this only be an SQL issue when this is an SBS2003R2 Premium SP2.
<This issue occured in SQL and Sharepoint 2.0 only after downloading SP2
for
<the Small Bussiness Server. All these services are in one box. This is
not
<a stand-alone SQL. This occured after downloading the SBS SP2. The issue
<was not there before. Please take another look.
<Thank you.
<
<"Robert Li [MSFT]" wrote:
<
<> Hi,
<>
<> Thanks for posting in our newsgroup.
<>
<> I am sorry for the delay response due to the weekend.
<>
<> From your description, I know that after you applied update KB 934458,
SQL
<> Server Database Services 2005 (SHAREPOINT) failed.The error is
<> "System.Data.SqlClient.SqlException: Could not continue scan with NOLOCK
<> due to data movement" If I am off-base, please don't hesitate to let me
<> know.
<>
<> I am sorry the issue is a pure SQL problem, our newsgroup doesn't
provide
<> technical support for this kind. Please open a new post in our
<> Microsoft.public.sqlserver newsgroup.Thanks for your understanding.
<>
<> If you have any question, please don't hesitate to let me know.
<>
<> Best regards,
<>
<> Robert 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.
<>
<> --------------------
<> <Thread-Topic: NOLOCK due to data movement
<> <thread-index: Acd6HB+tZuSDdcniT9i7799k9uBr4A==
<> <X-WBNR-Posting-Host: 207.46.198.15
<> <From: =?Utf-8?B?aGFsc29mdHdhcmU=?=
<halsoftware@xxxxxxxxxxxxxxxxxxxxxxxxx>
<> <Subject: NOLOCK due to data movement
<> <Date: Sun, 8 Apr 2007 13:26:01 -0700
<> <Lines: 83
<> <Message-ID: <8DCB4695-8F85-4E92-AE6B-9F816C100DB7@xxxxxxxxxxxxx>
<> <MIME-Version: 1.0
<> <Content-Type: text/plain;
<> < charset="Utf-8"
<> <Content-Transfer-Encoding: 7bit
<> <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.2757
<> <Newsgroups: microsoft.public.windows.server.sbs
<> <Path: TK2MSFTNGHUB02.phx.gbl
<> <Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.windows.server.sbs:28465
<> <NNTP-Posting-Host: tk2msftsbfm01.phx.gbl 10.40.244.148
<> <X-Tomcat-NG: microsoft.public.windows.server.sbs
<> <
<> <After SP2 - WSUS downloaded KB934458. Of the three parts updated, SQL
<> <Server Database Services 2005 (SHAREPOINT) failed.
<> <The basic premis of the error is "System.Data.SqlClient.SqlException:
<> Could
<> <not continue scan with NOLOCK due to data movement"
<> <The NOLOCK due to data momement is now showing up elswhere in SQL and
<> <SHAREPOINT.
<> <Cannot find any reference or solution to this particular error. The
<> <following is the Summary text from the KB934458 install.
<> <Any help would be appreciated. Has any one else run into this or am i
the
<> <only one?
<> <=====================================Summary.txt
<> <Time: 04/08/2007 04:38:03.518
<> <KB Number: KB934458
<> <Machine: SB2003SERVER
<> <OS Version: Microsoft Windows Server 2003 family, Service Pack 2 (Build
<> 3790)
<> <Package Language: 1033 (ENU)
<> <Package Platform: x86
<> <Package SP Level: 2
<> <Package Version: 3054
<> <Command-line parameters specified:
<> <Cluster Installation: No
<> <
<>
****************************************************************************
<> ******
<> <Prerequisites Check & Status
<> <SQLSupport: Passed
<> <
<>
****************************************************************************
<> ******
<> <Products Detected Language Level Patch Level
<>
<> <Platform Edition
<> <SQL Server Database Services 2005 (SHAREPOINT) ENU SP2
<> <2005.090.3054.00 x86 WORKGROUP
<> <SQL Server Reporting Services 2005 (SHAREPOINT) ENU SP2
<> <9.00.3054.00 x86 WORKGROUP
<> <SQL Server Tools and Workstation Components 2005 ENU SP2
<> <9.2.3054 x86 WORKGROUP
<> <
<>
****************************************************************************
<> ******
<> <Products Disqualified & Reason
<> <Product Reason
<> <
<>
****************************************************************************
<> ******
<> <Processes Locking Files
<> <Process Name Feature Type User Name
<>
<> < PID
<> <
<>
****************************************************************************
<> ******
<> <Product Installation Status
<> <Product : SQL Server Database Services 2005
(SHAREPOINT)
<> <Product Version (Previous): 3054
<> <Product Version (Final) :
<> <Status : Failure
<> <Log File : C:\Program Files\Microsoft SQL
Server\90\Setup
<> <Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB934458_sqlrun_sql.msp.log
<> <Error Number : 29537
<> <Error Description : MSP Error: 29537 SQL Server Setup has
<> <encountered the following problem: [Microsoft][SQL Native Client][SQL
<> <Server]Could not continue scan with NOLOCK due to data movement.. To
<> <continue, correct the problem, and then run SQL Server Setup again.
<>
----------------------------------------------------------------------------
<> ------
<> <Product : SQL Server Reporting Services 2005
(SHAREPOINT)
<> <Product Version (Previous): 3054
<> <Product Version (Final) : 3054
<> <Status : Success
<> <Log File : C:\Program Files\Microsoft SQL
Server\90\Setup
<> <Bootstrap\LOG\Hotfix\RS9_Hotfix_KB934458_sqlrun_rs.msp.log
<> <Error Number : 0
<> <Error Description :
<>
----------------------------------------------------------------------------
<> ------
<> <Product : SQL Server Tools and Workstation Components
<> 2005
<> <Product Version (Previous): 3054
<> <Product Version (Final) :
<> <Status : Not Selected
<> <Log File :
<> <Error Description :
<>
----------------------------------------------------------------------------
<> ------
<> <
<>
****************************************************************************
<> ******
<> <Summary
<> < One or more products failed to install, see above for details
<> < Exit Code Returned: 29537
<> <
<> <
<> <
<> <
<>
<>
<
- Follow-Ups:
- RE: NOLOCK due to data movement
- From: Robert Li [MSFT]
- RE: NOLOCK due to data movement
- References:
- NOLOCK due to data movement
- From: halsoftware
- RE: NOLOCK due to data movement
- From: Robert Li [MSFT]
- RE: NOLOCK due to data movement
- From: halsoftware
- RE: NOLOCK due to data movement
- From: Robert Li [MSFT]
- NOLOCK due to data movement
- Prev by Date: Re: NT Backup Fails to External HD - Insufficient Disk Space
- Next by Date: Re: Advice please
- Previous by thread: RE: NOLOCK due to data movement
- Next by thread: RE: NOLOCK due to data movement
- Index(es):
Relevant Pages
|
