chetankumar_ramanuj@yahoo
Member
- Joined
- Sep 21, 2007
- Messages
- 5
- Programming Experience
- 3-5
My SQL Database becomes "SUSPECT", How can I restore it.
Database Status becomes "SUSPECT"
- Thread starter chetankumar_ramanuj@yahoo
- Start date
chetannramanuj
Member
- Joined
- Sep 21, 2007
- Messages
- 6
- Programming Experience
- 3-5
Delete Database and restore last updated backup.
Delete this database from SQL enterprise and restore from last updated backup file. this is the best way.
the only way is to delete the database and restore it from the recent backup taken by you.
Delete this database from SQL enterprise and restore from last updated backup file. this is the best way.
the only way is to delete the database and restore it from the recent backup taken by you.
chetankumar_ramanuj@yahoo
Member
- Joined
- Sep 21, 2007
- Messages
- 5
- Programming Experience
- 3-5
Another problem is that it does not allow me to delete also.
I've seen it rarely, and it worked out by just restarting the SQL Server service.
You have to drop the database from the service to do this, Enterprise Manager or other admin tool can be used, can also be done with the command line SqlCmd or SSE Util.
