Re: Sharepoint Database falling over event 1000

Colin,

If you are still getting the following error after a reboot, then we need to
explore into finding out what process is creating an open handle to the file
prior to the mssql$sharepoint service.

2005-08-25 21:12:30.07 spid55 udopen: Operating system error 32(The
process cannot access the file because it is being used by another process.)
during the creation/opening of physical device
D:\Data\MSDEDatabases\SharePoint\STS_SIVA01_1.mdf.

If you stop the mssql$sharepoint service and attempt to rename the
sts_siva01_1.mdf I would expect that you would get a file in use type error
message. (which shouldn't be the case)

Couple of options
1) Try stopping any/all non-essential services (may want to disconnect from
the Internet while doing this) and then attempt the file rename again to see
if you get the file in use error. Be sure that if you are able to rename it
that you rename it back, then start the mssql$sharepoint instance and then
check the errorlog.
2) Use a 3rd party utility that would allow you to see the process (process
id) that has an open file handle to that file. Then if possible stop/disable
that application/service and verify that there are no longer any open file
handles to that file, then start the mssql$sharepoint service.

--

Hope that helps,
David Copeland
Microsoft Small Business Server Support

This posting is provided "AS IS" with no warranties, and confers no rights.


SBS Newsgroups:

SBS v4.x: microsoft.public.backoffice.smallbiz
SBS 2000: microsoft.public.backoffice.smallbiz2000
SBS 2003: microsoft.public.windows.server.sbs

