|
Home > Archive > MS SQL Server > May 2005 > How to reset the states from suspected
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 |
How to reset the states from suspected
|
|
|
| Hi,
I have a SQL 6.5 which was corrupted and I have reinstalled both Windows NT
and SQL 6.5.
After installation, I issue the command disk reinit and disk refit to
restore the database to the server. However, the database is marked as
suspected. How can I reset the states.
I get the following message form the error log
More than 32 entries required to build the logical-virtual translzation
table for database 'Test'. The database is too fragmented.
Thank you.
Charles
| |
| Uri Dimant 2005-05-04, 3:23 am |
| Pro
Good stuff
http://www.karaszi.com/sqlserver/ i...t
_db.asp
"Pro" <nospam@nospam.net> wrote in message
news:eE%23c83GUFHA.612@TK2MSFTNGP12.phx.gbl...
> Hi,
>
> I have a SQL 6.5 which was corrupted and I have reinstalled both Windows
NT
> and SQL 6.5.
> After installation, I issue the command disk reinit and disk refit to
> restore the database to the server. However, the database is marked as
> suspected. How can I reset the states.
>
> I get the following message form the error log
> More than 32 entries required to build the logical-virtual translzation
> table for database 'Test'. The database is too fragmented.
>
> Thank you.
> Charles
>
>
| |
| Tibor Karaszi 2005-05-04, 3:23 am |
| Have you considered doing a restore of your backup? If that is not an option, I'd call MS Support on
this.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
"Pro" <nospam@nospam.net> wrote in message news:eE%23c83GUFHA.612@TK2MSFTNGP12.phx.gbl...
> Hi,
>
> I have a SQL 6.5 which was corrupted and I have reinstalled both Windows NT and SQL 6.5.
> After installation, I issue the command disk reinit and disk refit to restore the database to the
> server. However, the database is marked as suspected. How can I reset the states.
>
> I get the following message form the error log
> More than 32 entries required to build the logical-virtual translzation table for database 'Test'.
> The database is too fragmented.
>
> Thank you.
> Charles
>
| |
| Hari Prasad 2005-05-05, 3:23 am |
| Hi,
Best method is as Tiber pointed out restore (load) the database from a dump
file. If dump is not availablre try below steps, Provide you have all the
DAT files (Including system databases)
1. Copy the SQL 6.5 DAT files (data and Log dat files including system
database) to a safe location (filder)
2. Install SQL 6.5 with same directory structutre as old and apply the same
service pack.
3. Stop SQL Server and copy the DAT files taken step-1
4. Ensure that the DAT files are copied to the same folder as old (Ensure
that you copy Master, Model, MSDB).
5. STart the MSSQl server service and see that all the database are up.
If you have issues in starting try starting the MSSQL Server service in
Mimimal mode using "-c -f " parameters
and trouble shoot.
Thanks
Hari
SQL Server MVP
"Pro" <nospam@nospam.net> wrote in message
news:eE%23c83GUFHA.612@TK2MSFTNGP12.phx.gbl...
> Hi,
>
> I have a SQL 6.5 which was corrupted and I have reinstalled both Windows
NT
> and SQL 6.5.
> After installation, I issue the command disk reinit and disk refit to
> restore the database to the server. However, the database is marked as
> suspected. How can I reset the states.
>
> I get the following message form the error log
> More than 32 entries required to build the logical-virtual translzation
> table for database 'Test'. The database is too fragmented.
>
> Thank you.
> Charles
>
>
| |
|
| Hi,
Thank you. I find I need one more step 2.5 create the Database Device and
database which size is extractly the same of the old database.
Thank you for help.
"Hari Prasad" < hari_prasad_k@hotmai
l.com> wrote in message
news:OxP2P0RUFHA.3188@TK2MSFTNGP09.phx.gbl...
> Hi,
>
> Best method is as Tiber pointed out restore (load) the database from a
> dump
> file. If dump is not availablre try below steps, Provide you have all the
> DAT files (Including system databases)
>
> 1. Copy the SQL 6.5 DAT files (data and Log dat files including system
> database) to a safe location (filder)
> 2. Install SQL 6.5 with same directory structutre as old and apply the
> same
> service pack.
> 3. Stop SQL Server and copy the DAT files taken step-1
> 4. Ensure that the DAT files are copied to the same folder as old (Ensure
> that you copy Master, Model, MSDB).
> 5. STart the MSSQl server service and see that all the database are up.
>
>
> If you have issues in starting try starting the MSSQL Server service in
> Mimimal mode using "-c -f " parameters
> and trouble shoot.
>
>
> Thanks
> Hari
>
> SQL Server MVP
>
> "Pro" <nospam@nospam.net> wrote in message
> news:eE%23c83GUFHA.612@TK2MSFTNGP12.phx.gbl...
> NT
>
>
|
|
|
|
|