Author |
Topic |
abudak
Starting Member
11 Posts |
Posted - 2004-08-03 : 08:31:41
|
I have a problem.My Problem EMP_Dedeman database suspect1.What is the reason?2.How is I untie this problem? |
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-08-03 : 08:45:17
|
There could be many reasons for a suspect database. The best solution is to delete the database and re-create it from your backups.Raymond |
|
|
abudak
Starting Member
11 Posts |
Posted - 2004-08-03 : 08:47:14
|
I have not backups |
|
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-08-03 : 08:48:52
|
Ouch. Well you have big problems then!Does the SQL Log give you any clues as to what's wrong with the database?Raymond |
|
|
abudak
Starting Member
11 Posts |
Posted - 2004-08-03 : 08:56:01
|
don't I have any rocevery to win? |
|
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-08-03 : 08:58:18
|
sorry - I don't understand the question. If you have no backups you can't recover the database. You need to check the SQL log to see if there is some clue as to why SQL is showing the database as suspect. Once you reoslve that and get the database back, start doing a proper backup routine!Raymond |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-08-03 : 09:03:27
|
Have you tried running: EXEC sp_resetstatus 'EMP_Dedeman' to reset the status?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-08-03 : 09:06:51
|
Shouldn't that be done in conjunction with resolving the cause of the problem as well Derrick? i.e. increase available disk space, or whatever?Raymond |
|
|
abudak
Starting Member
11 Posts |
Posted - 2004-08-03 : 09:11:40
|
EXEC sp_resetstatus 'EMP_Dedeman' executed The database 'EMP_Dedeman' does not exist. Use sp_helpdb to show available databases. |
|
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-08-03 : 09:13:33
|
So what does sp_HelpDb show for your database? Does it list it at all?Raymond |
|
|
abudak
Starting Member
11 Posts |
Posted - 2004-08-03 : 09:17:11
|
SQL LOGs *Starting up database 'EMP_dedeman'.*SQL server listening on TCP, Shared Memory, Named Pipes.*SQL server listening on 10.34.10.73:1433, 127.0.0.1:1433.*SQL Server is ready for client connections*udopen: Operating system error 3(error not found) during the creation/opening of physical device D:\EMPDATA\EMP_Dedeman_Data.MDF.*FCB::Open failed: Could not open device D:\EPMDATA\EPM_Dedeman_Data.MDF for virtual device number (VDN) 1.*Device activation error. The physical file name 'D:\EPMDATA\EPM_Dedeman_Data.MDF' may be incorrect.*Device activation error. The physical file name 'D:\EPMDATA\EPM_Dedeman_Log.LDF' may be incorrect.*Clearing tempdb database. |
|
|
abudak
Starting Member
11 Posts |
Posted - 2004-08-03 : 09:20:03
|
exec sp_HelpDb EPM_Dedeman not show |
|
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-08-03 : 09:21:42
|
So you have to check the physical file on the D drive. Does it exist - does the D drive have free space, is the file locked by any other process such as anti-virus software? Do the path and filenames point to actual files?Raymond |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-08-03 : 09:22:09
|
You're in trouble. Go to the directory and make sure those files exist.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
abudak
Starting Member
11 Posts |
Posted - 2004-08-03 : 09:25:56
|
I Have not 'D:\EPMDATA\EPM_Dedeman_Data.MDF' and 'D:\EPMDATA\EPM_Dedeman_Log.LDF' files.I'm not see them. |
|
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-08-03 : 09:28:17
|
Well there's why SQL Server says it's a suspect database. Now you just have to figure out what's happend to those files ....Raymond |
|
|
abudak
Starting Member
11 Posts |
Posted - 2004-08-03 : 09:44:28
|
show not database EPM_Dedeman at SQL Server Manager Databases |
|
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-08-03 : 09:48:13
|
So where are getting the suspect message from if it's not in EM?Raymond |
|
|
abudak
Starting Member
11 Posts |
Posted - 2004-08-03 : 09:53:46
|
I do not know... |
|
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-08-03 : 09:57:39
|
You don't know where you got the message saying that EPM_Dedeman was suspect? Do you have a problem at all - do you need this database? If so, when did the problem surface that it's data files are missing? You need to investigate your problem more fully.Raymond |
|
|
abudak
Starting Member
11 Posts |
Posted - 2004-08-03 : 09:59:21
|
Thanks MeanOldDBAThanks Raymond I re-create database EPM_Dedeman. |
|
|
Next Page
|