DB Suspect in SQL 6.5

I have a data base in SQL 6,5 under suspect status, in the
event viewer (NT 4,0 SP 6a), registers an error with a
problem a array of SCSI device. In the time I execute the
sp_resetstatus (store procedure), the BD returns to the
state from suspect, after being several minutes with
estatus of recovering.
What's is the procedure to move a devices for other
container, without restore and bcp procedures?Hi,
Can you update the database status manually to "0" and try dumping and
loading into a new database.
Update sysdatabases
set status=0
where name ='name'
Note:
Mostly this will not allow you to dump the database, inthat case you may
need to BCP OUT and BCP IN the data to a new database.
Thanks
Hari
MCDBA
"jmreynoso" <anonymous@.discussions.microsoft.com> wrote in message
news:1454c01c41407$bf0307f0$a301280a@.phx
.gbl...
> I have a data base in SQL 6,5 under suspect status, in the
> event viewer (NT 4,0 SP 6a), registers an error with a
> problem a array of SCSI device. In the time I execute the
> sp_resetstatus (store procedure), the BD returns to the
> state from suspect, after being several minutes with
> estatus of recovering.
> What's is the procedure to move a devices for other
> container, without restore and bcp procedures?|||SQL Server 6.5 Books on Line includes the code to sp_movedevice which will
help you move a database/database device to a new location. The following
article has the details:
INF: How to Move a Device to Another Location
http://support.microsoft.com/?id=181602
Rand
This posting is provided "as is" with no warranties and confers no rights.