SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - SQL Server 2005/Yukon
 DataBase Suspect
 Forum Locked
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 2

abudak
Starting Member

Turkey
11 Posts

Posted - 08/03/2004 :  08:31:41  Show Profile
I have a problem.My Problem EMP_Dedeman database suspect

1.What is the reason?
2.How is I untie this problem?

raymondpeacock
Constraint Violating Yak Guru

United Kingdom
367 Posts

Posted - 08/03/2004 :  08:45:17  Show Profile
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

Edited by - raymondpeacock on 08/03/2004 08:46:08
Go to Top of Page

abudak
Starting Member

Turkey
11 Posts

Posted - 08/03/2004 :  08:47:14  Show Profile
I have not backups
Go to Top of Page

raymondpeacock
Constraint Violating Yak Guru

United Kingdom
367 Posts

Posted - 08/03/2004 :  08:48:52  Show Profile
Ouch. Well you have big problems then!

Does the SQL Log give you any clues as to what's wrong with the database?


Raymond

Edited by - raymondpeacock on 08/03/2004 08:50:39
Go to Top of Page

abudak
Starting Member

Turkey
11 Posts

Posted - 08/03/2004 :  08:56:01  Show Profile
don't I have any rocevery to win?
Go to Top of Page

raymondpeacock
Constraint Violating Yak Guru

United Kingdom
367 Posts

Posted - 08/03/2004 :  08:58:18  Show Profile
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
Go to Top of Page

derrickleggett
Pointy Haired Yak DBA

USA
4184 Posts

Posted - 08/03/2004 :  09:03:27  Show Profile  Visit derrickleggett's Homepage  Send derrickleggett an AOL message  Send derrickleggett a Yahoo! Message
Have you tried running: EXEC sp_resetstatus 'EMP_Dedeman' to reset the status?

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

Edited by - derrickleggett on 08/03/2004 09:04:08
Go to Top of Page

raymondpeacock
Constraint Violating Yak Guru

United Kingdom
367 Posts

Posted - 08/03/2004 :  09:06:51  Show Profile
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
Go to Top of Page

abudak
Starting Member

Turkey
11 Posts

Posted - 08/03/2004 :  09:11:40  Show Profile
EXEC sp_resetstatus 'EMP_Dedeman' executed
The database 'EMP_Dedeman' does not exist. Use sp_helpdb to show available databases.
Go to Top of Page

raymondpeacock
Constraint Violating Yak Guru

United Kingdom
367 Posts

Posted - 08/03/2004 :  09:13:33  Show Profile
So what does sp_HelpDb show for your database? Does it list it at all?


Raymond
Go to Top of Page

abudak
Starting Member

Turkey
11 Posts

Posted - 08/03/2004 :  09:17:11  Show Profile
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.
Go to Top of Page

abudak
Starting Member

Turkey
11 Posts

Posted - 08/03/2004 :  09:20:03  Show Profile
exec sp_HelpDb
EPM_Dedeman not show
Go to Top of Page

raymondpeacock
Constraint Violating Yak Guru

United Kingdom
367 Posts

Posted - 08/03/2004 :  09:21:42  Show Profile
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
Go to Top of Page

derrickleggett
Pointy Haired Yak DBA

USA
4184 Posts

Posted - 08/03/2004 :  09:22:09  Show Profile  Visit derrickleggett's Homepage  Send derrickleggett an AOL message  Send derrickleggett a Yahoo! Message
You're in trouble. Go to the directory and make sure those files exist.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page

abudak
Starting Member

Turkey
11 Posts

Posted - 08/03/2004 :  09:25:56  Show Profile
I Have not 'D:\EPMDATA\EPM_Dedeman_Data.MDF' and 'D:\EPMDATA\EPM_Dedeman_Log.LDF' files.
I'm not see them.
Go to Top of Page

raymondpeacock
Constraint Violating Yak Guru

United Kingdom
367 Posts

Posted - 08/03/2004 :  09:28:17  Show Profile
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
Go to Top of Page

abudak
Starting Member

Turkey
11 Posts

Posted - 08/03/2004 :  09:44:28  Show Profile
show not database EPM_Dedeman at SQL Server Manager Databases
Go to Top of Page

raymondpeacock
Constraint Violating Yak Guru

United Kingdom
367 Posts

Posted - 08/03/2004 :  09:48:13  Show Profile
So where are getting the suspect message from if it's not in EM?


Raymond
Go to Top of Page

abudak
Starting Member

Turkey
11 Posts

Posted - 08/03/2004 :  09:53:46  Show Profile
I do not know...
Go to Top of Page

raymondpeacock
Constraint Violating Yak Guru

United Kingdom
367 Posts

Posted - 08/03/2004 :  09:57:39  Show Profile
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
Go to Top of Page

abudak
Starting Member

Turkey
11 Posts

Posted - 08/03/2004 :  09:59:21  Show Profile
Thanks MeanOldDBA
Thanks Raymond
I re-create database EPM_Dedeman.
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Next Page
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.12 seconds. Powered By: Snitz Forums 2000