| Author |
Topic |
|
raghuveer125
Constraint Violating Yak Guru
285 Posts |
 Posted - 2011-05-18 : 01:09:33
|
| One of my database is in suspect mode. So I need to know what happened with my database how or where can I get information.In Love... With Me! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
raghuveer125
Constraint Violating Yak Guru
285 Posts |
Posted - 2011-05-18 : 01:56:48
|
| Sorry one of my employee Cleared all Events and He Run DBCC Errorlog more then 10 times So I don't Have Any Error log and Event; Its MSSQL 2005 Enterprise.(Note: Its Test Server not production server)In Love... With Me! |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
raghuveer125
Constraint Violating Yak Guru
285 Posts |
Posted - 2011-05-18 : 02:07:35
|
| Ok thank you So I can't get in MASTER or MSDB what is error; Why my database is get suspected.In Love... With Me! |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-05-18 : 05:36:34
|
| That information is in the SQL error log, no where else. Without seeing that it's going to be very hard to tell why.Why the hell would someone clear the error logs? Seriously sounds like he wants to hide something he did. Regardless, he's made things far more difficult.Sure there's nothing in the Windows application log? No backups of the error logs?--Gail ShawSQL Server MVP |
|
|
|
raghuveer125
Constraint Violating Yak Guru
285 Posts |
Posted - 2011-05-18 : 05:53:18
|
| Yep there is nothing no event log backup not error log backup.I am checking manually Like Disk Space where MDF and LDF located.Is there any more things which I have to check manually first. In Love... With Me! |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-05-18 : 08:29:30
|
| Low disk space won't cause a database to go suspect.Missing files won't cause a database to go suspect.Suspect is caused when SQL encounters corruption during either crash recovery or transaction rollback.Since we have absolutely not idea what caused it, I would strongly suggest taking a tail-log backup and restoring the database. Safest approach by far.I would also suggest taking your colleague's behaviour up with management.--Gail ShawSQL Server MVP |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
raghuveer125
Constraint Violating Yak Guru
285 Posts |
|
|
raghuveer125
Constraint Violating Yak Guru
285 Posts |
Posted - 2011-05-18 : 10:12:10
|
| Thank you! GilaMonster.So this happened on my test server so not to worry. And I already did that taking tail backup. Just I wanted to know that is there any other way to find database suspect except error and event log.Fine once again thank you.GilaMonsterIn Love... With Me! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
raghuveer125
Constraint Violating Yak Guru
285 Posts |
Posted - 2011-05-19 : 00:50:16
|
| Thank You tkizer.In Love... With Me! |
|
|
|
hazmer1
Starting Member
1 Post |
Posted - 2011-05-19 : 09:18:16
|
| Hi folks,I am currently adding 250 databases to a SQL Server (MS SQL Server 2008) using SQL Server Management Studio. It took all day yesterday, MySQL to Foxpro and I am sure there has to be another way to do it. The filenames are quite complex and it is not easy tracking which ones I have added. Is there a wee loop or something I can use to add all .mdf and .ldf files in a folder to the server?Thanks! |
|
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2011-05-19 : 09:54:12
|
quote:
Originally posted by X002548
No training, no clue, no real life experience....How much are you charging for your offshore consulting?Brett8-)
a bad joke--------------------------http://connectsql.blogspot.com/ |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2011-05-19 : 12:49:29
|
quote:
Originally posted by hazmer1
Hi folks,I am currently adding 250 databases to a SQL Server (MS SQL Server 2008) using SQL Server Management Studio. It took all day yesterday, MySQL to Foxpro and I am sure there has to be another way to do it. The filenames are quite complex and it is not easy tracking which ones I have added. Is there a wee loop or something I can use to add all .mdf and .ldf files in a folder to the server?
What does your question have to do with a "suspect database" or SQL Server? Why hijack this thread about suspect databases on Microsoft SQL Serve rwhen you are asking about MySQL/Foxpro?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
Jahanzaib
Posting Yak Master
115 Posts |
Posted - 2011-05-20 : 02:02:30
|
| any Disk Management or Disk movement activity ?are you using locak Disk,SAN,NAS ?Regards,Syed Jahanzaib Bin HassanMCTS,MCITP,OCA,OCP,OCE,SCJP,IBMCDBAMy Blogwww.aureus-salah.com |
|
|
|
raghuveer125
Constraint Violating Yak Guru
285 Posts |
Posted - 2011-05-20 : 02:14:08
|
| Hi friends no one is there to monitor this forum See what was the question and what happened with this post some one came and asking his question which is not related to this post. And some fool people answering it. Great.........!In Love... With Me! |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-05-20 : 12:09:16
|
quote:
Originally posted by raghuveer125
And some fool people answering it.
I do hope you're not calling Tara a fool...--Gail ShawSQL Server MVP |
|
|
|
Next Page
|
Suspect Database