|
Home > Archive > microsoft.public.sqlserver.server > November 2002 > upgade from 6.5 to 7 error
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
upgade from 6.5 to 7 error
|
|
| Letkeman 2002-11-20, 3:23 pm |
| When trying to upgrade a MS SQL 6.5 database to MS SQL 7.0 I get the
following message
SQL Server Upgrade Wizard:
One or more databases have a status of 32 (crashed) or 256 (suspect), so
this wizard can not continue. Please 'select name, status from sysdatabases'
to view the offending databases and correct the problem to continue.
When I run select name, status from sysdatabases I get these results:
Master 8
Model 0
Msdb 8
Northwind 12
Plat 0
Pubs 8
Tempdb 12
The database that I am trying database that I am trying to Import is called
PLAT from the Platypus Billing system
http://www.boardtown.com/platypus/default.asp
Does it matter if I already have a database object setup in my MS SQL 7.0
system with the name plat?
My MS SQL 6.5 system is a WinNT 4SP6 system and my MS SQL 7.0 system is
Win2000 SP3 system.
Can someone help me with this problem?
Thanks,
Pete
This message has been posted to the following news groups:
Microsoft.public.sqlserver.server
Microsoft.public.sqlserver.setup
| |
| Tibor Karaszi 2002-11-21, 6:23 am |
| According to your query, non of the databases are suspect or crashed. I'd contact MS Support on
this. And, of course, consider upgrading to SQL Server 2000 instead of 7.0.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
"Letkeman" <letkemanp@msn.com> wrote in message news:uBdlPKNkCHA.1584@tkmsftngp11...
> When trying to upgrade a MS SQL 6.5 database to MS SQL 7.0 I get the
> following message
>
>
> SQL Server Upgrade Wizard:
>
> One or more databases have a status of 32 (crashed) or 256 (suspect), so
> this wizard can not continue. Please 'select name, status from sysdatabases'
> to view the offending databases and correct the problem to continue.
>
>
>
> When I run select name, status from sysdatabases I get these results:
>
>
>
> Master 8
>
> Model 0
>
> Msdb 8
>
> Northwind 12
>
> Plat 0
>
> Pubs 8
>
> Tempdb 12
>
>
>
> The database that I am trying database that I am trying to Import is called
> PLAT from the Platypus Billing system
> http://www.boardtown.com/platypus/default.asp
>
> Does it matter if I already have a database object setup in my MS SQL 7.0
> system with the name plat?
>
> My MS SQL 6.5 system is a WinNT 4SP6 system and my MS SQL 7.0 system is
> Win2000 SP3 system.
>
>
>
> Can someone help me with this problem?
>
>
>
> Thanks,
>
> Pete
>
>
>
> This message has been posted to the following news groups:
>
> Microsoft.public.sqlserver.server
>
> Microsoft.public.sqlserver.setup
>
>
|
|
|
|
|