| Author |
Topic |
|
erfan
Starting Member
3 Posts |
 Posted - 2012-01-04 : 00:59:31
|
| Hi my MSDB and some of my SharePoint DB's flaged as "Suspect" , I fixed the problem on other databases with some stored procedure which I found on the web but I couldnt do anything for MSDB. as my log file's size going HUGE, what can I do to repair or restore it? |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-01-04 : 04:26:53
|
| Restore from backup.And once you're done, investigate the root cause. Databases don't go suspect for no reason.--Gail ShawSQL Server MVP |
 |
|
|
erfan
Starting Member
3 Posts |
Posted - 2012-01-04 : 07:31:29
|
| the issue was for recovery of the operating syetem, and I cant recover it the restore database option is gray. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-01-04 : 09:43:13
|
| Open up books online and read over the section on restoring the system databases. It's not as simple as restoring user databases.--Gail ShawSQL Server MVP |
|
|
|
biswajitdas
Starting Member
44 Posts |
Posted - 2012-01-11 : 11:33:16
|
| If I understand is the issue of MSDB database goes in suspect mode is due to the operating system ?Sr Sql server DBA/Artitech |
|
|
|
biswajitdas
Starting Member
44 Posts |
Posted - 2012-01-11 : 11:38:31
|
| ALso what is the sql server version you are usingSr Sql server DBA/Artitech |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-01-11 : 13:40:38
|
quote:
Originally posted by biswajitdas
If I understand is the issue of MSDB database goes in suspect mode is due to the operating system ?
Nope. Corruption encountered during rollback or crash recovery.--Gail ShawSQL Server MVP |
|
|
|
erfan
Starting Member
3 Posts |
Posted - 2012-01-12 : 05:53:42
|
| My SQL server is 2005 sp3I uninstalled and installed SQL server, but the log files are remains an issue.whenever I start SQL server, log files creat continiously and their size growth unlimitedly. what can i do for it? |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-01-12 : 09:06:38
|
| What log files? Where?p.s. Unless this is related to the MSDB corruption, please start a new thread.--Gail ShawSQL Server MVP |
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2012-01-12 : 10:51:28
|
quote:
Originally posted by erfan
My SQL server is 2005 sp3I uninstalled and installed SQL server, but the log files are remains an issue.whenever I start SQL server, log files creat continiously and their size growth unlimitedly. what can i do for it?
you are probably never taking backups of them so they can never truncate.However, start a new thread -- its 99% likely unrelated to corruption/Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2012-01-12 : 12:55:54
|
Same O/P, so assuming same issue  its MSDB, which will be in SIMPLE Recovery Model, won't it? (I'll probably now find that my useless memory has mis-remembered that ...) |
|
|
|
|
MSDB suspect problem