Thursday, March 29, 2012

Error accessing registry value in report

We store environment specific information in the registry to ease moving from
dev, test and production environments. I'm making a call in the code window
to read from the registry and am getting this error:
Failed to load expression host assembly. Details: Request for the permission
of type System.Security.Permissions.RegistryPermission, mscorlib,
Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.
(rsProcessingError) Get Online Help
Just as a test I've changed all code access security zones to Full Trust but
this hasn't helped.
Please advise.This is what I had to do to get this working, if anyone's interested:
Edit C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\rssrvpolicy.config and modify the entry in the
Report_Expressions_Default_Permissions CodeGroup and change it from Execute
to FullTrust.
"Aaron" wrote:
> We store environment specific information in the registry to ease moving from
> dev, test and production environments. I'm making a call in the code window
> to read from the registry and am getting this error:
> Failed to load expression host assembly. Details: Request for the permission
> of type System.Security.Permissions.RegistryPermission, mscorlib,
> Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.
> (rsProcessingError) Get Online Help
> Just as a test I've changed all code access security zones to Full Trust but
> this hasn't helped.
> Please advise.
>|||Giving FullTrust to Report_Expressions_Default_Permissions totally opens
your server for hacker attacks. Now all expressions incliding VB.NET
snippets in Report.Code have fulltrust which allows them to perform any
operations, including formatting drives, reading and writing files etc...
The better way is to create a custom assembly with functions to read
registry and call this assembly from your reports. You will then give only
RegistryPermission to that assembly.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Aaron" <Aaron@.discussions.microsoft.com> wrote in message
news:281FF58C-043F-40DA-AFCF-4C413BFC2A49@.microsoft.com...
> This is what I had to do to get this working, if anyone's interested:
> Edit C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer\rssrvpolicy.config and modify the entry in the
> Report_Expressions_Default_Permissions CodeGroup and change it from
Execute
> to FullTrust.
>
> "Aaron" wrote:
> > We store environment specific information in the registry to ease moving
from
> > dev, test and production environments. I'm making a call in the code
window
> > to read from the registry and am getting this error:
> >
> > Failed to load expression host assembly. Details: Request for the
permission
> > of type System.Security.Permissions.RegistryPermission, mscorlib,
> > Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
failed.
> > (rsProcessingError) Get Online Help
> >
> > Just as a test I've changed all code access security zones to Full Trust
but
> > this hasn't helped.
> >
> > Please advise.
> >|||Aaron I have done similar kind of thing, If your still facing the problem
write to me, I can help you out to fix the issue.
My Email ID:
balajikkrishnan [AT] rediffmail [DOT] com
Thanks
Balaji
--
Message posted via http://www.sqlmonster.comsql

Error accessing database

When I launch a client program that reads the database, I
get the following error message
Error while reading information from database
Error Code Login failed for user 'sa'
Reason Not associated with a trusted SQL Server Connection.
Has anyone got ideas on how to Fix this?
Thanks in advance
DarrinHave a look at the server properties. You should see that the server is set
up to use Windows Authentication only. sa is not a windows account. You
are using sa in a client app. Most people would advise against this.
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Darrin" <darrin.adams@.eei.ericsson.se> wrote in message
news:0a6801c3510d$b546da10$a501280a@.phx.gbl...
> When I launch a client program that reads the database, I
> get the following error message
> Error while reading information from database
> Error Code Login failed for user 'sa'
> Reason Not associated with a trusted SQL Server Connection.
> Has anyone got ideas on how to Fix this?
> Thanks in advance
> Darrin

Error access Custom Assembly in Deploying

Please,

i did a class in C# that return a array of bytes... in preview mode (design) i can see this return, but when i use Deploy (Server) i can′t see.

I already put the lines on of security in file srrsvpolicy.config and copy the file dll to folder, however i cant see the result.

Anybody help me?

I′m using:

- SQL 2005
- dll no strong name

Thanks

Jota

Assuming you have put the right security settings and deployed the assembly to the Report Server bin folder, your method may need additional CAS security rights depending on what your code is trying to do, as explained in more details here. What I suggest you do is put a breakpoint in your assembly code, attach to the ASP.NET process, and run the report so you can debug your code and see where the exception is thrown.

Error accesing RS

I change the windows authentication from the default site folder security and before I change again to windows authentication. But now when I want to open reportmanager It raises Unable to generate a temporaty class (result=1) . error CS2001: Source file 'C:\WINDOWS\TEMP\ugmf4j6-0.cs' could not be found error CS2008: No inputs specified.

Any ideas?
RS Services April CTP.
Thanks in advanceI need to solve this quickly!!! I have a presentation with a director.

I thinking in reinstall IIS.

What can I do?|||I found no solution to this. I finally reinstalled IIS.

Error accepting connection request via Net-Library 'SSNETLIB'

Hi,
I installed SP3 over SQL2K on NT Server SP6. The Server
hangs on startup. This is after I did an upgrade
installation of SQL 7 to SQL Server 2000 and applied SP3
over it. Everything runs fine for afew hours and then we
get the message below and some of our servers lose the
ability to connect to the sql server.
2003-12-18 10:20:08.84 spid65 Using 'xp_AltaMX.dll' version
'0002.00.00' to execute extended stored
procedure 'xp_AltaMX'.
2003-12-18 11:01:49.43 spid62 Using 'xpipass.dll'
version 'UNKNOWN'to execute extended stored
procedure 'xp_ipass_actualiza'.
2003-12-18 12:24:01.62 server Error: 17882, Severity: 18,
State: 1
2003-12-18 12:24:01.62 server Error accepting connection
request via Net-Library 'SSNETLIB'. Execution continuing..
2003-12-18 12:24:01.62 server Error: 17059, Severity: 18,
State: 0
2003-12-18 12:24:01.62 server Operating system error 1:
Incorrect function...
2003-12-18 12:31:58.09 server SQL Server could not spawn
process_loginread thread.
2003-12-18 12:31:59.09 server Error: 17882, Severity: 18,
State: 1
2003-12-18 12:31:59.09 server Error accepting connection
request via Net-Library 'SSNETLIB'. Execution continuing..
2003-12-18 12:31:59.09 server Error: 17059, Severity: 18,
State: 0
2003-12-18 12:31:59.09 server Operating system error 1:
Incorrect function...
2003-12-18 12:41:30.01 server Error: 17882, Severity: 18,
State: 1
2003-12-18 12:41:30.01 server Error accepting connection
request via Net-Library 'SSNETLIB'. Execution continuing..
2003-12-18 12:41:30.01 server Error: 17059, Severity: 18,
State: 0
2003-12-18 12:41:30.01 server Operating system error 1:
Incorrect function...
2003-12-18 12:51:21.10 server SQL Server is disallowing new
connections due to 'pause' request from Service Control
Manager.
2003-12-18 12:53:09.60 spid3 SQL Server is terminating due
to 'stop' request from Service Control Manager.
I would be greatful if anyone has any ideas on how to deal
with this ?
I already reviewed this article but me it has not been
helpful.
http://support.microsoft.com/default.aspx?scid=kb;en-
us;811887&Product=sql2k
I am of course afraid that someday we will not be able to
access the
sql server.
Regards,
LeoWho supplied you with
xp_AltaMX
xpipass.dll
xp_ipass_actualiza
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Hi Kevin,
The development area supplied them. Let me tell you=20
something, when this server was working under SQL 7, this=20
error never appeared. After upgrade the error appeared.
Do you think that the problem may be are the xp=B4s?
thanks,
Leo|||Drop /remove the xp's and see if the problem persists. Do this in your
Test environment.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.sql

Error about Report builder

I login in my server do report with report builder , when i run report , the error is:

The permissions granted to user 'ADSYSTEC-CZW\users11' are insufficient for performing this operation.

1. The server and my machine are not the same computer,My machine name is adsystec-czw.

2. The reports web site's Authentication is Integrated Windows Authentication.

3. I use the given user(users11) login in belongs to the user groups.


thanks for helps!

Since you are saying you get the error when running the report, I am assuming you have no problem launching Report Builder, viewing Models, and creating and saving a Report to the server. Have you tried running your report directly from the server, after saving it there?

It sounds like your problem may be that the datasource your report uses is not set up correctly. If the data you are trying to retrieve is on a different server than your Report Server, you may need to check the "Use Windows credentials" checkbox in (ie. edit your Datasource in Report Manager).

|||I login in the server's report builder with the URL http://adsystec-czw/reportserver/reportbuilder/reportbuilder.application If I use the server's administrators to login in the server's report server, That error doesn't exist.

Error about OLAP Admin permissions

Hi iam executing this code and iam getting the error

Unable to connect to the registry on the server (SQLSERVER), or you are not a member of the OLAP Administrators group on this server.

The code is

Private Sub cbDataBaseList_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cbDataBaseList.SelectedIndexChanged

Dim dsoServer As New DSO.Server

Dim dsoDB As DSO.MDStore

Dim dsoCube As DSO.MDStore

' Create a connection to the Analysis server.

dsoServer.Connect("Localhost")

' Step through the databases in the server object.

For Each dsoDB In dsoServer.MDStores

' Print the name of the database into drop down box

cboDbName.Items.Add(dsoDB.Name)

Next dsoDB

listCubes.Items.Clear()

Dim strDataBaseName As String
strDataBaseName = cbDataBaseList.SelectedItem

Dim dsoDb As DSO.MDStore

If dsoServer.MDStores.Find(strDataBaseName) Then

dsoDb = dsoServer.MDStores.Item(strDataBaseName)

Dim dsoCube As DSO.MDStore
For Each dsoCube In dsoDb.MDStores
listCubes.Items.Add(dsoCube.Name)
Next

End If

End Sub


I donno whats that error and how to fix it if some one could help me it would be great.

Thank You

