Viewing 15 posts - 1 through 15 (of 38 total)
running "DBCC CHECKDB('msdb', REPAIR_REBUILD) GO"
have below result and again on saving maitenace plan give error :
class not registerd .
would you please let me know as previous asked ,installing SP3.0 resolve...
February 16, 2013 at 1:00 am
in you'r opinion what can i do ?which command run ?
February 15, 2013 at 11:09 am
dose installing mssql2005 sp3.0 resolve issue ?
February 11, 2013 at 10:35 pm
sql server give me this error : "class not registered "
can i install SQLServer2005_SSMSEE.exe ?to resolveissue ?
February 11, 2013 at 10:02 pm
before running command i get back up, i restore msdb and stop agent , single mode ,after runing :
DBCC CHECKDB (msdb, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS
it give me this :
Repair: The...
February 11, 2013 at 3:08 am
ok, you're right . now why i cant create maitenance plan ? before message ?
February 5, 2013 at 5:08 am
ok, before i run on msdb i run these command on wfilter database for test ,
i do them with msdb
February 5, 2013 at 3:20 am
1)stop agent
2)ALTER DATABASE WFilter SET Single_User WITH ROLLBACK IMMEDIATE
3)DBCC CHECKDB (WFilter, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS
it give no error , sucessfuly run
4)ALTER DATABASE WFilter SET MULTI_USER
February 5, 2013 at 1:28 am
hello , i run command ,and it be okay.
but now when i want to create new Maintenance on saving it give me this error :
TITLE: Maintenance Plan Wizard Progress
------------------------------
Saving maintenance...
February 4, 2013 at 4:24 am
and how i can change it to multi user mode ?
February 4, 2013 at 2:12 am
hello,when i want to run script ,it need to change data base to single mode.
when i want to open properties of data base a error message appear ,how i can...
February 4, 2013 at 12:40 am
Hello ,thanks for you'r help.
i describe condition first for you:
most important things for me is correcting maintenance plan of MSSQL SERVER,
delete current job and maitenance plan is not important i...
February 2, 2013 at 1:25 am
i have one question , does running this command causing damaged for MSSQLServer ? is is safe for run ?
January 31, 2013 at 2:51 am
No,i have no backup of MSDB before this issue!!
January 31, 2013 at 1:56 am
command :
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
only give error on msdb with below error :
Msg 8979, Level 16, State 1, Line 1
Table error: Object ID 117575457, index ID 1,...
January 30, 2013 at 10:15 pm
Viewing 15 posts - 1 through 15 (of 38 total)