"Colin Coleman" <colin@xxxxxxxxxxx> wrote in message
news:OkGxoCoqFHA.528@xxxxxxxxxxxxxxxxxxxxxxx
> Hi David,
>
> I Have Just run the SQL command from the command Line, and it seems to run
> ok , i guess as it produced
> a few lines of directory paths and finished with the line (8 lines
> affected)
>
> Microsoft Windows [Version 5.2.3790]
> (C) Copyright 1985-2003 Microsoft Corp.
>
> C:\Documents and Settings\Administrator>osql -E -S
> %Computername%\sharepoint
> 1> select name, filename from sysdatabases
> 2> go
> name filename
> -------------------------------------------------------------------------------master
> C:\Program Files\Microsoft SQLServer\MSSQL$SHAREPOINT\Data\master.mdfmodel
> C:\Program Files\Microsoft SQLServer\MSSQL$SHAREPOINT\Data\model.mdfmsdb
> C:\Program Files\Microsoft
> SQLServer\MSSQL$SHAREPOINT\Data\MSDBData.mdfSTS_Config
> D:\Data\MSDEDatabases\SharePoint\STS_Config.mdfSTS_OEMSBSCN-3158_1
> C:\Program Files\Microsoft
> SQLServer\MSSQL$SHAREPOINT\Data\STS_OEMSBSCN-3158_1.mdfSTS_SIVA01
> D:\Data\MSDEDatabases\SharePoint\STS_SIVA01_1.mdfSTS_SIVA01_1
> D:\Data\MSDEDatabases\SharePoint\STS_SIVA01_1.mdftempdb C:\Program
> Files\Microsoft SQLServer\MSSQL$SHAREPOINT\Data\tempdb.mdf(8 rows
> affected)1> exitDoes this say the database is Ok?If so why since we loaded
> the last block of 8 patches and Namely "Criticalupdate for SQL Server 2000
> Desktop Engine (Windows) on Windows Server 2003"patch does it now fail
> ?Yes i have restarted the server 3 times now, much to the annoyance of
> the24/7 factory connected to the other end of it....:-)Thanks for the
> helpColin"David Copeland [MSFT]" <davidcop@xxxxxxxxxxxxxxxxxxxx> wrote in
> messagenews:O9KM9hnqFHA.4012@xxxxxxxxxxxxxxxxxxxxxxx> Colin,>> Based on
> the error you received in the mssql$sharepoint\log\errorlog itlooks like
> something else has it open.. Did you reboot the server? orrestart just
> the mssql$sharepoint service?>> The osql command I provided earlier you
> should be able to simply copypaste it into a command prompt to run it..
> Another way of doing it would beto do the following from a command prompt
> on the server>> osql -E -S %computername%\sharepoint>> select name,
> filename from sysdatabases>> go>> exit>> Basically, we need to verify that
> is the correct path to the database..and that it exists.. and then
> possibly use a utility to show the openhandles to that file if the
> database is still in use after a reboot.>> Yes, the logical database name
> as far as WMSDE/SQL is concerned issts_siva01_1, but the physical file
> name is> D:\Data\MSDEDatabases\SharePoint\STS_SIVA01_1.mdf> There should
> also be a D:\Data\MSDEDatabases\SharePoint\STS_SIVA01_1.ldf(by default)
> which is the log file for that database.>>> -->> Hope that helps,> David
> Copeland> Microsoft Small Business Server Support>> This posting is
> provided "AS IS" with no warranties, and confers norights.>>> SBS
> Newsgroups:>> SBS v4.x: microsoft.public.backoffice.smallbiz> SBS 2000:
> microsoft.public.backoffice.smallbiz2000> SBS 2003:
> microsoft.public.windows.server.sbs>>>>> "Colin Coleman"
> <colin@xxxxxxxxxxx> wrote in
> messagenews:uuOv8CmqFHA.3424@xxxxxxxxxxxxxxxxxxxxxxx>> Checked the McAfee
> Antvirus, It Has Now Been Excluded from Scanning theParent Folder and All
> Sub Folders,>> Restarted Sharepoint Services,>> Restarted Sharepoint
> Timer>>>> Opened Companyweb......Crash still same single line showing>>>>
> and the Application log still adds>> Event 1000, Category None, Type
> Error, User N/A Source Windows SharepointService>> #50070: Unable to
> connect to the datbase STS_siva01_1 on>> SIVA01\sharepoint. Check the
> database connection information and make>> sure that the database server
> is running.>>>> Could the database Be Corrupt?>> How Can i check it ?>> Is
> the Database D:\Data\MSDEDatabases\SharePoint\STS_SIVA01_1.mdf. ?>> What
> is the correct text for osql -E -S %computername%\sharepoint -Q"select
> name, filename from sysdatabases" ?>>>> Best Regards>>>> Colin>>>>>>>>>>
> "Default User" <anonymous@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
> messagenews:ucApyulqFHA.240@xxxxxxxxxxxxxxxxxxxxxxx>>> Colin,>>>>>> Based
> on>>>>>> 2005-08-25 21:12:30.07 spid55 udopen: Operating system error
> 32(The>>> process cannot access the file because it is being used by
> anotherprocess.)>>> during the creation/opening of physical device>>>
> D:\Data\MSDEDatabases\SharePoint\STS_SIVA01_1.mdf.>>> 2005-08-25
> 21:12:30.09 spid55 FCB::Open failed: Could not open device>>>
> D:\Data\MSDEDatabases\SharePoint\STS_SIVA01_1.mdf for virtual
> devicenumber>>> (VDN) 1.>>>>>> It looks like something else already has
> that file open (at least whenthe SharePoint instance attempted to start).
> You might try simplyrestarting the MSSQL$SharePoint service (make sure no
> one is usingCompanyweb or any WSS site on the server first) and then check
> the log tosee if you still get the same error.>>> If you do, then at that
> point you could try rebooting the server to seeif it is about to open it
> then..>>>>>> Do you have any AV software that may be scanning that
> directory? OpenFile Agent type software?>>>>>>>>> -->>>>>> Hope that
> helps,>>> David Copeland>>> Microsoft Small Business Server Support>>>>>>
> This posting is provided "AS IS" with no warranties, and confers
> norights.>>>>>>>>> SBS Newsgroups:>>>>>> SBS v4.x:
> microsoft.public.backoffice.smallbiz>>> SBS 2000:
> microsoft.public.backoffice.smallbiz2000>>> SBS 2003:
> microsoft.public.windows.server.sbs>>>>>>>>>>>> "Colin Coleman"
> <colin@xxxxxxxxxxx> wrote in
> messagenews:eskjQClqFHA.3180@xxxxxxxxxxxxxxxxxxxxxxx>>>> Hi David,>>>>>>>>
> Thanks for the reply, i have looked into the log files and have copiedthe
> most recent one, if this helps diagnose what has happened.>>>> THE
> LOGFILE>>>>>>>> 2005-08-25 20:56:56.40 server Microsoft SQL Server
> 2000 - 8.00.884(Intel X86)>>>> Nov 29 2003 20:52:47>>>> Copyright (c)
> 1988-2003 Microsoft Corporation>>>> Desktop Engine (Windows) on Windows NT
> 5.2 (Build 3790: )>>>>>>>> 2005-08-25 20:56:56.40 server Copyright (C)
> 1988-2002 MicrosoftCorporation.>>>> 2005-08-25 20:56:56.40 server All
> rights reserved.>>>> 2005-08-25 20:56:56.40 server Server Process ID is
> 2424.>>>> 2005-08-25 20:56:56.40 server Logging SQL Server messages in
> file'C:\Program Files\Microsoft SQL
> Server\MSSQL$SHAREPOINT\LOG\ERRORLOG'.>>>> 2005-08-25 20:56:56.42 server
> SQL Server is starting at priorityclass 'normal'(2 CPUs detected).>>>>
> 2005-08-25 20:56:58.06 server SQL Server configured for thread
> modeprocessing.>>>> 2005-08-25 20:56:58.06 server Using dynamic lock
> allocation. [500]Lock Blocks, [1000] Lock Owner Blocks.>>>> 2005-08-25
> 20:56:58.85 spid4 Starting up database 'master'.>>>> 2005-08-25
> 20:56:59.32 spid4 Server name is 'SIVA01\SHAREPOINT'.>>>> 2005-08-25
> 20:56:59.32 spid4 Skipping startup of clean database id4>>>>
> 2005-08-25 20:56:59.32 spid4 Skipping startup of clean database
> id5>>>> 2005-08-25 20:56:59.32 spid4 Skipping startup of clean
> database id6>>>> 2005-08-25 20:56:59.32 spid4 Skipping startup of
> clean database id7>>>> 2005-08-25 20:56:59.32 spid4 Skipping startup
> of clean database id8>>>> 2005-08-25 20:56:59.35 server Using
> 'SSNETLIB.DLL' version'8.0.880'.>>>> 2005-08-25 20:56:59.35 spid5
> Starting up database 'model'.>>>> 2005-08-25 20:56:59.39 server SQL
> server listening on Shared Memory.>>>> 2005-08-25 20:56:59.39 server
> SQL Server is ready for clientconnections>>>> 2005-08-25 20:56:59.78 spid5
> Clearing tempdb database.>>>> 2005-08-25 20:57:02.15 spid5 Starting up
> database 'tempdb'.>>>> 2005-08-25 20:57:02.25 spid4 Recovery
> complete.>>>> 2005-08-25 20:57:03.73 spid4 SQL global counter
> collection task iscreated.>>>> 2005-08-25 20:57:09.40 spid51 Starting
> up database 'STS_Config'.>>>> 2005-08-25 21:00:38.42 spid52 Starting up
> database 'STS_SIVA01_1'.>>>> 2005-08-25 21:12:30.07 spid55 Starting up
> database 'STS_SIVA01'.>>>> 2005-08-25 21:12:30.07 spid53 Starting up
> database'STS_OEMSBSCN-3158_1'.>>>> 2005-08-25 21:12:30.07 spid55
> udopen: Operating system error 32(Theprocess cannot access the file
> because it is being used by another process.)during the creation/opening
> of physical deviceD:\Data\MSDEDatabases\SharePoint\STS_SIVA01_1.mdf.>>>>
> 2005-08-25 21:12:30.09 spid55 FCB::Open failed: Could not opendevice
> D:\Data\MSDEDatabases\SharePoint\STS_SIVA01_1.mdf for virtual devicenumber
> (VDN) 1.>>>> 2005-08-25 21:12:30.12 spid56 Starting up database
> 'msdb'.>>>> 2005-08-25 21:12:30.17 backup BACKUP failed to complete the
> commandBACKUP DATABASE [STS_SIVA01]
> TOVIRTUAL_DEVICE='{E78EA9E3-1F8C-450A-A134-FA1E7902D9B9}6'
> WITHSNAPSHOT,BUFFERCOUNT=1,BLOCKSIZE=1024>>>> 2005-08-25 21:12:31.32
> spid51 BackupVirtualDeviceFile::PrepareToFreeze:failure on backup device
> '{E78EA9E3-1F8C-450A-A134-FA1E7902D9B9}1'.Operating system error 995(The
> I/O operation has been aborted because ofeither a thread exit or an
> application request.).>>>> 2005-08-25 21:12:31.32 backup BACKUP failed
> to complete the commandBACKUP DATABASE [master]
> TOVIRTUAL_DEVICE='{E78EA9E3-1F8C-450A-A134-FA1E7902D9B9}1'
> WITHSNAPSHOT,BUFFERCOUNT=1,BLOCKSIZE=1024>>>> 2005-08-25 21:12:31.34
> spid52 BackupVirtualDeviceFile::ClearError:failure on backup device
> '{E78EA9E3-1F8C-450A-A134-FA1E7902D9B9}2'.Operating system error 995(The
> I/O operation has been aborted because ofeither a thread exit or an
> application request.).>>>> 2005-08-25 21:12:31.34 backup BACKUP failed
> to complete the commandBACKUP DATABASE [model]
> TOVIRTUAL_DEVICE='{E78EA9E3-1F8C-450A-A134-FA1E7902D9B9}2'
> WITHSNAPSHOT,BUFFERCOUNT=1,BLOCKSIZE=1024>>>> 2005-08-25 21:12:31.36
> spid56 BackupMedium::ReportIoError: writefailure on backup device
> '{E78EA9E3-1F8C-450A-A134-FA1E7902D9B9}3'.Operating system error 995(The
> I/O operation has been aborted because ofeither a thread exit or an
> application request.).>>>> 2005-08-25 21:12:31.36 spid56 Internal I/O
> request 0x80815C08: Op:Write, pBuffer: 0x03C50400, Size: 1024, Position:
> 0, UMS: Internal: 0x0,InternalHigh: 0x80811DD0, Offset: 0x80810CA0,
> OffsetHigh: 0x0, m_buf:0xFFFFFFFF, m_len: 2147483647, m_actualBytes: 0,
> m_errcode: 995, BackupFile:{E78EA9E3-1F8C-450A-A134-FA1E7902D9B9}3>>>>
> 2005-08-25 21:12:31.36 backup BACKUP failed to complete the
> commandBACKUP DATABASE [msdb]
> TOVIRTUAL_DEVICE='{E78EA9E3-1F8C-450A-A134-FA1E7902D9B9}3'
> WITHSNAPSHOT,BUFFERCOUNT=1,BLOCKSIZE=1024>>>> 2005-08-25 21:12:31.39
> spid54 BackupMedium::ReportIoError: writefailure on backup device
> '{E78EA9E3-1F8C-450A-A134-FA1E7902D9B9}4'.Operating system error 995(The
> I/O operation has been aborted because ofeither a thread exit or an
> application request.).>>>> 2005-08-25 21:12:31.39 spid54 Internal I/O
> request 0x80969BC0: Op:Write, pBuffer: 0x03A90400, Size: 1024, Position:
> 0, UMS: Internal:0x80968800, InternalHigh: 0x0, Offset: 0x0, OffsetHigh:
> 0x809DB400, m_buf:0x00000000, m_len: 0, m_actualBytes: 0, m_errcode: 995,
> BackupFile:{E78EA9E3-1F8C-450A-A134-FA1E7902D9B9}4>>>> 2005-08-25
> 21:12:31.39 backup BACKUP failed to complete the commandBACKUP DATABASE
> [STS_Config] TOVIRTUAL_DEVICE='{E78EA9E3-1F8C-450A-A134-FA1E7902D9B9}4'
> WITHSNAPSHOT,BUFFERCOUNT=1,BLOCKSIZE=1024>>>> 2005-08-25 21:12:31.39
> spid53 BackupMedium::ReportIoError: writefailure on backup device
> '{E78EA9E3-1F8C-450A-A134-FA1E7902D9B9}5'.Operating system error 995(The
> I/O operation has been aborted because ofeither a thread exit or an
> application request.).>>>> 2005-08-25 21:12:31.39 spid53 Internal I/O
> request 0x80A51C80: Op:Write, pBuffer: 0x03D90400, Size: 1024, Position:
> 0, UMS: Internal: 0x0,InternalHigh: 0x0, Offset: 0x211, OffsetHigh: 0x211,
> m_buf: 0x00000000,m_len: 0, m_actualBytes: 0, m_errcode: 995,
> BackupFile:{E78EA9E3-1F8C-450A-A134-FA1E7902D9B9}5>>>> 2005-08-25
> 21:12:31.39 backup BACKUP failed to complete the commandBACKUP DATABASE
> [STS_OEMSBSCN-3158_1]
> TOVIRTUAL_DEVICE='{E78EA9E3-1F8C-450A-A134-FA1E7902D9B9}5'
> WITHSNAPSHOT,BUFFERCOUNT=1,BLOCKSIZE=1024>>>> 2005-08-26 10:33:37.59 spid4
> SQL Server is terminating due to'stop' request from Service Control
> Manager.>>>>>>>> ================>>>>>>>> Also I am not sure from your
> reply what goes into the exampleosql -E -S %computername%\sharepoint -Q
> "select name, filename fromsysdatabases" Can you see what i need from the
> error log ?>>>>>>>> Thanks for helping us, we are a bit lost on this
> one>>>>>>>> Cheers>>>>>>>> Colin>>>>>>>>>>>>>>>>>>>>> "David Copeland
> [MSFT]" <davidcop@xxxxxxxxxxxxxxxxxxxx> wrote inmessage
> news:eWMK%232jqFHA.364@xxxxxxxxxxxxxxxxxxxxxxx>>>>> Colin,>>>>>>>>>> Based
> on the error it appears that it is unable to get to your contentdatabase
> (based on the database name of sts_siva01_1)>>>>>>>>>> Couple of things to
> check..>>>>> 1) Check in the \program files\microsoft
> sqlserver\mssql$sharepoint\log directory for the errorlog. Does it show
> anyproblems loading/finding that database?>>>>>>>>>> 2) Run the following
> from a command prompt on the server to see wherethe instance thinks the
> database should be.>>>>>>>>>> osql -E -S %computername%\sharepoint -Q
> "select name, filename fromsysdatabases">>>>>>>>>> -->>>>>>>>>> Hope that
> helps,>>>>> David Copeland>>>>> Microsoft Small Business Server
> Support>>>>>>>>>> This posting is provided "AS IS" with no warranties, and
> confers norights.>>>>>>>>>>>>>>> SBS Newsgroups:>>>>>>>>>> SBS v4.x:
> microsoft.public.backoffice.smallbiz>>>>> SBS 2000:
> microsoft.public.backoffice.smallbiz2000>>>>> SBS 2003:
> microsoft.public.windows.server.sbs>>>>>>>>>> "Colin Coleman"
> <colin@xxxxxxxxxxx> wrote in
> messagenews:urhtWejqFHA.2596@xxxxxxxxxxxxxxxxxxxxxxx>>>>>> Since running
> the Windows update on SBS2k3 SP (none) 25th Aug 2005 ,we now>>>>>> find
> that the http://companyweb has stopped working and get a singleline>>>>>>
> reporting that the database could not be connected on the clientexplorer
> and server.>>>>>> the messsage is :>>>>>>>>>>>> Unable to connect to
> database. Check database connection informationand>>>>>> make sure the
> database server is running.>>>>>>>>>>>>>>>>>> I have read many articles
> regarding the shrepoint timer service andtried>>>>>> all of the, to no
> avail, have restrted the Sharepointservice but itstill>>>>>> reports the
> same error on the server and all clients.>>>>>>>>>>>> There appears an
> event 1000 in the application every time anyone logson to>>>>>> the web at
> any client so we have loads of red Gongs in the evnt lognow.>>>>>>>>>>>>
> The Log Error reads:>>>>>>>>>>>> #50070: Unable to connect to the datbase
> STS_siva01_1 onSIVA01\sharepoint. Check the database connection
> information and make surethat the database server is running.>>>>>>>>>>>>
> For more info.......microsoft.....events.asp>>>>>>>>>>>>>>>>>> Where
> should I look next ?>>>>>>>>>>>>
> Colin>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>


