| Author |
Topic |
|
antheia
Starting Member
4 Posts |
 Posted - 2008-04-28 : 11:18:17
|
| I started getting errors everytime i try to access my webmail(horde), my zencart and my forum so i asked my website host and they say i need to repair the SQL database. I have no idea what this means, can someone help please?The errors are:Horde: A fatal error has occurredCould not connect to database for SQL SessionHandler.Details have been logged for the administrator.Zencart: 0 DB_ERROR_NOT_CONNECTEDin:[db_cache table]If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.SMF Forum: Connection ProblemsSorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later. Please help, i am totally lost! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-28 : 13:18:08
|
| There isn't anything in your post that would help us help you. In order to determine if you have database corruption, run DBCC CHECKDB. If it returns errors, then you've got some database corruption and therefore should post the entire output here.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2008-04-28 : 17:33:20
|
| Yup - please run the following:DBCC CHECKDB (yourdbname) WITH ALL_ERRORMSGS, NO_INFOMSGSThanksPaul RandalSQL Server MVP, Managing Director, SQLskills.com |
|
|
|
antheia
Starting Member
4 Posts |
Posted - 2008-04-28 : 21:36:48
|
| Sorry but i have no idea what you mean? How do i do this? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-28 : 22:21:20
|
| Run it in ssms -> query windows (sql2k5) or query analyzer (sql2k), sql books online tells you how to run sql query. |
|
|
|
antheia
Starting Member
4 Posts |
Posted - 2008-04-28 : 22:26:28
|
| Is that some type of program i need to download? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-28 : 22:37:22
|
| No, it's builtin sql command. |
|
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2008-04-29 : 09:52:33
|
| No offense - but I seriously recommend you call Microsoft Product Support to help you with this. They will do a much better job of walking you through this than we will - especially if you don't have any SQL Server knowledge.Thanks!Paul RandalSQL Server MVP, Managing Director, SQLskills.com |
|
|
|
antheia
Starting Member
4 Posts |
Posted - 2008-04-29 : 10:05:48
|
| nevermind, it resolved itself somehow. |
|
|
|
data recovery
Starting Member
2 Posts |
Posted - 2008-05-30 : 03:21:27
|
| If still you are not able to repair it manually, then repair it bu any result oriented database repair software.. Hope this worksThere is every possible solution to each problem like data recovery. Data recovery is possible in 85% of cases. http://www.nucleustechnologies.com |
|
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2008-05-30 : 08:36:32
|
| Yes, this might automate some of what you can do manually, but as with any other 'recovery' tool, it won't go anywhere if the database can't be repaired by CHECKDB in the first place. Use with caution.Paul RandalSQL Server MVP, Managing Director, SQLskills.com |
|
|
|
dragoslav10
Starting Member
2 Posts |
Posted - 2011-03-23 : 13:49:23
|
| can anybody sent me a script for repairbajabaja |
|
|
|
addisionphilip
Starting Member
4 Posts |
Posted - 2011-04-11 : 07:57:36
|
quote:
Originally posted by data recovery
If still you are not able to repair it manually, then repair it bu any result oriented database repair software.. Hope this worksThere is every possible solution to each problem like data recovery. Data recovery is possible in 85% of cases. http://www.nucleustechnologies.com
Agree, you can also try an updated unspammed that repairs .mdf as well as .ndf file of sql server databaseunspammed |
|
|
|
|
Database repair - need help please!