 Re: SQL 6.5 Database suspect
If you have log backup schema in place, do a log backup using the NO_TRUNCATE option.
Then restore the last database backup, and all subsequent log backups.
If you don't have log backups in place, restore the latest database backup.
If you don't have any backup in place (hope you do), call MS PSS.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
"danny" <danny@hotmail.com> wrote in message
news:05df01c2a576$0c8ebc00$d2f
82ecf@TK2MSFTNGXA09...
> I am now using SQL Server 6.5, and I found that one of the
> Database status is suspect and I cannot connect to this
> database. What can I do to recover this database ?
Report this post to a moderator
|
12-17-02 03:23 AM