.

Relevant Pages

  • Re: NTDS ISAM DataBase Corruption
    ... Error on - ESENTUTL /g ... Wizard to force demotion in Windows Server 2003 and in Windows 2000 Server ... as it may not be the database that is the problem. ... Open a command prompt and run NTDSUTIL to verify the paths for the ...
    (microsoft.public.windows.server.active_directory)
  • Re: Exchange 2000 Event 704 Information Store 1760
    ... Dismount each store on this server. ... Open a command prompt, ... Select the first database on the list, ... Offline defrag will require a disk space location that can accommodate 110% ...
    (microsoft.public.exchange2000.information.store)
  • Re: How to retrieve database password
    ... Type the following command in the DOS prompt. ... Note Be sure to replace SERVERNAME with the name of your SQL server. ... The problem is the admin password for those database is ... > anyone know how to pull MSDE SQL database passwords without booting from ...
    (microsoft.public.sqlserver.msde)
  • Re: Sharepoint Application Error
    ... If it connects/logs in you should get a prompt that looks like 1> ... What messages do you get back from the above command? ... the default sts_config database exists. ... Check the database connection> information and make sure that the database server is> running". ...
    (microsoft.public.windows.server.sbs)
  • Re: Sharepoint Database falling over event 1000
    ... BACKUP DATABASE TO ... Operating system error 995(The I/O operation has been aborted because of ... either a thread exit or an application request.). ... > Microsoft Small Business Server Support ...
    (microsoft.public.windows.server.sbs)