Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tomy
Starting Member
2 Posts |
 Posted - 2012-01-28 : 00:36:59
|
| My database which in running on MS SQL 2000 has been labelled "suspect/emergency mode" and could not access data. Is there any possibility access data.....urgent response is required please since I do not have backup for the month. |
|
|
tomy
Starting Member
2 Posts |
Posted - 2012-01-28 : 03:32:31
|
| Plizzzzzz i need help on the suspect/emergency" mode database which I need to retrieve data. Can anyone helpppppppp plizzzzzzzzzzz |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-01-28 : 05:08:40
|
| Restore from your last good backup.Oh wait, another person without backups. Why?SQL 2000, going to be very hard to get this fixed, and the chances of getting it back are not great. First step, set it to emergency mode:EXEC sp_configure 'allow updates', 1 RECONFIGUREGOStep 2, set the DB to emergency modeUPDATE sysdatabases set status = 32768 WHERE name = <database with the problem>Step 3, connect to that database and run CheckDB.DBCC CheckDB (<database with the problem>) NO_INFOMSGS, ALL_ERRORMSGSRun just that and NOTHING else and post any errors that you get.DO NOT detach the DB. DO NOT restart SQL.p.s. If you need urgent help and are not willing to wait, pay someone for that support. We're all volunteers here, we post in our spare time.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Database in suspect/emergency mode