Emily

There are two common causes of this error that I am aware of

1) You are not a member of the OLAP Administrators group on the server (obviously, but I assume you have double checked this)

2) The server has had a service pack applied, but the client has an older version of the DSO libraries.

If item 1) is not your issue then what I would suggest is to find out what service pack has been applied to the server.

To find out the current level of Windows 2000 Analysis Services, start the Analysis Manager, right-click on the Analysis Servers node, and select "About Analysis Services." (Note that this tells you the SP that is on the machine running Analysis Manager - so you might want to run this check on the server console)

Once you have the version number, then match it to the list below to find which SQL Server service pack you are using.

2000.8.0.2039 Analysis Services SP 4 2000.8.0.760 Analysis Services SP 3 2000.8.0.532 Analysis Services SP 2 2000.8.0.382 Analysis Services SP1 2000.8.0.194 Analysis Services "gold" release, no SP

Error 954: Database has invalid schema - SQL2000

I'm restoring a database on another server, the restore from disk goes
through successfully, until I try to click on tables or views I get the
message below:
Error 954: Database 'dbname' has invalid schema
Thanks in advance for any help.ITDUDE27,
Are you using SharePoint and Small Business Server? If so, here are a
couple of links:
http://blogs.technet.com/edwalt/archive/2006/03/06/421346.aspx
http://msmvps.com/blogs/bradley/archive/2005/09/13/66344.aspx
I do have one weird thought: it sounds as if the file location for the files
in the database does not match the actual file locations of the mdf and/or
ldf. Did you use the MOVE option during the RESTORE in order to position
the files properly?
Other than that, I have no really useful suggestions.
RLF
"ITDUDE27" <ITDUDE27@.discussions.microsoft.com> wrote in message
news:DB40C301-EF5E-4664-819C-B251D4F8BE24@.microsoft.com...
> I'm restoring a database on another server, the restore from disk goes
> through successfully, until I try to click on tables or views I get the
> message below:
> Error 954: Database 'dbname' has invalid schema
> Thanks in advance for any help.
>|||Thanks Russ.
I'am running SP on SBS 2003. my Live sharepoint site is running fine and I
was able to install SP 2.0 on another server and it came up fine. I trying to
restore a copy of the live db as test and that is what is causing the error.
I had seen the second link you refered too, it was not help full. The point
of this exercise is to restore the sp database using Enterprize manager and
query it and then map it as my SP content database.
I've tried the move command using osql with no success. I think you are
absoluty correct about the Move, I'm just not having any luck, which ever way
I restore the SP db I get the same message.
Thanks in advance for any other feedback.
"Russell Fields" wrote:
> ITDUDE27,
> Are you using SharePoint and Small Business Server? If so, here are a
> couple of links:
> http://blogs.technet.com/edwalt/archive/2006/03/06/421346.aspx
> http://msmvps.com/blogs/bradley/archive/2005/09/13/66344.aspx
> I do have one weird thought: it sounds as if the file location for the files
> in the database does not match the actual file locations of the mdf and/or
> ldf. Did you use the MOVE option during the RESTORE in order to position
> the files properly?
> Other than that, I have no really useful suggestions.
> RLF
> "ITDUDE27" <ITDUDE27@.discussions.microsoft.com> wrote in message
> news:DB40C301-EF5E-4664-819C-B251D4F8BE24@.microsoft.com...
> > I'm restoring a database on another server, the restore from disk goes
> > through successfully, until I try to click on tables or views I get the
> > message below:
> >
> > Error 954: Database 'dbname' has invalid schema
> >
> > Thanks in advance for any help.
> >
> >
>
>|||Russell,
Can you comfirm the syntax for me.
Current location: N:\Program Files\Microsoft SQL
Server\MSSQL\BACKUP\avalanche.bak from other server
New location: N:\Program Files\Microsoft SQL Server\MSSQL\Data
RESTORE DATABASE avalanche_new FROM DISK = 'N:\Program Files\Microsoft SQL
Server\MSSQL\BACKUP\avalanche.bak'
WITH
MOVE 'northwind' TO 'N:\Program Files\Microsoft SQL
Server\MSSQL\BACKUP\avalanche_new.mdf'
MOVE 'northwind_log' TO 'N:\Program Files\Microsoft SQL
Server\MSSQL\BACKUP\avalanche_log.ldf'
Thanks in advance.
"Russell Fields" wrote:
> ITDUDE27,
> Are you using SharePoint and Small Business Server? If so, here are a
> couple of links:
> http://blogs.technet.com/edwalt/archive/2006/03/06/421346.aspx
> http://msmvps.com/blogs/bradley/archive/2005/09/13/66344.aspx
> I do have one weird thought: it sounds as if the file location for the files
> in the database does not match the actual file locations of the mdf and/or
> ldf. Did you use the MOVE option during the RESTORE in order to position
> the files properly?
> Other than that, I have no really useful suggestions.
> RLF
> "ITDUDE27" <ITDUDE27@.discussions.microsoft.com> wrote in message
> news:DB40C301-EF5E-4664-819C-B251D4F8BE24@.microsoft.com...
> > I'm restoring a database on another server, the restore from disk goes
> > through successfully, until I try to click on tables or views I get the
> > message below:
> >
> > Error 954: Database 'dbname' has invalid schema
> >
> > Thanks in advance for any help.
> >
> >
>
>|||ITDUDE27,
Syntax looks correct, but the code does not match your spec. Compare:
N:\Program Files\Microsoft SQL Server\MSSQL\Data
N:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\avalanche_new.mdf
If N:\ is a network drive that is not a supported configuration for SQL
Server databases. You will need to place the database files on locally
attached storage or on your SAN.
And, of course, I assume that the 'northwind%' logical names are correct.
I also usually specify a couple of things that should not be necessary in my
RESTORE command. Habit, you know, but I include the options:
RECOVERY, REPLACE
FWIW,
RLF
"ITDUDE27" <ITDUDE27@.discussions.microsoft.com> wrote in message
news:F7C1965F-448C-44F1-8DEF-9860E15E1A86@.microsoft.com...
> Russell,
> Can you comfirm the syntax for me.
> Current location: N:\Program Files\Microsoft SQL
> Server\MSSQL\BACKUP\avalanche.bak from other server
> New location: N:\Program Files\Microsoft SQL Server\MSSQL\Data
>
> RESTORE DATABASE avalanche_new FROM DISK = 'N:\Program Files\Microsoft SQL
> Server\MSSQL\BACKUP\avalanche.bak'
> WITH
> MOVE 'northwind' TO 'N:\Program Files\Microsoft SQL
> Server\MSSQL\BACKUP\avalanche_new.mdf'
> MOVE 'northwind_log' TO 'N:\Program Files\Microsoft SQL
> Server\MSSQL\BACKUP\avalanche_log.ldf'
> Thanks in advance.
>
> "Russell Fields" wrote:
>> ITDUDE27,
>> Are you using SharePoint and Small Business Server? If so, here are a
>> couple of links:
>> http://blogs.technet.com/edwalt/archive/2006/03/06/421346.aspx
>> http://msmvps.com/blogs/bradley/archive/2005/09/13/66344.aspx
>> I do have one weird thought: it sounds as if the file location for the
>> files
>> in the database does not match the actual file locations of the mdf
>> and/or
>> ldf. Did you use the MOVE option during the RESTORE in order to position
>> the files properly?
>> Other than that, I have no really useful suggestions.
>> RLF
>> "ITDUDE27" <ITDUDE27@.discussions.microsoft.com> wrote in message
>> news:DB40C301-EF5E-4664-819C-B251D4F8BE24@.microsoft.com...
>> > I'm restoring a database on another server, the restore from disk goes
>> > through successfully, until I try to click on tables or views I get the
>> > message below:
>> >
>> > Error 954: Database 'dbname' has invalid schema
>> >
>> > Thanks in advance for any help.
>> >
>> >
>>

Error 954: Database 'dbname' has invalid schema

I'm restoring a database on another server, the restore from disk goes
through successfully, until I try to click on tables or views I get the
message below:
Error 954: Database 'dbname' has invalid schema
any thoughts?Hi
Can you provide us with more info? What is the version are you using? Do you
try restore from SS2000 to SS2005?
"ITDUDE27" <ITDUDE27@.discussions.microsoft.com> wrote in message
news:35AE8C40-3659-44DB-BABB-8B65D1223181@.microsoft.com...
> I'm restoring a database on another server, the restore from disk goes
> through successfully, until I try to click on tables or views I get the
> message below:
> Error 954: Database 'dbname' has invalid schema
> any thoughts?|||Thanks for the response uri.
I'm doing the restore on SS2000 to SS2000. I'm trying to test the install of
WSS3.0 on a test environment but the restore is displaying that error.
Thanks in advance.
"Uri Dimant" wrote:
> Hi
> Can you provide us with more info? What is the version are you using? Do you
> try restore from SS2000 to SS2005?
> "ITDUDE27" <ITDUDE27@.discussions.microsoft.com> wrote in message
> news:35AE8C40-3659-44DB-BABB-8B65D1223181@.microsoft.com...
> >
> > I'm restoring a database on another server, the restore from disk goes
> > through successfully, until I try to click on tables or views I get the
> > message below:
> >
> > Error 954: Database 'dbname' has invalid schema
> >
> > any thoughts?
>
>

Error 952 Database is in Transition

One of our SQL 2005 database started to give us "Database is in
transition...Error 952". We were trying to Take the DB offline when this
problem occurred. Restarting SQL service did not help us. We were unable to do anything with this database as we were unable to obtain any locks.

What resolved the problem? Re-starting manamgement studio on client machine.
Go Figure!

SJ100,

Thanks for posting this. It saved my customer at 5am this morning...

I will be opening a case with MS to see if this is a known bug, or "by design" behavior.

Kevin3NF

http://kevin3nf.blogspot.com

|||Thanks mate!|||Thanks folks! It saved my day.|||

I simply stop-start SQL Server Service using Mgmt Studio and it worked for me!

-P

|||one more time, thanks a lot|||

It worked for me too, closing a forgotten QueryAnalayzer solve the problem on a sql2000 database.

Thanks a lot again.

|||

Thank YOU for this post. We could not turn of the SQL Service as have more than one db active. This is definitely a bug...you try to take a db offline but it does not go, just stays inaccessible and in the "transition" state. Closing Management Studio released whatever locks were still alive and we could reconnect fine.

Thank you again.

|||I agree on the other comments: it worked out very fine with no server stop.
Thanks for your post.
sql

Error 952 Database is in Transition

One of our SQL 2005 database started to give us "Database is in
transition...Error 952". We were trying to Take the DB offline when this
problem occurred. Restarting SQL service did not help us. We were unable to do anything with this database as we were unable to obtain any locks.

What resolved the problem? Re-starting manamgement studio on client machine.
Go Figure!

SJ100,

Thanks for posting this. It saved my customer at 5am this morning...

I will be opening a case with MS to see if this is a known bug, or "by design" behavior.

Kevin3NF

http://kevin3nf.blogspot.com

|||Thanks mate!|||Thanks folks! It saved my day.|||

I simply stop-start SQL Server Service using Mgmt Studio and it worked for me!

-P

|||one more time, thanks a lot|||

It worked for me too, closing a forgotten QueryAnalayzer solve the problem on a sql2000 database.

Thanks a lot again.

|||

Thank YOU for this post. We could not turn of the SQL Service as have more than one db active. This is definitely a bug...you try to take a db offline but it does not go, just stays inaccessible and in the "transition" state. Closing Management Studio released whatever locks were still alive and we could reconnect fine.

Thank you again.

|||I agree on the other comments: it worked out very fine with no server stop.
Thanks for your post.

Error 952 Database is in Transition

One of our SQL 2005 database started to give us "Database is in
transition...Error 952". We were trying to Take the DB offline when this
problem occurred. Restarting SQL service did not help us. We were unable to do anything with this database as we were unable to obtain any locks.

What resolved the problem? Re-starting manamgement studio on client machine.
Go Figure!

Thank YOU for this post. We could not turn of the SQL Service as have more than one db active. This is definitely a bug...you try to take a db offline but it does not go, just stays inaccessible and in the "transition" state. Closing Management Studio released whatever locks were still alive and we could reconnect fine.

Thank you again.

|||I agree on the other comments: it worked out very fine with no server stop.
Thanks for your post.|||

SJ100,

Thanks for posting this. It saved my customer at 5am this morning...

I will be opening a case with MS to see if this is a known bug, or "by design" behavior.

Kevin3NF

http://kevin3nf.blogspot.com

|||Thanks mate!|||Thanks folks! It saved my day.|||

I simply stop-start SQL Server Service using Mgmt Studio and it worked for me!

-P

|||one more time, thanks a lot|||

It worked for me too, closing a forgotten QueryAnalayzer solve the problem on a sql2000 database.

Thanks a lot again.

Error 952 Database is in Transition

One of our SQL 2005 database started to give us "Database is in
transition...Error 952". We were trying to Take the DB offline when this
problem occurred. Restarting SQL service did not help us. We were unable to do anything with this database as we were unable to obtain any locks.

What resolved the problem? Re-starting manamgement studio on client machine.
Go Figure!

SJ100,

Thanks for posting this. It saved my customer at 5am this morning...

I will be opening a case with MS to see if this is a known bug, or "by design" behavior.

Kevin3NF

http://kevin3nf.blogspot.com

|||Thanks mate!|||Thanks folks! It saved my day.|||

I simply stop-start SQL Server Service using Mgmt Studio and it worked for me!

-P

|||one more time, thanks a lot|||

It worked for me too, closing a forgotten QueryAnalayzer solve the problem on a sql2000 database.

Thanks a lot again.

|||

Thank YOU for this post. We could not turn of the SQL Service as have more than one db active. This is definitely a bug...you try to take a db offline but it does not go, just stays inaccessible and in the "transition" state. Closing Management Studio released whatever locks were still alive and we could reconnect fine.

Thank you again.

|||I agree on the other comments: it worked out very fine with no server stop.
Thanks for your post.

Error 952 Database is in Transition

One of our SQL 2005 database started to give us "Database is in
transition...Error 952". We were trying to Take the DB offline when this
problem occurred. Restarting SQL service did not help us. We were unable to do anything with this database as we were unable to obtain any locks.

What resolved the problem? Re-starting manamgement studio on client machine.
Go Figure!

SJ100,

Thanks for posting this. It saved my customer at 5am this morning...

I will be opening a case with MS to see if this is a known bug, or "by design" behavior.

Kevin3NF

http://kevin3nf.blogspot.com

|||Thanks mate!|||Thanks folks! It saved my day.|||

I simply stop-start SQL Server Service using Mgmt Studio and it worked for me!

-P

|||one more time, thanks a lot|||

It worked for me too, closing a forgotten QueryAnalayzer solve the problem on a sql2000 database.

Thanks a lot again.

|||

Thank YOU for this post. We could not turn of the SQL Service as have more than one db active. This is definitely a bug...you try to take a db offline but it does not go, just stays inaccessible and in the "transition" state. Closing Management Studio released whatever locks were still alive and we could reconnect fine.

Thank you again.

|||I agree on the other comments: it worked out very fine with no server stop.
Thanks for your post.

Error 952 Database is in Transition

One of our SQL 2005 database started to give us "Database is in
transition...Error 952". We were trying to Take the DB offline when this
problem occurred. Restarting SQL service did not help us. We were unable to do anything with this database as we were unable to obtain any locks.

What resolved the problem? Re-starting manamgement studio on client machine.
Go Figure!

SJ100,

Thanks for posting this. It saved my customer at 5am this morning...

I will be opening a case with MS to see if this is a known bug, or "by design" behavior.

Kevin3NF

http://kevin3nf.blogspot.com

|||Thanks mate!|||Thanks folks! It saved my day.|||

I simply stop-start SQL Server Service using Mgmt Studio and it worked for me!

-P

|||one more time, thanks a lot|||

It worked for me too, closing a forgotten QueryAnalayzer solve the problem on a sql2000 database.

Thanks a lot again.

|||

Thank YOU for this post. We could not turn of the SQL Service as have more than one db active. This is definitely a bug...you try to take a db offline but it does not go, just stays inaccessible and in the "transition" state. Closing Management Studio released whatever locks were still alive and we could reconnect fine.

Thank you again.

|||I agree on the other comments: it worked out very fine with no server stop.
Thanks for your post.sql

Error 952 Database is in Transition

One of our SQL 2005 database started to give us "Database is in
transition...Error 952". We were trying to Take the DB offline when this
problem occurred. Restarting SQL service did not help us. We were unable to do anything with this database as we were unable to obtain any locks.

What resolved the problem? Re-starting manamgement studio on client machine.
Go Figure!

SJ100,

Thanks for posting this. It saved my customer at 5am this morning...

I will be opening a case with MS to see if this is a known bug, or "by design" behavior.

Kevin3NF

http://kevin3nf.blogspot.com

|||Thanks mate!|||Thanks folks! It saved my day.|||

I simply stop-start SQL Server Service using Mgmt Studio and it worked for me!

-P

|||one more time, thanks a lot|||

It worked for me too, closing a forgotten QueryAnalayzer solve the problem on a sql2000 database.

Thanks a lot again.

|||

Thank YOU for this post. We could not turn of the SQL Service as have more than one db active. This is definitely a bug...you try to take a db offline but it does not go, just stays inaccessible and in the "transition" state. Closing Management Studio released whatever locks were still alive and we could reconnect fine.

Thank you again.

|||I agree on the other comments: it worked out very fine with no server stop.
Thanks for your post.

Error 952 Database is in Transition

One of our SQL 2005 database started to give us "Database is in
transition...Error 952". We were trying to Take the DB offline when this
problem occurred. Restarting SQL service did not help us. We were unable to do anything with this database as we were unable to obtain any locks.

What resolved the problem? Re-starting manamgement studio on client machine.
Go Figure!

SJ100,

Thanks for posting this. It saved my customer at 5am this morning...

I will be opening a case with MS to see if this is a known bug, or "by design" behavior.

Kevin3NF

http://kevin3nf.blogspot.com

|||Thanks mate!|||Thanks folks! It saved my day.|||

I simply stop-start SQL Server Service using Mgmt Studio and it worked for me!

-P

|||one more time, thanks a lot|||

It worked for me too, closing a forgotten QueryAnalayzer solve the problem on a sql2000 database.

Thanks a lot again.

|||

Thank YOU for this post. We could not turn of the SQL Service as have more than one db active. This is definitely a bug...you try to take a db offline but it does not go, just stays inaccessible and in the "transition" state. Closing Management Studio released whatever locks were still alive and we could reconnect fine.

Thank you again.

|||I agree on the other comments: it worked out very fine with no server stop.
Thanks for your post.

Error 946: Cannot open database upgrade the database to the latest

I am trying to move a database from SQL Server 70 @. 70 compatibility level to
SQL Server 2000 @. 70 compatibility level.
But when execute restore stmt (cmd), I keep getting the errors:
Server: Msg 9002, Level 17, State 6, Line 2
The log file for database 'my_db' is full. Back up the transaction log for
the database to free up some log space.
Server: Msg 3013, Level 16, State 1, Line 2
RESTORE DATABASE is terminating abnormally.
Converting database 'my_db' from version 515 to the current version 539.
Database 'my_db' running the upgrade step from version 515 to version 524.
Database 'my_db' running the upgrade step from version 524 to version 525.
Database 'my_db' running the upgrade step from version 525 to version 526.
Database 'my_db' running the upgrade step from version 526 to version 527.
Database 'my_db' running the upgrade step from version 527 to version 528.
Database 'my_db' running the upgrade step from version 528 to version 529.
Database 'my_db' running the upgrade step from version 529 to version 530.
Database 'my_db' running the upgrade step from version 530 to version 531.
Database 'my_db' running the upgrade step from version 531 to version 532.
Database 'my_db' running the upgrade step from version 532 to version 533.
Database 'my_db' running the upgrade step from version 533 to version 534.
Database 'my_db' running the upgrade step from version 534 to version 535.
Error 946: Cannot open database upgrade the database to the latest version
Any idea, how I can restore w/o errors?
Hi,
Looks like you do not have enough room in your hard disk in which the LDF
file resides. Could you identify the drive with more space and use
RESTORE DATABASE command with MOVE options to restore the database. See
Restore with Move option in Books online.
Thanks
Hari
SQL Server MVP
"Pari" <Pari@.discussions.microsoft.com> wrote in message
news:C74D6B5B-436D-4288-ABF3-31C835CC236B@.microsoft.com...
>I am trying to move a database from SQL Server 70 @. 70 compatibility level
>to
> SQL Server 2000 @. 70 compatibility level.
> But when execute restore stmt (cmd), I keep getting the errors:
> Server: Msg 9002, Level 17, State 6, Line 2
> The log file for database 'my_db' is full. Back up the transaction log for
> the database to free up some log space.
> Server: Msg 3013, Level 16, State 1, Line 2
> RESTORE DATABASE is terminating abnormally.
> Converting database 'my_db' from version 515 to the current version 539.
> Database 'my_db' running the upgrade step from version 515 to version 524.
> Database 'my_db' running the upgrade step from version 524 to version 525.
> Database 'my_db' running the upgrade step from version 525 to version 526.
> Database 'my_db' running the upgrade step from version 526 to version 527.
> Database 'my_db' running the upgrade step from version 527 to version 528.
> Database 'my_db' running the upgrade step from version 528 to version 529.
> Database 'my_db' running the upgrade step from version 529 to version 530.
> Database 'my_db' running the upgrade step from version 530 to version 531.
> Database 'my_db' running the upgrade step from version 531 to version 532.
> Database 'my_db' running the upgrade step from version 532 to version 533.
> Database 'my_db' running the upgrade step from version 533 to version 534.
> Database 'my_db' running the upgrade step from version 534 to version 535.
> Error 946: Cannot open database upgrade the database to the latest version
>
> Any idea, how I can restore w/o errors?
|||Hi
For an Upgrade, SQL Server needs space in the transaction log to work. You
don't have enough.
On the SQL Server 7.0, before you make the backup, dump the log, grow the
transaction log to at least 10% of the database size, then do the backup and
then the restore the SQL Server 2000.
Regards
Mike
"Pari" wrote:

> I am trying to move a database from SQL Server 70 @. 70 compatibility level to
> SQL Server 2000 @. 70 compatibility level.
> But when execute restore stmt (cmd), I keep getting the errors:
> Server: Msg 9002, Level 17, State 6, Line 2
> The log file for database 'my_db' is full. Back up the transaction log for
> the database to free up some log space.
> Server: Msg 3013, Level 16, State 1, Line 2
> RESTORE DATABASE is terminating abnormally.
> Converting database 'my_db' from version 515 to the current version 539.
> Database 'my_db' running the upgrade step from version 515 to version 524.
> Database 'my_db' running the upgrade step from version 524 to version 525.
> Database 'my_db' running the upgrade step from version 525 to version 526.
> Database 'my_db' running the upgrade step from version 526 to version 527.
> Database 'my_db' running the upgrade step from version 527 to version 528.
> Database 'my_db' running the upgrade step from version 528 to version 529.
> Database 'my_db' running the upgrade step from version 529 to version 530.
> Database 'my_db' running the upgrade step from version 530 to version 531.
> Database 'my_db' running the upgrade step from version 531 to version 532.
> Database 'my_db' running the upgrade step from version 532 to version 533.
> Database 'my_db' running the upgrade step from version 533 to version 534.
> Database 'my_db' running the upgrade step from version 534 to version 535.
> Error 946: Cannot open database upgrade the database to the latest version
>
> Any idea, how I can restore w/o errors?

Error 946: Cannot open database upgrade the database to the latest

I am trying to move a database from SQL Server 70 @. 70 compatibility level to
SQL Server 2000 @. 70 compatibility level.
But when execute restore stmt (cmd), I keep getting the errors:
Server: Msg 9002, Level 17, State 6, Line 2
The log file for database 'my_db' is full. Back up the transaction log for
the database to free up some log space.
Server: Msg 3013, Level 16, State 1, Line 2
RESTORE DATABASE is terminating abnormally.
Converting database 'my_db' from version 515 to the current version 539.
Database 'my_db' running the upgrade step from version 515 to version 524.
Database 'my_db' running the upgrade step from version 524 to version 525.
Database 'my_db' running the upgrade step from version 525 to version 526.
Database 'my_db' running the upgrade step from version 526 to version 527.
Database 'my_db' running the upgrade step from version 527 to version 528.
Database 'my_db' running the upgrade step from version 528 to version 529.
Database 'my_db' running the upgrade step from version 529 to version 530.
Database 'my_db' running the upgrade step from version 530 to version 531.
Database 'my_db' running the upgrade step from version 531 to version 532.
Database 'my_db' running the upgrade step from version 532 to version 533.
Database 'my_db' running the upgrade step from version 533 to version 534.
Database 'my_db' running the upgrade step from version 534 to version 535.
Error 946: Cannot open database upgrade the database to the latest version
Any idea, how I can restore w/o errors?Hi,
Looks like you do not have enough room in your hard disk in which the LDF
file resides. Could you identify the drive with more space and use
RESTORE DATABASE command with MOVE options to restore the database. See
Restore with Move option in Books online.
Thanks
Hari
SQL Server MVP
"Pari" <Pari@.discussions.microsoft.com> wrote in message
news:C74D6B5B-436D-4288-ABF3-31C835CC236B@.microsoft.com...
>I am trying to move a database from SQL Server 70 @. 70 compatibility level
>to
> SQL Server 2000 @. 70 compatibility level.
> But when execute restore stmt (cmd), I keep getting the errors:
> Server: Msg 9002, Level 17, State 6, Line 2
> The log file for database 'my_db' is full. Back up the transaction log for
> the database to free up some log space.
> Server: Msg 3013, Level 16, State 1, Line 2
> RESTORE DATABASE is terminating abnormally.
> Converting database 'my_db' from version 515 to the current version 539.
> Database 'my_db' running the upgrade step from version 515 to version 524.
> Database 'my_db' running the upgrade step from version 524 to version 525.
> Database 'my_db' running the upgrade step from version 525 to version 526.
> Database 'my_db' running the upgrade step from version 526 to version 527.
> Database 'my_db' running the upgrade step from version 527 to version 528.
> Database 'my_db' running the upgrade step from version 528 to version 529.
> Database 'my_db' running the upgrade step from version 529 to version 530.
> Database 'my_db' running the upgrade step from version 530 to version 531.
> Database 'my_db' running the upgrade step from version 531 to version 532.
> Database 'my_db' running the upgrade step from version 532 to version 533.
> Database 'my_db' running the upgrade step from version 533 to version 534.
> Database 'my_db' running the upgrade step from version 534 to version 535.
> Error 946: Cannot open database upgrade the database to the latest version
>
> Any idea, how I can restore w/o errors?|||Hi
For an Upgrade, SQL Server needs space in the transaction log to work. You
don't have enough.
On the SQL Server 7.0, before you make the backup, dump the log, grow the
transaction log to at least 10% of the database size, then do the backup and
then the restore the SQL Server 2000.
Regards
Mike
"Pari" wrote:
> I am trying to move a database from SQL Server 70 @. 70 compatibility level to
> SQL Server 2000 @. 70 compatibility level.
> But when execute restore stmt (cmd), I keep getting the errors:
> Server: Msg 9002, Level 17, State 6, Line 2
> The log file for database 'my_db' is full. Back up the transaction log for
> the database to free up some log space.
> Server: Msg 3013, Level 16, State 1, Line 2
> RESTORE DATABASE is terminating abnormally.
> Converting database 'my_db' from version 515 to the current version 539.
> Database 'my_db' running the upgrade step from version 515 to version 524.
> Database 'my_db' running the upgrade step from version 524 to version 525.
> Database 'my_db' running the upgrade step from version 525 to version 526.
> Database 'my_db' running the upgrade step from version 526 to version 527.
> Database 'my_db' running the upgrade step from version 527 to version 528.
> Database 'my_db' running the upgrade step from version 528 to version 529.
> Database 'my_db' running the upgrade step from version 529 to version 530.
> Database 'my_db' running the upgrade step from version 530 to version 531.
> Database 'my_db' running the upgrade step from version 531 to version 532.
> Database 'my_db' running the upgrade step from version 532 to version 533.
> Database 'my_db' running the upgrade step from version 533 to version 534.
> Database 'my_db' running the upgrade step from version 534 to version 535.
> Error 946: Cannot open database upgrade the database to the latest version
>
> Any idea, how I can restore w/o errors?|||Hi, you are right my log file did not have enough space, however, do you know
what these messages mean?
> > Database 'my_db' running the upgrade step from version 524 to version 525.
> > Database 'my_db' running the upgrade step from version 525 to version 526.
> > Database 'my_db' running the upgrade step from version 526 to version 527.
> > Database 'my_db' running the upgrade step from version 527 to version 528.
> > Database 'my_db' running the upgrade step from version 528 to version 529.
Does it mean its upgrading the DB from 70 compatibility to 80'
Thanks
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> For an Upgrade, SQL Server needs space in the transaction log to work. You
> don't have enough.
> On the SQL Server 7.0, before you make the backup, dump the log, grow the
> transaction log to at least 10% of the database size, then do the backup and
> then the restore the SQL Server 2000.
> Regards
> Mike
> "Pari" wrote:
> > I am trying to move a database from SQL Server 70 @. 70 compatibility level to
> > SQL Server 2000 @. 70 compatibility level.
> >
> > But when execute restore stmt (cmd), I keep getting the errors:
> >
> > Server: Msg 9002, Level 17, State 6, Line 2
> > The log file for database 'my_db' is full. Back up the transaction log for
> > the database to free up some log space.
> > Server: Msg 3013, Level 16, State 1, Line 2
> > RESTORE DATABASE is terminating abnormally.
> > Converting database 'my_db' from version 515 to the current version 539.
> > Database 'my_db' running the upgrade step from version 515 to version 524.
> > Database 'my_db' running the upgrade step from version 524 to version 525.
> > Database 'my_db' running the upgrade step from version 525 to version 526.
> > Database 'my_db' running the upgrade step from version 526 to version 527.
> > Database 'my_db' running the upgrade step from version 527 to version 528.
> > Database 'my_db' running the upgrade step from version 528 to version 529.
> > Database 'my_db' running the upgrade step from version 529 to version 530.
> > Database 'my_db' running the upgrade step from version 530 to version 531.
> > Database 'my_db' running the upgrade step from version 531 to version 532.
> > Database 'my_db' running the upgrade step from version 532 to version 533.
> > Database 'my_db' running the upgrade step from version 533 to version 534.
> > Database 'my_db' running the upgrade step from version 534 to version 535.
> > Error 946: Cannot open database upgrade the database to the latest version
> >
> >
> > Any idea, how I can restore w/o errors?

Error 946: Cannot open database upgrade the database to the latest

I am trying to move a database from SQL Server 70 @. 70 compatibility level t
o
SQL Server 2000 @. 70 compatibility level.
But when execute restore stmt (cmd), I keep getting the errors:
Server: Msg 9002, Level 17, State 6, Line 2
The log file for database 'my_db' is full. Back up the transaction log for
the database to free up some log space.
Server: Msg 3013, Level 16, State 1, Line 2
RESTORE DATABASE is terminating abnormally.
Converting database 'my_db' from version 515 to the current version 539.
Database 'my_db' running the upgrade step from version 515 to version 524.
Database 'my_db' running the upgrade step from version 524 to version 525.
Database 'my_db' running the upgrade step from version 525 to version 526.
Database 'my_db' running the upgrade step from version 526 to version 527.
Database 'my_db' running the upgrade step from version 527 to version 528.
Database 'my_db' running the upgrade step from version 528 to version 529.
Database 'my_db' running the upgrade step from version 529 to version 530.
Database 'my_db' running the upgrade step from version 530 to version 531.
Database 'my_db' running the upgrade step from version 531 to version 532.
Database 'my_db' running the upgrade step from version 532 to version 533.
Database 'my_db' running the upgrade step from version 533 to version 534.
Database 'my_db' running the upgrade step from version 534 to version 535.
Error 946: Cannot open database upgrade the database to the latest version
Any idea, how I can restore w/o errors?Hi,
Looks like you do not have enough room in your hard disk in which the LDF
file resides. Could you identify the drive with more space and use
RESTORE DATABASE command with MOVE options to restore the database. See
Restore with Move option in Books online.
Thanks
Hari
SQL Server MVP
"Pari" <Pari@.discussions.microsoft.com> wrote in message
news:C74D6B5B-436D-4288-ABF3-31C835CC236B@.microsoft.com...
>I am trying to move a database from SQL Server 70 @. 70 compatibility level
>to
> SQL Server 2000 @. 70 compatibility level.
> But when execute restore stmt (cmd), I keep getting the errors:
> Server: Msg 9002, Level 17, State 6, Line 2
> The log file for database 'my_db' is full. Back up the transaction log for
> the database to free up some log space.
> Server: Msg 3013, Level 16, State 1, Line 2
> RESTORE DATABASE is terminating abnormally.
> Converting database 'my_db' from version 515 to the current version 539.
> Database 'my_db' running the upgrade step from version 515 to version 524.
> Database 'my_db' running the upgrade step from version 524 to version 525.
> Database 'my_db' running the upgrade step from version 525 to version 526.
> Database 'my_db' running the upgrade step from version 526 to version 527.
> Database 'my_db' running the upgrade step from version 527 to version 528.
> Database 'my_db' running the upgrade step from version 528 to version 529.
> Database 'my_db' running the upgrade step from version 529 to version 530.
> Database 'my_db' running the upgrade step from version 530 to version 531.
> Database 'my_db' running the upgrade step from version 531 to version 532.
> Database 'my_db' running the upgrade step from version 532 to version 533.
> Database 'my_db' running the upgrade step from version 533 to version 534.
> Database 'my_db' running the upgrade step from version 534 to version 535.
> Error 946: Cannot open database upgrade the database to the latest version
>
> Any idea, how I can restore w/o errors?|||Hi
For an Upgrade, SQL Server needs space in the transaction log to work. You
don't have enough.
On the SQL Server 7.0, before you make the backup, dump the log, grow the
transaction log to at least 10% of the database size, then do the backup and
then the restore the SQL Server 2000.
Regards
Mike
"Pari" wrote:

> I am trying to move a database from SQL Server 70 @. 70 compatibility level
to
> SQL Server 2000 @. 70 compatibility level.
> But when execute restore stmt (cmd), I keep getting the errors:
> Server: Msg 9002, Level 17, State 6, Line 2
> The log file for database 'my_db' is full. Back up the transaction log for
> the database to free up some log space.
> Server: Msg 3013, Level 16, State 1, Line 2
> RESTORE DATABASE is terminating abnormally.
> Converting database 'my_db' from version 515 to the current version 539.
> Database 'my_db' running the upgrade step from version 515 to version 524.
> Database 'my_db' running the upgrade step from version 524 to version 525.
> Database 'my_db' running the upgrade step from version 525 to version 526.
> Database 'my_db' running the upgrade step from version 526 to version 527.
> Database 'my_db' running the upgrade step from version 527 to version 528.
> Database 'my_db' running the upgrade step from version 528 to version 529.
> Database 'my_db' running the upgrade step from version 529 to version 530.
> Database 'my_db' running the upgrade step from version 530 to version 531.
> Database 'my_db' running the upgrade step from version 531 to version 532.
> Database 'my_db' running the upgrade step from version 532 to version 533.
> Database 'my_db' running the upgrade step from version 533 to version 534.
> Database 'my_db' running the upgrade step from version 534 to version 535.
> Error 946: Cannot open database upgrade the database to the latest version
>
> Any idea, how I can restore w/o errors?sql

Error 945: Cannot Be Opened Because...

I'm getting this error message all of a sudden:
MS SQL-DMO (ODBC SQL State: 42000)
Error 945: Database "Database Name" cannot be opened
because some of the files could not be activated.
Can anybody help me here?
My phone number is (714)513-3038...my name is Dorsey
Richardson..
e-mail: oldmoney@.geologistics.com
Thanks in advance..
Dorsey
Dorsey,
There is a BOL topic on error 945. On the net you can find it at:
http://tinyurl.com/4wvmv
This has 4 cases that might be the cause and actions for each.
Russell Fields
"Dorsey Richardson" <anonymous@.discussions.microsoft.com> wrote in message
news:027b01c48ba8$4c2c3a30$a401280a@.phx.gbl...
> I'm getting this error message all of a sudden:
> MS SQL-DMO (ODBC SQL State: 42000)
> Error 945: Database "Database Name" cannot be opened
> because some of the files could not be activated.
> Can anybody help me here?
> My phone number is (714)513-3038...my name is Dorsey
> Richardson..
> e-mail: oldmoney@.geologistics.com
> Thanks in advance..
> Dorsey
|||Dorsey,
Russell gave you a link and four possibly actions. None of the four gave the actual error. Did you find one the solved your problem? I have the same error message as you do.
Michael Meyers

Quote:

Originally posted by Dorsey Richardson
I'm getting this error message all of a sudden:
MS SQL-DMO (ODBC SQL State: 42000)
Error 945: Database "Database Name" cannot be opened
because some of the files could not be activated.
Can anybody help me here?
My phone number is (714)513-3038...my name is Dorsey
Richardson..
e-mail: oldmoney@.geologistics.com
Thanks in advance..
Dorsey

Error 945: Cannot Be Opened Because...

I'm getting this error message all of a sudden:
MS SQL-DMO (ODBC SQL State: 42000)
Error 945: Database "Database Name" cannot be opened
because some of the files could not be activated.
Can anybody help me here?
My phone number is (714)513-3038...my name is Dorsey
Richardson..
e-mail: oldmoney@.geologistics.com
Thanks in advance..
DorseyDorsey,
There is a BOL topic on error 945. On the net you can find it at:
http://tinyurl.com/4wvmv
This has 4 cases that might be the cause and actions for each.
Russell Fields
"Dorsey Richardson" <anonymous@.discussions.microsoft.com> wrote in message
news:027b01c48ba8$4c2c3a30$a401280a@.phx.gbl...
> I'm getting this error message all of a sudden:
> MS SQL-DMO (ODBC SQL State: 42000)
> Error 945: Database "Database Name" cannot be opened
> because some of the files could not be activated.
> Can anybody help me here?
> My phone number is (714)513-3038...my name is Dorsey
> Richardson..
> e-mail: oldmoney@.geologistics.com
> Thanks in advance..
> Dorsey

Error 945: Cannot Be Opened Because...

I'm getting this error message all of a sudden:
MS SQL-DMO (ODBC SQL State: 42000)
Error 945: Database "Database Name" cannot be opened
because some of the files could not be activated.
Can anybody help me here?
My phone number is (714)513-3038...my name is Dorsey
Richardson..
e-mail: oldmoney@.geologistics.com
Thanks in advance..
DorseyDorsey,
There is a BOL topic on error 945. On the net you can find it at:
http://tinyurl.com/4wvmv
This has 4 cases that might be the cause and actions for each.
Russell Fields
"Dorsey Richardson" <anonymous@.discussions.microsoft.com> wrote in message
news:027b01c48ba8$4c2c3a30$a401280a@.phx.gbl...
> I'm getting this error message all of a sudden:
> MS SQL-DMO (ODBC SQL State: 42000)
> Error 945: Database "Database Name" cannot be opened
> because some of the files could not be activated.
> Can anybody help me here?
> My phone number is (714)513-3038...my name is Dorsey
> Richardson..
> e-mail: oldmoney@.geologistics.com
> Thanks in advance..
> Dorsey

Error 927

I recently restored a database from tape.
However when I go into SQL Enterprise Manager, I see the
recently restored database showing "loading".
I assumed that this was a good indication however it has
been loading now for the last 12 hours. The database is
about 17 gig.
Is this normal or is it safe to assume that is locked up.
What am I missing here.
Thank a million!
JamesIf you run sp_who2 do you see any RESTORE spids ? If not it may well be that
you just need to run RESTORE DATABASE dbname WITH RECOVERY to recover and
access the database.
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
<James@.discussions.microsoft.com> wrote in message
news:045601c3cfb6$8a186d40$a001280a@.phx.gbl...
> I recently restored a database from tape.
> However when I go into SQL Enterprise Manager, I see the
> recently restored database showing "loading".
> I assumed that this was a good indication however it has
> been loading now for the last 12 hours. The database is
> about 17 gig.
> Is this normal or is it safe to assume that is locked up.
> What am I missing here.
> Thank a million!
> James
>|||Hi James,
How did you restore the database? Are you using any third party tool?
Certain third party tool such as Arcserv may have option for you to
"recover" the database after the restore. If not, it will stay in
loading status until you recover the database manually
To recover the database manually, you can just run the following
statement
restore database <dbname> with recovery
Yih-Yoon Lee
<James@.discussions.microsoft.com> wrote in message news:<045601c3cfb6$8a186d40$a001280a@.phx.gbl>...
> I recently restored a database from tape.
> However when I go into SQL Enterprise Manager, I see the
> recently restored database showing "loading".
> I assumed that this was a good indication however it has
> been loading now for the last 12 hours. The database is
> about 17 gig.
> Is this normal or is it safe to assume that is locked up.
> What am I missing here.
> Thank a million!
> James

Error 927

I recently restored a database from tape.
However when I go into SQL Enterprise Manager, I see the
recently restored database showing "loading".
I assumed that this was a good indication however it has
been loading now for the last 12 hours. The database is
about 17 gig.
Is this normal or is it safe to assume that is locked up.
What am I missing here.
Thank a million!
JamesThat is really hard to tell. 12 hours sounds a bit excessive. What version
of SQL? I've restored 1-2 GB databases with SQL 7/2000 in 30 mins.
My one thought is that there may be a very long running transaction that has
to be rolled back. Do you have another backup to try restoring from? You
could always create a separate database on the same server, and force a
restore on that one.
Also, does sp_who reveal any blocks or ROLLBACK transactions? Where is
error 927 show up? When you restored, on the Advanced tab, it did say Leave
database operational, and not one of the other options where you could
restore additional backups, right?
I assume this KB article is not applicable as it is for the msdb database,
but I'll put in just in case
http://support.microsoft.com/defaul...kb;en-us;319701 (Error 927
restoring the msdb database).
Good luck.
****************************************
***************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.
This posting is provided "as is" with no warranties
and confers no rights.
****************************************
***************************
<James@.discussions.microsoft.com> wrote in message
news:045b01c3cfb6$9d4f18f0$a001280a@.phx.gbl...
quote:

> I recently restored a database from tape.
> However when I go into SQL Enterprise Manager, I see the
> recently restored database showing "loading".
> I assumed that this was a good indication however it has
> been loading now for the last 12 hours. The database is
> about 17 gig.
> Is this normal or is it safe to assume that is locked up.
> What am I missing here.
> Thank a million!
> James
>
sql

ERROR 926 dATABSE msdb CANNOT OPEN

Hi paul
we are using MS SQL Server2000 when we try to take backup we are getting
this Error " Error 926 Data base MSDB cannot Open it has been marked
suspect by recovery"
Please if you solution to solve this problem let us know.
Thanks in advance
S KaliyanSeems your msdb is corrupted. Restore msdb from your mort recent backup(s).
But do investigate why
msdb went corrupt first:
http://www.karaszi.com/SQLServer/in..._suspect_db.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"S Kaliyan" <as_kalyan@.patel-india.com> wrote in message
news:Oqi5ek3MFHA.3788@.tk2msftngp13.phx.gbl...
> Hi paul
> we are using MS SQL Server2000 when we try to take backup we are getting
> this Error " Error 926 Data base MSDB cannot Open it has been marked
> suspect by recovery"
> Please if you solution to solve this problem let us know.
> Thanks in advance
> S Kaliyan
>
>

Error 925 DB already open when i refresh current activity

I have 20 DB's on my server.
When i set a DB1 to single_user and Run DBCC ShrinkDatabase command.
Then start EM and refresh current activity I get an
Error 925: Database DB1 already open and can only have one user at a time.
I cannot see anything except (no items).
On other servers i set single user and i can view and refresh the current
activity
I don't get it why can't i view current activity on other databases?
Thanks for your helpAlex,
Try closing the connection via Query Analyzer and try again.
HTH
Jerry
"alex sadykov" <alexsadykov@.gmail.com> wrote in message
news:%239FX%23tMgGHA.5088@.TK2MSFTNGP02.phx.gbl...
>I have 20 DB's on my server.
> When i set a DB1 to single_user and Run DBCC ShrinkDatabase command.
> Then start EM and refresh current activity I get an
> Error 925: Database DB1 already open and can only have one user at a time.
>
> I cannot see anything except (no items).
> On other servers i set single user and i can view and refresh the current
> activity
> I don't get it why can't i view current activity on other databases?
> Thanks for your help
>|||Also you could try running sp_who to check the current users and processes
accessing the database.
Hope this helps
Vishal Gandhi

Error 925 DB already open when i refresh current activity

I have 20 DB's on my server.
When i set a DB1 to single_user and Run DBCC ShrinkDatabase command.
Then start EM and refresh current activity I get an
Error 925: Database DB1 already open and can only have one user at a time.
I cannot see anything except (no items).
On other servers i set single user and i can view and refresh the current
activity
I don't get it why can't i view current activity on other databases?
Thanks for your helpAlex,
Try closing the connection via Query Analyzer and try again.
HTH
Jerry
"alex sadykov" <alexsadykov@.gmail.com> wrote in message
news:%239FX%23tMgGHA.5088@.TK2MSFTNGP02.phx.gbl...
>I have 20 DB's on my server.
> When i set a DB1 to single_user and Run DBCC ShrinkDatabase command.
> Then start EM and refresh current activity I get an
> Error 925: Database DB1 already open and can only have one user at a time.
>
> I cannot see anything except (no items).
> On other servers i set single user and i can view and refresh the current
> activity
> I don't get it why can't i view current activity on other databases?
> Thanks for your help
>|||Also you could try running sp_who to check the current users and processes
accessing the database.
Hope this helps
Vishal Gandhi

Error 913: Could not find database ID119. Database may not be acti

Hi,
After restore i get this error in MSSQL server 2000 (SP4)
Error 913: Could not find database ID119. Database may not be activated or
may be in transitionw
I can not find out wath could be wrong the only thing that is diffrent in
SYSDatabases i that the version column is NULL all other databases have a
version number 539 the status is 1077936153.
We did not get any error during restore the .bak fil is from an other SQL
server SP4 and the database works there. We have moved databases before
without any problem.
Marcin S.
When and where you are getting that error?
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
news:C8A32931-5D30-4B37-9EF9-68280A564AAC@.microsoft.com...
Hi,
After restore i get this error in MSSQL server 2000 (SP4)
Error 913: Could not find database ID119. Database may not be activated or
may be in transitionw
I can not find out wath could be wrong the only thing that is diffrent in
SYSDatabases i that the version column is NULL all other databases have a
version number 539 the status is 1077936153.
We did not get any error during restore the .bak fil is from an other SQL
server SP4 and the database works there. We have moved databases before
without any problem.
Marcin S.

Error 913: Could not find database ID119. Database may not be acti

