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 |
|
obim
Starting Member
1 Post |
 Posted - 2006-10-12 : 13:53:00
|
| My database is marked suspect/offline in the enterprise manager. i am usingsql server 2000.i have tried resetstatus,DBCC CheckDB, alterdatabase,sp_dboption and DBCC ALLOCDB ( 'dbname' ) but all to no avail.ihave no backup of the database.And i really need to get back this data.Please, can you give me a detailstep by step method of how to overcome this problem.i greatly anticipate your reply!!!Thanks |
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2006-10-12 : 15:16:51
|
| What error messages are there in the SQL Server errorlog? These should indicate why the database is suspect. Please post them here - it may be something as simple as the log drive running out of space or it may be a corruption somewhere.Did anything out of the ordinary happen before this? (e.g. power failure)And, you need to get a backup strategy worked out.ThanksPaul RandalLead Program Manager, Microsoft SQL Server Core Storage Engine (Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
 |
|
|
|
|
|
Crash Database