May 19, 2008 at 11:21 pm
Hello everyone, i m using SQL Server 2005, my system databse "msdb" mark suspected coz of light fluctuations, i have no back up to recover this, i tried many other solution for example:
1) These steps will recover MSDB DATABASE to the state after Installation of the SQL Server, in this loose your changes in this DB.
1.Stop SQL Server service
2.From the instalation CD SQL Server copy msdbdata.mdf and msdblog.ldfto your instalation folder
3.Run SQL Server service
=====================================================================
2)
EXEC sp_resetstatus 'DBName';
GO
DBCC CHECKDB;
GO
============================================
3)
Alternate course of action:
ALTER DATABASE DBNameSET EMERGENCY
ALTER DATABASE DBNameSET SINGLE_USER
DBCC CHECKDB (DBName, REPAIR_ALLOW_DATA_LOSS)
GO
but nothing happend , it stills maked as suspected, kindly tell me how i recover my MSDB database.
Plz reply me asap.
Thanx in Advance.
May 20, 2008 at 12:08 am
What does the SQL error log say about the reason the database is suspect? There should be some evidence in there.
Be aware that if you recreate msdb, you will lose all your jobs, job history, backup history, DTS packages and any SSIS packages stored within the DB.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 20, 2008 at 12:21 am
- did you encounter errors when doing all this ?
- what does sqlservers errorlog state?
- this once more proves you really need backups !
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
May 20, 2008 at 1:06 am
After you recover and you set up new backup routines, in addition to msdb, be sure to backup the master database too.
Good luck.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 10, 2008 at 5:44 pm
I fellows,
I had the same problem with sql server 7. Yes, very old.
The MDBS set was suspect. I try all ways, but I fall in the same error. Sort order is different.
I start service with sqlservr -c -T3608 and other DOS windows, I open osql e execute sp_detthac_db.
I quit windows, stop the service e start sqlservice. I open isqlw and execute the file instmsdb.sql in folder install of instance.
Done, MSDB online again.
Of course, after this, you can restore backup, ok.
Bye e thanks for help.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply