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 2809

What is error 2809?
We are running SQL Server 2000 Enterprise on a W2K cluster.
I have been seeing Error 1203 in a profile trace. I successfully applied
service pack 3a and Error 1203 has stopped, but I still see error 2809
periodically.
Also, when I run "select @.@.version", the response says '...build 2195:
Service Pack 2' and doesn't mention service pack 3a. Is this normal?
Thanks
Bill
Hi
Build 2195 is Windows 2000. The SP2 reference is Windows 2000 SP2. That is
the Os information.
When running select @.@.version, the values after 8.00.xxxx are what determine
the SQL Server version
SP3a = 8.00.760
If I were you, get onto Windows 2000 SP4 asap.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"bill" <belgie@.datamti.com> wrote in message
news:OnTnOd#yEHA.3548@.TK2MSFTNGP09.phx.gbl...
> What is error 2809?
> We are running SQL Server 2000 Enterprise on a W2K cluster.
> I have been seeing Error 1203 in a profile trace. I successfully applied
> service pack 3a and Error 1203 has stopped, but I still see error 2809
> periodically.
> Also, when I run "select @.@.version", the response says '...build 2195:
> Service Pack 2' and doesn't mention service pack 3a. Is this normal?
> Thanks
> Bill
>
>
|||I see. Thanks.
Do you know what the Error 2809 is? I can't find much about it.
"bill" <belgie@.datamti.com> wrote in message
news:OnTnOd%23yEHA.3548@.TK2MSFTNGP09.phx.gbl...
> What is error 2809?
> We are running SQL Server 2000 Enterprise on a W2K cluster.
> I have been seeing Error 1203 in a profile trace. I successfully applied
> service pack 3a and Error 1203 has stopped, but I still see error 2809
> periodically.
> Also, when I run "select @.@.version", the response says '...build 2195:
> Service Pack 2' and doesn't mention service pack 3a. Is this normal?
> Thanks
> Bill
>
>
|||Hi
Not see that one around. Do you always get it on a specific query?
2809, Sev 16.
The request for %S_MSG '%.*ls' failed because '%.*ls' is a %S_MSG object.
Not much out there about it. If you can figure out in what scenarios you get
it, PSS might be able to help
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"bill" <belgie@.datamti.com> wrote in message
news:eHAkDB$yEHA.3844@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> I see. Thanks.
> Do you know what the Error 2809 is? I can't find much about it.
>
> "bill" <belgie@.datamti.com> wrote in message
> news:OnTnOd%23yEHA.3548@.TK2MSFTNGP09.phx.gbl...
applied
>
|||It is what pretty much what you see in the full description:
A request for an object of the wrong type - such as trying
to execute a view or a table instead of a stored procedures.
I've generally seen it with ADO apps that have some problems
with OpenReecordset commands - usually when table names are
used for the data source instead of a select statement.
-Sue
On Tue, 16 Nov 2004 10:23:41 -0500, "bill"
<belgie@.datamti.com> wrote:

>I see. Thanks.
>Do you know what the Error 2809 is? I can't find much about it.
>
>"bill" <belgie@.datamti.com> wrote in message
>news:OnTnOd%23yEHA.3548@.TK2MSFTNGP09.phx.gbl...
>
|||OK, I think you're right - the database is sometimes used by some MSAccess
ADPs and when the code uses a DLOOKUP function on a table, it looks like it
tries to execute the table as if it was a stored procedure, and I see the
error.
Thanks for your help.
-Bill
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:nh7kp05nnnh65v81qbit3iae04sa9dtd38@.4ax.com... [vbcol=seagreen]
> It is what pretty much what you see in the full description:
> A request for an object of the wrong type - such as trying
> to execute a view or a table instead of a stored procedures.
> I've generally seen it with ADO apps that have some problems
> with OpenReecordset commands - usually when table names are
> used for the data source instead of a select statement.
> -Sue
> On Tue, 16 Nov 2004 10:23:41 -0500, "bill"
> <belgie@.datamti.com> wrote:
applied
>

Error 2809

What is error 2809?
We are running SQL Server 2000 Enterprise on a W2K cluster.
I have been seeing Error 1203 in a profile trace. I successfully applied
service pack 3a and Error 1203 has stopped, but I still see error 2809
periodically.
Also, when I run "select @.@.version", the response says '...build 2195:
Service Pack 2' and doesn't mention service pack 3a. Is this normal?
Thanks
BillHi
Build 2195 is Windows 2000. The SP2 reference is Windows 2000 SP2. That is
the Os information.
When running select @.@.version, the values after 8.00.xxxx are what determine
the SQL Server version
SP3a = 8.00.760
If I were you, get onto Windows 2000 SP4 asap.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"bill" <belgie@.datamti.com> wrote in message
news:OnTnOd#yEHA.3548@.TK2MSFTNGP09.phx.gbl...
> What is error 2809?
> We are running SQL Server 2000 Enterprise on a W2K cluster.
> I have been seeing Error 1203 in a profile trace. I successfully applied
> service pack 3a and Error 1203 has stopped, but I still see error 2809
> periodically.
> Also, when I run "select @.@.version", the response says '...build 2195:
> Service Pack 2' and doesn't mention service pack 3a. Is this normal?
> Thanks
> Bill
>
>|||I see. Thanks.
Do you know what the Error 2809 is? I can't find much about it.
"bill" <belgie@.datamti.com> wrote in message
news:OnTnOd%23yEHA.3548@.TK2MSFTNGP09.phx.gbl...
> What is error 2809?
> We are running SQL Server 2000 Enterprise on a W2K cluster.
> I have been seeing Error 1203 in a profile trace. I successfully applied
> service pack 3a and Error 1203 has stopped, but I still see error 2809
> periodically.
> Also, when I run "select @.@.version", the response says '...build 2195:
> Service Pack 2' and doesn't mention service pack 3a. Is this normal?
> Thanks
> Bill
>
>|||Hi
Not see that one around. Do you always get it on a specific query?
2809, Sev 16.
The request for %S_MSG '%.*ls' failed because '%.*ls' is a %S_MSG object.
Not much out there about it. If you can figure out in what scenarios you get
it, PSS might be able to help
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"bill" <belgie@.datamti.com> wrote in message
news:eHAkDB$yEHA.3844@.TK2MSFTNGP12.phx.gbl...
> I see. Thanks.
> Do you know what the Error 2809 is? I can't find much about it.
>
> "bill" <belgie@.datamti.com> wrote in message
> news:OnTnOd%23yEHA.3548@.TK2MSFTNGP09.phx.gbl...
applied[vbcol=seagreen]
>|||It is what pretty much what you see in the full description:
A request for an object of the wrong type - such as trying
to execute a view or a table instead of a stored procedures.
I've generally seen it with ADO apps that have some problems
with OpenReecordset commands - usually when table names are
used for the data source instead of a select statement.
-Sue
On Tue, 16 Nov 2004 10:23:41 -0500, "bill"
<belgie@.datamti.com> wrote:

>I see. Thanks.
>Do you know what the Error 2809 is? I can't find much about it.
>
>"bill" <belgie@.datamti.com> wrote in message
>news:OnTnOd%23yEHA.3548@.TK2MSFTNGP09.phx.gbl...
>|||OK, I think you're right - the database is sometimes used by some MSAccess
ADPs and when the code uses a DLOOKUP function on a table, it looks like it
tries to execute the table as if it was a stored procedure, and I see the
error.
Thanks for your help.
-Bill
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:nh7kp05nnnh65v81qbit3iae04sa9dtd38@.
4ax.com...
> It is what pretty much what you see in the full description:
> A request for an object of the wrong type - such as trying
> to execute a view or a table instead of a stored procedures.
> I've generally seen it with ADO apps that have some problems
> with OpenReecordset commands - usually when table names are
> used for the data source instead of a select statement.
> -Sue
> On Tue, 16 Nov 2004 10:23:41 -0500, "bill"
> <belgie@.datamti.com> wrote:
>
applied[vbcol=seagreen]
>

Error 2809

What is error 2809?
We are running SQL Server 2000 Enterprise on a W2K cluster.
I have been seeing Error 1203 in a profile trace. I successfully applied
service pack 3a and Error 1203 has stopped, but I still see error 2809
periodically.
Also, when I run "select @.@.version", the response says '...build 2195:
Service Pack 2' and doesn't mention service pack 3a. Is this normal?
Thanks
BillHi
Build 2195 is Windows 2000. The SP2 reference is Windows 2000 SP2. That is
the Os information.
When running select @.@.version, the values after 8.00.xxxx are what determine
the SQL Server version
SP3a = 8.00.760
If I were you, get onto Windows 2000 SP4 asap.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"bill" <belgie@.datamti.com> wrote in message
news:OnTnOd#yEHA.3548@.TK2MSFTNGP09.phx.gbl...
> What is error 2809?
> We are running SQL Server 2000 Enterprise on a W2K cluster.
> I have been seeing Error 1203 in a profile trace. I successfully applied
> service pack 3a and Error 1203 has stopped, but I still see error 2809
> periodically.
> Also, when I run "select @.@.version", the response says '...build 2195:
> Service Pack 2' and doesn't mention service pack 3a. Is this normal?
> Thanks
> Bill
>
>|||I see. Thanks.
Do you know what the Error 2809 is? I can't find much about it.
"bill" <belgie@.datamti.com> wrote in message
news:OnTnOd%23yEHA.3548@.TK2MSFTNGP09.phx.gbl...
> What is error 2809?
> We are running SQL Server 2000 Enterprise on a W2K cluster.
> I have been seeing Error 1203 in a profile trace. I successfully applied
> service pack 3a and Error 1203 has stopped, but I still see error 2809
> periodically.
> Also, when I run "select @.@.version", the response says '...build 2195:
> Service Pack 2' and doesn't mention service pack 3a. Is this normal?
> Thanks
> Bill
>
>|||Hi
Not see that one around. Do you always get it on a specific query?
2809, Sev 16.
The request for %S_MSG '%.*ls' failed because '%.*ls' is a %S_MSG object.
Not much out there about it. If you can figure out in what scenarios you get
it, PSS might be able to help
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"bill" <belgie@.datamti.com> wrote in message
news:eHAkDB$yEHA.3844@.TK2MSFTNGP12.phx.gbl...
> I see. Thanks.
> Do you know what the Error 2809 is? I can't find much about it.
>
> "bill" <belgie@.datamti.com> wrote in message
> news:OnTnOd%23yEHA.3548@.TK2MSFTNGP09.phx.gbl...
> > What is error 2809?
> >
> > We are running SQL Server 2000 Enterprise on a W2K cluster.
> >
> > I have been seeing Error 1203 in a profile trace. I successfully
applied
> > service pack 3a and Error 1203 has stopped, but I still see error 2809
> > periodically.
> >
> > Also, when I run "select @.@.version", the response says '...build 2195:
> > Service Pack 2' and doesn't mention service pack 3a. Is this normal?
> >
> > Thanks
> > Bill
> >
> >
> >
> >
>|||It is what pretty much what you see in the full description:
A request for an object of the wrong type - such as trying
to execute a view or a table instead of a stored procedures.
I've generally seen it with ADO apps that have some problems
with OpenReecordset commands - usually when table names are
used for the data source instead of a select statement.
-Sue
On Tue, 16 Nov 2004 10:23:41 -0500, "bill"
<belgie@.datamti.com> wrote:
>I see. Thanks.
>Do you know what the Error 2809 is? I can't find much about it.
>
>"bill" <belgie@.datamti.com> wrote in message
>news:OnTnOd%23yEHA.3548@.TK2MSFTNGP09.phx.gbl...
>> What is error 2809?
>> We are running SQL Server 2000 Enterprise on a W2K cluster.
>> I have been seeing Error 1203 in a profile trace. I successfully applied
>> service pack 3a and Error 1203 has stopped, but I still see error 2809
>> periodically.
>> Also, when I run "select @.@.version", the response says '...build 2195:
>> Service Pack 2' and doesn't mention service pack 3a. Is this normal?
>> Thanks
>> Bill
>>
>>
>|||OK, I think you're right - the database is sometimes used by some MSAccess
ADPs and when the code uses a DLOOKUP function on a table, it looks like it
tries to execute the table as if it was a stored procedure, and I see the
error.
Thanks for your help.
-Bill
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:nh7kp05nnnh65v81qbit3iae04sa9dtd38@.4ax.com...
> It is what pretty much what you see in the full description:
> A request for an object of the wrong type - such as trying
> to execute a view or a table instead of a stored procedures.
> I've generally seen it with ADO apps that have some problems
> with OpenReecordset commands - usually when table names are
> used for the data source instead of a select statement.
> -Sue
> On Tue, 16 Nov 2004 10:23:41 -0500, "bill"
> <belgie@.datamti.com> wrote:
> >I see. Thanks.
> >Do you know what the Error 2809 is? I can't find much about it.
> >
> >
> >
> >"bill" <belgie@.datamti.com> wrote in message
> >news:OnTnOd%23yEHA.3548@.TK2MSFTNGP09.phx.gbl...
> >> What is error 2809?
> >>
> >> We are running SQL Server 2000 Enterprise on a W2K cluster.
> >>
> >> I have been seeing Error 1203 in a profile trace. I successfully
applied
> >> service pack 3a and Error 1203 has stopped, but I still see error 2809
> >> periodically.
> >>
> >> Also, when I run "select @.@.version", the response says '...build 2195:
> >> Service Pack 2' and doesn't mention service pack 3a. Is this normal?
> >>
> >> Thanks
> >> Bill
> >>
> >>
> >>
> >>
> >
>