Hi,
After restore i get this error in MSSQL server 2000 (SP4)
Error 913: Could not find database ID119. Database may not be activated or
may be in transitionw
I can not find out wath could be wrong the only thing that is diffrent in
SYSDatabases i that the version column is NULL all other databases have a
version number 539 the status is 1077936153.
We did not get any error during restore the .bak fil is from an other SQL
server SP4 and the database works there. We have moved databases before
without any problem.
--
Marcin S.When and where you are getting that error?
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
news:C8A32931-5D30-4B37-9EF9-68280A564AAC@.microsoft.com...
Hi,
After restore i get this error in MSSQL server 2000 (SP4)
Error 913: Could not find database ID119. Database may not be activated or
may be in transitionw
I can not find out wath could be wrong the only thing that is diffrent in
SYSDatabases i that the version column is NULL all other databases have a
version number 539 the status is 1077936153.
We did not get any error during restore the .bak fil is from an other SQL
server SP4 and the database works there. We have moved databases before
without any problem.
Marcin S.|||I get this error all the time if i try to list tables or when i try to view
propperties, just anywhere when i try to do some thind with this databas.
I can see the database in DB list, it is in the SYSDATABASES but it is
inaccessible
BUT!
When i run : DBCC CHECKDB ('someDB') i then get
Server: Msg 911, Level 16, State 1, Line 1
Could not locate entry in sysdatabases for database 'MSSQL100011'. No entry
found with that name. Make sure that the name is entered correctly.
but a selects in SYSDATABASES says that it exists... strange
And as i wrote i can restore any database that I backup on the serbver but
when moving this from an other Working SQL server. The Restore process is
done successfull without any error.
--
Marcin S.
"Narayana Vyas Kondreddi" wrote:
> When and where you are getting that error?
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
> news:C8A32931-5D30-4B37-9EF9-68280A564AAC@.microsoft.com...
> Hi,
> After restore i get this error in MSSQL server 2000 (SP4)
> Error 913: Could not find database ID119. Database may not be activated or
> may be in transitionw
> I can not find out wath could be wrong the only thing that is diffrent in
> SYSDatabases i that the version column is NULL all other databases have a
> version number 539 the status is 1077936153.
> We did not get any error during restore the .bak fil is from an other SQL
> server SP4 and the database works there. We have moved databases before
> without any problem.
>
> --
> Marcin S.
>
>sql

Error 913: Could not find database ID119. Database may not be acti

Hi,
After restore i get this error in MSSQL server 2000 (SP4)
Error 913: Could not find database ID119. Database may not be activated or
may be in transitionw
I can not find out wath could be wrong the only thing that is diffrent in
SYSDatabases i that the version column is NULL all other databases have a
version number 539 the status is 1077936153.
We did not get any error during restore the .bak fil is from an other SQL
server SP4 and the database works there. We have moved databases before
without any problem.
Marcin S.When and where you are getting that error?
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
news:C8A32931-5D30-4B37-9EF9-68280A564AAC@.microsoft.com...
Hi,
After restore i get this error in MSSQL server 2000 (SP4)
Error 913: Could not find database ID119. Database may not be activated or
may be in transitionw
I can not find out wath could be wrong the only thing that is diffrent in
SYSDatabases i that the version column is NULL all other databases have a
version number 539 the status is 1077936153.
We did not get any error during restore the .bak fil is from an other SQL
server SP4 and the database works there. We have moved databases before
without any problem.
Marcin S.

eRROR 913

DATABASE MAY NOT BE ACTIVATED OR MAY BE IN TRNSITION
aLTIN,
Without any more information, this is hard, but the following article shows
what has bit me in the past.
http://support.microsoft.com/default...b;en-us;316541 for database
id 101
http://support.microsoft.com/default...b;en-us;834688 for database
id 102
Also, from the BOL on error 913: http://tinyurl.com/4zy7z
Russell Fields
"aLTIN" <anonymous@.discussions.microsoft.com> wrote in message
news:360001c47184$3401a000$a501280a@.phx.gbl...
> DATABASE MAY NOT BE ACTIVATED OR MAY BE IN TRNSITION

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

eRROR 913

DATABASE MAY NOT BE ACTIVATED OR MAY BE IN TRNSITIONaLTIN,
Without any more information, this is hard, but the following article shows
what has bit me in the past.
http://support.microsoft.com/default.aspx?scid=kb;en-us;316541 for database
id 101
http://support.microsoft.com/default.aspx?scid=kb;en-us;834688 for database
id 102
Also, from the BOL on error 913: http://tinyurl.com/4zy7z
Russell Fields
"aLTIN" <anonymous@.discussions.microsoft.com> wrote in message
news:360001c47184$3401a000$a501280a@.phx.gbl...
> DATABASE MAY NOT BE ACTIVATED OR MAY BE IN TRNSITION

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

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

eRROR 913

DATABASE MAY NOT BE ACTIVATED OR MAY BE IN TRNSITIONaLTIN,
Without any more information, this is hard, but the following article shows
what has bit me in the past.
http://support.microsoft.com/defaul...kb;en-us;316541 for database
id 101
http://support.microsoft.com/defaul...kb;en-us;834688 for database
id 102
Also, from the BOL on error 913: http://tinyurl.com/4zy7z
Russell Fields
"aLTIN" <anonymous@.discussions.microsoft.com> wrote in message
news:360001c47184$3401a000$a501280a@.phx.gbl...
> DATABASE MAY NOT BE ACTIVATED OR MAY BE IN TRNSITION

Tuesday, March 27, 2012

Error 911

When I try to connect to a particular database using my client/server
application I receive ERROR 911 - Server rejected the connection;
Access to the selected database has been denied.
I tried changing the owner using sp_changedbowner to a value of a
database that I can connect to but this didn't work.
I did ensure that the SQL account used to connect has permission to
the database in Enterprise Manager
I did create this database using DTS. However I can connect to the
database that was the source db w/o a problem.
ThanksHi,
Can you change the default database for this login to the database you are
trying to access. I feel that when ever you login it is going
to the Master database.
How to change this
sp_defaultdb 'UR Login name accessed by application','the database you are
trying to connect'
If it still gives error, then assign 'DB_OWNER' dataase role and try
connecting.
THanks
Hari
MCDBA
"Jim" <jromano@.phs-us.com> wrote in message
news:e1e1a687.0403261629.e32d311@.posting.google.com...
> When I try to connect to a particular database using my client/server
> application I receive ERROR 911 - Server rejected the connection;
> Access to the selected database has been denied.
> I tried changing the owner using sp_changedbowner to a value of a
> database that I can connect to but this didn't work.
> I did ensure that the SQL account used to connect has permission to
> the database in Enterprise Manager
> I did create this database using DTS. However I can connect to the
> database that was the source db w/o a problem.
> Thanks

Error 9104

Why does the server return Error 9104 "auto statistics internal"? I can't find an error description in BOL, MSDN or through a groups/forum search either.

We running Sql Server 2005 (no sp yet) on Windows 2003 server.

Thanks

Do you have the associated state number for this error? It is number like in the range of 1-255 in general. It would be helpful in identifying the cause.|||

Hi Mark,

I only have the severity level, 16. I don't capture the state in my error trace.

We migrated to 2005 in mid-March and this error has been returned twice.

|||

Error 9104 is used internally for control flow. It is never surfaced through T-SQL. I assume you ran a trace to capture errors.

9104 essentially means that auto statistics failed for some reason (deadlock, resource crunch, ...). Since the engine can go on without auto-created or auto-refreshed statistics, the engine doesn't surface this error.

Peter Zabback

SQL Server Optimizer Development

error 9004, severity 21, state 10

saw one of my database went suspect, I tried to load a restore from the backup, but this was going on for ever. I cancelled out, deleted the suspect database. Created a new database and tried to restore from the old backup, but this was going on for ever. It will not restore. I cannot stop and start mssql service on this server as it is production. what else can I do.Q1 On trying to restore from the old backup, this goes on forever. I cannot stop and start mssql service on this server as it is production. What else can I do?

A1 If the issue amounts to the Db remaining in 'Loading' status "forever"; it may simply be that the DB has not been recovered following the restore.

To test this possibility, one would execute a statement similar to the following:

Restore DataBase [DBName] With Recovery

Question I
Can the DB be restored to a development server successfully using the "old backup"?sql

Error 9004 attaching a database

I've been given a database backup in the form of an .mdf file, a bunch
of .ndf files, and a .log file. When I try to attach the .mdf file in
Server Management Studio, I get error 9004, An error occurred while
processing the log.
Any suggestions?
Phil Hibbs.Phil,
Kevin Farlee's answer has helped a couple of people with your problem.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=598396&SiteID=1
RLF
"PhilHibbs" <snarks@.gmail.com> wrote in message
news:1193140510.353843.250240@.y27g2000pre.googlegroups.com...
> I've been given a database backup in the form of an .mdf file, a bunch
> of .ndf files, and a .log file. When I try to attach the .mdf file in
> Server Management Studio, I get error 9004, An error occurred while
> processing the log.
> Any suggestions?
> Phil Hibbs.
>|||On 23 Oct, 13:31, "Russell Fields" <russellfie...@.nomail.com> wrote:
> Kevin Farlee's answer has helped a couple of people with your problem.
> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=598396&SiteID=1
Hm, looked promising, but when I try to "bring online" the database
with the files replaced, I get a load of errors in this form:
E:\data\data_file_09.ndf is not a primary database file
I have a .mdf file and 26 .ndf files, it looks like the creation of
the empty database is creating these files in a different way to the
original database.
Phil Hibbs.|||Phil,
Did you first create the 26 ndf files in your database to be replaced before
trying to copy the files into place?
RLF
"PhilHibbs" <snarks@.gmail.com> wrote in message
news:1193148065.531336.193770@.e34g2000pro.googlegroups.com...
> On 23 Oct, 13:31, "Russell Fields" <russellfie...@.nomail.com> wrote:
>> Kevin Farlee's answer has helped a couple of people with your problem.
>> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=598396&SiteID=1
> Hm, looked promising, but when I try to "bring online" the database
> with the files replaced, I get a load of errors in this form:
> E:\data\data_file_09.ndf is not a primary database file
> I have a .mdf file and 26 .ndf files, it looks like the creation of
> the empty database is creating these files in a different way to the
> original database.
> Phil Hibbs.
>|||On 23 Oct, 20:15, "Russell Fields" <russellfie...@.nomail.com> wrote:
> Did you first create the 26 ndf files in your database to be replaced before
> trying to copy the files into place?
Yep. I made a big CREATE DATABASE statement with the .mdf and all
the .ndf files specified in it.
Phil Hibbs.|||On 23 Oct, 20:15, "Russell Fields" <russellfie...@.nomail.com> wrote:
> Did you first create the 26 ndf files in your database to be replaced before
> trying to copy the files into place?
Yep. I made a big CREATE DATABASE statement with the .mdf and all
the .ndf files specified in it.
Phil Hibbs.|||Phil,
I understand that you are using SQL Server 2005, since you mention
Management Studio. I have tested and not been able to duplicate your
problem. When you use SSMS to do the attach, have you pressed the Script
command at the top of the panel. This will provide an exact script of the
commands to be run. If you do that, perhaps you will see something helpful.
Or, you can post it here for review.
Obviously something is different between our setups. I am running SQL
Server 2005 SP2. Are you also running SP2? I ask because SP2 fixed some
Management Studio problems and you should update to it (plus some hotfixes)
if you have not done so.
This describe my patch level:
http://blogs.msdn.com/psssql/archive/2007/04/06/post-sql-server-2005-service-pack-2-sp2-fixes-explained.aspx
For more recent fixes, see also: http://support.microsoft.com/kb/937137/LN/
RLF
"PhilHibbs" <snarks@.gmail.com> wrote in message
news:1193222031.764752.35650@.v29g2000prd.googlegroups.com...
> On 23 Oct, 20:15, "Russell Fields" <russellfie...@.nomail.com> wrote:
>> Did you first create the 26 ndf files in your database to be replaced
>> before
>> trying to copy the files into place?
> Yep. I made a big CREATE DATABASE statement with the .mdf and all
> the .ndf files specified in it.
> Phil Hibbs.
>|||On 25 Oct, 17:34, "Russell Fields" <russellfie...@.nomail.com> wrote:
> I have tested and not been able to duplicate your
> problem.
I suspect that is because you don't have the same .mdf and .ndf
and .log files that I have.
Phil Hibbs.|||Phil, No doubt about that. Sorry this did not help. - RLF
"PhilHibbs" <snarks@.gmail.com> wrote in message
news:1193761341.010344.78000@.k79g2000hse.googlegroups.com...
> On 25 Oct, 17:34, "Russell Fields" <russellfie...@.nomail.com> wrote:
>> I have tested and not been able to duplicate your
>> problem.
> I suspect that is because you don't have the same .mdf and .ndf
> and .log files that I have.
> Phil Hibbs.
>

