OS: Win2K3 x64 SP2
SQL: Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02
Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on
Windows NT 5.2 (Build 3790: Service Pack 2)
I changed a database to single user, and the machine hung for over two
hours, to I stopped the program. Now I get an error saying 'Could not find
database ID x. Database may not be activated yet ot may be in transition.
Error: 913.
Does anyone have an idea of how to fix this?
right click database, tasks, take offline. Then same thing only bring
online.
"Daniel Rimmelzwaan [MVP - Dynamics NAV]"
<daniel.rimmelzwaan@.nospam.tectura.com> wrote in message
news:ujMVnOBsHHA.3432@.TK2MSFTNGP02.phx.gbl...
> OS: Win2K3 x64 SP2
> SQL: Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02
> Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit)
> on Windows NT 5.2 (Build 3790: Service Pack 2)
> I changed a database to single user, and the machine hung for over two
> hours, to I stopped the program. Now I get an error saying 'Could not find
> database ID x. Database may not be activated yet ot may be in transition.
> Error: 913.
> Does anyone have an idea of how to fix this?
>
Showing posts with label x64. Show all posts
Showing posts with label x64. Show all posts
Thursday, March 29, 2012
Error 913
OS: Win2K3 x64 SP2
SQL: Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02
Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on
Windows NT 5.2 (Build 3790: Service Pack 2)
I changed a database to single user, and the machine hung for over two
hours, to I stopped the program. Now I get an error saying 'Could not find
database ID x. Database may not be activated yet ot may be in transition.
Error: 913.
Does anyone have an idea of how to fix this?right click database, tasks, take offline. Then same thing only bring
online.
"Daniel Rimmelzwaan [MVP - Dynamics NAV]"
<daniel.rimmelzwaan@.nospam.tectura.com> wrote in message
news:ujMVnOBsHHA.3432@.TK2MSFTNGP02.phx.gbl...
> OS: Win2K3 x64 SP2
> SQL: Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02
> Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit)
> on Windows NT 5.2 (Build 3790: Service Pack 2)
> I changed a database to single user, and the machine hung for over two
> hours, to I stopped the program. Now I get an error saying 'Could not find
> database ID x. Database may not be activated yet ot may be in transition.
> Error: 913.
> Does anyone have an idea of how to fix this?
>|||Hi
"Daniel Rimmelzwaan [MVP - Dynamics NAV]"
<daniel.rimmelzwaan@.nospam.tectura.com> wrote in message
news:ujMVnOBsHHA.3432@.TK2MSFTNGP02.phx.gbl...
> OS: Win2K3 x64 SP2
> SQL: Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02
> Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit)
> on Windows NT 5.2 (Build 3790: Service Pack 2)
> I changed a database to single user, and the machine hung for over two
> hours, to I stopped the program. Now I get an error saying 'Could not find
> database ID x. Database may not be activated yet ot may be in transition.
> Error: 913.
> Does anyone have an idea of how to fix this?
My assumption is that stopping the process did not release the connection in
which case,
if you executed sp_who from a SSIS query window you may see one process
using the database, issue a KILL on the spid would allow a different process
to use the database.
Johnsql
SQL: Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02
Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on
Windows NT 5.2 (Build 3790: Service Pack 2)
I changed a database to single user, and the machine hung for over two
hours, to I stopped the program. Now I get an error saying 'Could not find
database ID x. Database may not be activated yet ot may be in transition.
Error: 913.
Does anyone have an idea of how to fix this?right click database, tasks, take offline. Then same thing only bring
online.
"Daniel Rimmelzwaan [MVP - Dynamics NAV]"
<daniel.rimmelzwaan@.nospam.tectura.com> wrote in message
news:ujMVnOBsHHA.3432@.TK2MSFTNGP02.phx.gbl...
> OS: Win2K3 x64 SP2
> SQL: Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02
> Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit)
> on Windows NT 5.2 (Build 3790: Service Pack 2)
> I changed a database to single user, and the machine hung for over two
> hours, to I stopped the program. Now I get an error saying 'Could not find
> database ID x. Database may not be activated yet ot may be in transition.
> Error: 913.
> Does anyone have an idea of how to fix this?
>|||Hi
"Daniel Rimmelzwaan [MVP - Dynamics NAV]"
<daniel.rimmelzwaan@.nospam.tectura.com> wrote in message
news:ujMVnOBsHHA.3432@.TK2MSFTNGP02.phx.gbl...
> OS: Win2K3 x64 SP2
> SQL: Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02
> Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit)
> on Windows NT 5.2 (Build 3790: Service Pack 2)
> I changed a database to single user, and the machine hung for over two
> hours, to I stopped the program. Now I get an error saying 'Could not find
> database ID x. Database may not be activated yet ot may be in transition.
> Error: 913.
> Does anyone have an idea of how to fix this?
My assumption is that stopping the process did not release the connection in
which case,
if you executed sp_who from a SSIS query window you may see one process
using the database, issue a KILL on the spid would allow a different process
to use the database.
Johnsql
Error 913
OS: Win2K3 x64 SP2
SQL: Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02
Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on
Windows NT 5.2 (Build 3790: Service Pack 2)
I changed a database to single user, and the machine hung for over two
hours, to I stopped the program. Now I get an error saying 'Could not find
database ID x. Database may not be activated yet ot may be in transition.
Error: 913.
Does anyone have an idea of how to fix this?right click database, tasks, take offline. Then same thing only bring
online.
"Daniel Rimmelzwaan [MVP - Dynamics NAV]"
<daniel.rimmelzwaan@.nospam.tectura.com> wrote in message
news:ujMVnOBsHHA.3432@.TK2MSFTNGP02.phx.gbl...
> OS: Win2K3 x64 SP2
> SQL: Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02
> Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit)
> on Windows NT 5.2 (Build 3790: Service Pack 2)
> I changed a database to single user, and the machine hung for over two
> hours, to I stopped the program. Now I get an error saying 'Could not find
> database ID x. Database may not be activated yet ot may be in transition.
> Error: 913.
> Does anyone have an idea of how to fix this?
>|||Hi
"Daniel Rimmelzwaan [MVP - Dynamics NAV]"
<daniel.rimmelzwaan@.nospam.tectura.com> wrote in message
news:ujMVnOBsHHA.3432@.TK2MSFTNGP02.phx.gbl...
> OS: Win2K3 x64 SP2
> SQL: Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02
> Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit)
> on Windows NT 5.2 (Build 3790: Service Pack 2)
> I changed a database to single user, and the machine hung for over two
> hours, to I stopped the program. Now I get an error saying 'Could not find
> database ID x. Database may not be activated yet ot may be in transition.
> Error: 913.
> Does anyone have an idea of how to fix this?
My assumption is that stopping the process did not release the connection in
which case,
if you executed sp_who from a SSIS query window you may see one process
using the database, issue a KILL on the spid would allow a different process
to use the database.
John
SQL: Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02
Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on
Windows NT 5.2 (Build 3790: Service Pack 2)
I changed a database to single user, and the machine hung for over two
hours, to I stopped the program. Now I get an error saying 'Could not find
database ID x. Database may not be activated yet ot may be in transition.
Error: 913.
Does anyone have an idea of how to fix this?right click database, tasks, take offline. Then same thing only bring
online.
"Daniel Rimmelzwaan [MVP - Dynamics NAV]"
<daniel.rimmelzwaan@.nospam.tectura.com> wrote in message
news:ujMVnOBsHHA.3432@.TK2MSFTNGP02.phx.gbl...
> OS: Win2K3 x64 SP2
> SQL: Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02
> Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit)
> on Windows NT 5.2 (Build 3790: Service Pack 2)
> I changed a database to single user, and the machine hung for over two
> hours, to I stopped the program. Now I get an error saying 'Could not find
> database ID x. Database may not be activated yet ot may be in transition.
> Error: 913.
> Does anyone have an idea of how to fix this?
>|||Hi
"Daniel Rimmelzwaan [MVP - Dynamics NAV]"
<daniel.rimmelzwaan@.nospam.tectura.com> wrote in message
news:ujMVnOBsHHA.3432@.TK2MSFTNGP02.phx.gbl...
> OS: Win2K3 x64 SP2
> SQL: Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02
> Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit)
> on Windows NT 5.2 (Build 3790: Service Pack 2)
> I changed a database to single user, and the machine hung for over two
> hours, to I stopped the program. Now I get an error saying 'Could not find
> database ID x. Database may not be activated yet ot may be in transition.
> Error: 913.
> Does anyone have an idea of how to fix this?
My assumption is that stopping the process did not release the connection in
which case,
if you executed sp_who from a SSIS query window you may see one process
using the database, issue a KILL on the spid would allow a different process
to use the database.
John
Sunday, February 26, 2012
Error 3449 SQL Server shutdown
SQL Server 2005 X64 Standard running on Windows Server 2003 X64 Htper Threaded Quad processors with 16 GB RAM.
I have had two production servers shut down this week due to Error 3449: SQL Server must shut down in order to recover a database (database ID 1). The database is either a user database that could not be shut down or a system database. Restart SQL Server. If the database fails to recover after another startup, repair or restore the database.
Previous to the shutdown I received multiple Error 3314 & 602: Could not find an entry for table or index with partition ID 491897996509184 in database 2. This error can occur if a stored procedure references a dropped table, or metadata is corrupted. Drop and re-create the stored procedure, or execute DBCC CHECKDB.
Also, Error 9001: During undoing of a logged operation in database 'msdb', an error occurred at log record ID (838:208:1). Typically, the specific failure is logged previously as an error in the Windows Event Log service. Restore the database or file from a backup, or repair the database.
Does anyone have an idea why I have begun receiving these error messages? I have run dbcc checkdb on Master and msdb and they do not show any problems.
I am getting the same error message except ofr the last one (, Error 9001: During undoing of a logged operation in database 'msdb', an error occurred at log record ID (838:208:1). Typically, the specific failure is logged previously as an error in the Windows Event Log service. Restore the database or file from a backup, or repair the database.)
How did you solve this problem,? and why this error showing up?
Thanks
|||Alright Chaps,
There is a hotfix available from microsoft for the errors that you guys are getting. Please check the below link:
http://support.microsoft.com/kb/916086
regards
Jag
Error 3449 SQL Server shutdown
SQL Server 2005 X64 Standard running on Windows Server 2003 X64 Htper Threaded Quad processors with 16 GB RAM.
I have had two production servers shut down this week due to Error 3449: SQL Server must shut down in order to recover a database (database ID 1). The database is either a user database that could not be shut down or a system database. Restart SQL Server. If the database fails to recover after another startup, repair or restore the database.
Previous to the shutdown I received multiple Error 3314 & 602: Could not find an entry for table or index with partition ID 491897996509184 in database 2. This error can occur if a stored procedure references a dropped table, or metadata is corrupted. Drop and re-create the stored procedure, or execute DBCC CHECKDB.
Also, Error 9001: During undoing of a logged operation in database 'msdb', an error occurred at log record ID (838:208:1). Typically, the specific failure is logged previously as an error in the Windows Event Log service. Restore the database or file from a backup, or repair the database.
Does anyone have an idea why I have begun receiving these error messages? I have run dbcc checkdb on Master and msdb and they do not show any problems.
I am getting the same error message except ofr the last one (, Error 9001: During undoing of a logged operation in database 'msdb', an error occurred at log record ID (838:208:1). Typically, the specific failure is logged previously as an error in the Windows Event Log service. Restore the database or file from a backup, or repair the database.)
How did you solve this problem,? and why this error showing up?
Thanks
|||Alright Chaps,
There is a hotfix available from microsoft for the errors that you guys are getting. Please check the below link:
http://support.microsoft.com/kb/916086
regards
Jag
Subscribe to:
Posts (Atom)