Error 9003 on SQL Server 2000

Hi guys,

I am having a little trouble with a SQL Server 2000 database and I would like some help. After failure and recovery of a hard disk my database is marked as suspect and I cannot get it to work again. I have tryed a few things such as copying the database and the log files to another computer and then running the attach command which returns the following "Error 9003: The LSN(12:32:1) passed to log scan in database 'dbName' is invalid.".

Upon getting this error I have tryed with failure attaching a single file, I have also tryed to create a new database with the same name in the same location as the original, then replacing the new files with my old ones, restarting the SQL Server and getting the database into Emergency Mode hopping to extract the data through DTS or BCP Utility, but I cannot access the objects nor the data.

I have also tryed to create a new database with the same name and replace only the ".mdf" file with my old one, but failed.

I would be gratefull for any help.

Manuel.pereira@.ricmade.ptit looks quite nasty, I wonder if it's possible to survive severe drive failure without performing full restore of db. But couple of thoughts: How many log files were originally in your db?, all other databases (system) are ok after drive recovery? By setting your db into emergency mode, you mean setting status column master..sysdatabases to -32768? Didn't work? After drive recovery, what were error messages in SQL Server log after startup concerning db in question? mojza|||Hi Mojza,

I only have one log file on my database, unfortunately I have another 2 databases with the same error. When I say that I set the database into emergency mode I mean setting the status column of master.sysdatabases to -32768, but this did not work, so I suspect that the .mdf file is damaged.

After I started up SQL I did get the following error messages.

Starting up database 'rjp'.
Error: 9003, Severity: 20, State: 6
The LSN (18611:16:1) passed to log scan in database 'rjp' is invalid.|||According to MS documentation, 9003 error should mean that your mdf and ldf files are out of syn. And the solution is usually attaching single file using sp_attach_db or sp_attach_single_file_db Sps to let SQL Server create a new log file for you. But you've said it didn't work. If it's not possible to put db into emergency mode, I guess there's corruption somewhere in data file header (just my opinion) and you have only two options left: go back to your last good backups or try to contact MS Support with uncertain results.
mojza

just for the sake of completness if you run dbcc dbrecover ('your_db')
command, the result is probably the same as during server startup?|||I get the same error message when I run the command dbcc dbrecover. Also when I try to attach a single file mdf, I get the error message 1813: Could not open new database 'db_name'. Create Database is Aborted. Device activation error, the physical file name 'log path' may be incorrect.

In general you are able to execute this comand and a log file will be created for you, but not with this database.|||The net is that one should not rely on SQL Server providing a silver bullet to recover from hard disk failures. It is a risky proposition.

Instead, plan for the failures by implementing RAID, Backups, Clusters, Log Shipping, or any other tools you are provided.

Expect and be prepared for failures. Understand your options, propose at least three options to the business unit, and let them decide. DO NOT MAKE THAT CHOICE FOR THEM or you will be chasing your tail for a long, long time.

In a land and time far, far away, where I claim client-server was invented, we had business users giving us servers for which we were accountable for providing health and welfare. Before the next budget cycle, I proposed to our GM, who got it approved by The Man, to have the business units budget for MB of data vs. hardware - we buy the hardware and we'll ensure recovery based on the following:
The cocktail weenies option was a database for which you can afford to lose a day's worth of data and accept a day of downtime - it cost $1 per MB.
To get no more than an hour loss of data and to be up w/in 4 hours of failure, that costs $2 per MB and was called the shrimp option.
And the caviar option was no more than 5 minutes data loss and you're up and running w/in 20 minutes. That'll be $10 per MB, thank you very much.

I let them choose, they'd transfer their budgets, and everyone lived happily ever after. For example, the DBAs on my team who had to go through the trouble of spending weekends ensuring the caviar option worked would receive a weekend, all expenses paid vacation, for them and their significant other following the harrowing experience. We spent the cavair cash in a way that made our users happier.

This also gave us the opportunity to consolidate our servers by about 50%. So, we bought less hardware and had happier customers.

Many stories to tell, some of them true, like running our most intense application on Beta NT and Beta SQL Server (their ship dates were synchronized) and delivering for our caviar clients. We hid beer under the floor tiles in the data center as a means to get us through some of our worse nights. Nothing like doing a Delete after sipping on a few Red Hooks.

The End.|||I'll assume that .MDF files are OK, so if that's the case, - there are 3 ways that accomplish the same thing (BTW, it does not matter how many LDF files there were originally, sp_attach_single_file_db will create only 1 new LDF file). For all three you need to delete or rename the original LDF files before you proceed (I recommend to move them to a safe location if none of the three methods will work). All three methods require the database to be in suspect mode, so don't mix the steps, and if you already changed the status, - make sure you pick up from there:

1. sp_configure 'allow', 1
reconfigure with override
go
update master.dbo.sysdatabases set status = status | 32768 where name = '<your_db>'
go
dbcc rebuild_log('<your_db>','c:\<your_db_log>.ldf')
go
alter database <your_db> set multi_user
go
sp_configure 'allow', 0
reconfigure with override
go

2. dbcc detachdb(<your_db>)
go
create database [<your_db>] on (filename='c:\<your_db>.mdf') for attach
go
if exists (select 1 from master.dbo.sysobjects where name = 'sp_removedbreplication') exec sp_removedbreplication '<your_db>'
go

3. ...Well, after all this - the third is the lazy man approach. SQL is actually trying to be nice to you, even if you put it to run on something that you shouldn't have ;) In short, after you renamed/deleted/moved the log devices while the databases were showing to be in Suspect mode, - just restart the service, and enjoy the show :D|||Do you think it's possible that .mdf file is ok and attach db or attach single file doesn't work? Have you come across this situation? I just try to collect experience from more knowledgable ones. mojza|||I'll assume that .MDF files are OK, so if that's the case, - there are 3 ways that accomplish the same thing (BTW, it does not matter how many LDF files there were originally, sp_attach_single_file_db will create only 1 new LDF file). For all three you need to delete or rename the original LDF files before you proceed (I recommend to move them to a safe location if none of the three methods will work). All three methods require the database to be in suspect mode, so don't mix the steps, and if you already changed the status, - make sure you pick up from there:

1. sp_configure 'allow', 1
reconfigure with override
go
update master.dbo.sysdatabases set status = status | 32768 where name = '<your_db>'
go
dbcc rebuild_log('<your_db>','c:\<your_db_log>.ldf')
go
alter database <your_db> set multi_user
go
sp_configure 'allow', 0
reconfigure with override
go

2. dbcc detachdb(<your_db>)
go
create database [<your_db>] on (filename='c:\<your_db>.mdf') for attach
go
if exists (select 1 from master.dbo.sysobjects where name = 'sp_removedbreplication') exec sp_removedbreplication '<your_db>'
go

3. ...Well, after all this - the third is the lazy man approach. SQL is actually trying to be nice to you, even if you put it to run on something that you shouldn't have ;) In short, after you renamed/deleted/moved the log devices while the databases were showing to be in Suspect mode, - just restart the service, and enjoy the show :D
I have tryed all three methods but it still does not work. I get the following error when I run the command dbcc rebuild_log

Server: Msg 3624, Level 20, State 1, Line 1

Location: filemgr.cpp:1890
Expression: fcb->GetSize () < fileSize
SPID: 52
Process ID: 3472

Connection Broken

I believe that the mdf file is damaged and that is why I cannot attach it as a single file. Do you know if there is any tool to export the data from the mdf file without being attached to SQL?