tag:blogger.com,1999:blog-495177919198719500.post4138663451946405774..comments2023-12-27T20:52:29.483-08:00Comments on Microsoft Sql Server Tutorials: Repair SQL Server Database marked as Suspect or CorruptedSuprotim Agarwalhttp://www.blogger.com/profile/08349831623922214390noreply@blogger.comBlogger25125tag:blogger.com,1999:blog-495177919198719500.post-34079281134203213242018-02-26T22:57:20.926-08:002018-02-26T22:57:20.926-08:00perfect solution .. 100/100 for the author. This w...perfect solution .. 100/100 for the author. This worked for me like charmamithttps://www.blogger.com/profile/16131792635007757847noreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-89030677540501303552015-12-09T08:19:30.335-08:002015-12-09T08:19:30.335-08:00Thank you for post. It help me.Thank you for post. It help me.mayorehttps://www.blogger.com/profile/14271580943305609635noreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-48189883896458977592015-12-01T09:03:46.286-08:002015-12-01T09:03:46.286-08:00Excelente.Excelente.Anonymoushttps://www.blogger.com/profile/16684977594114519168noreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-41452514388860345402014-10-01T04:33:50.288-07:002014-10-01T04:33:50.288-07:00perfect post.. very helpful. Thanks alot.perfect post.. very helpful. Thanks alot.Deephttps://www.blogger.com/profile/02053262059394721249noreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-57869358723156321872014-09-12T10:02:03.777-07:002014-09-12T10:02:03.777-07:00superb very helpfull to me.thanks....superb very helpfull to me.thanks....Anonymoushttps://www.blogger.com/profile/06786103133835871307noreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-27076395964865771102014-08-19T05:26:10.598-07:002014-08-19T05:26:10.598-07:00It works thank youIt works thank youAnonymoushttps://www.blogger.com/profile/08664337627758664924noreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-49545083146754209362014-05-17T19:16:31.687-07:002014-05-17T19:16:31.687-07:00very useful for me. Thank you very much
very useful for me. Thank you very much<br />Công ty TNHH KTĐ Hoàng Pháthttps://www.blogger.com/profile/18077588093763387360noreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-4111055174259463302014-02-18T03:20:14.758-08:002014-02-18T03:20:14.758-08:00One more software which you can use at free of cos...One more software which you can use at free of cost to see preview of recovered sql data. Here is the link to download the software and use the free trial version.<br /><a href="http://www.recoverfilesdata.com/sql-database-mdf-recovery.html" rel="nofollow">http://www.recoverfilesdata.com/sql-database-mdf-recovery.html</a>Anonymoushttps://www.blogger.com/profile/14298040352200251661noreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-40657774496025210772013-12-08T18:43:19.831-08:002013-12-08T18:43:19.831-08:00excellent post,thank you!excellent post,thank you!kudalumpingnoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-88749815702154825632013-11-27T23:52:49.453-08:002013-11-27T23:52:49.453-08:00It's work well for me (Fixed)
1. Stop SQL Ser...It's work well for me (Fixed) <br />1. Stop SQL Server service.<br />2. Rename or remove old files named MSDBData.mdf, MSDBLog.ldf in directory [SQL Server Instance name]\MSSQL\DATA (exsample C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS2008\MSSQL\DATA).<br />3. Copy files named MSDBData.mdf, MSDBLog.ldf in [SQL Server Instance name]\MSSQL\Template Data\ (exsample C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS2008\MSSQL\Template Data)<br /> to [SQL Server Instance name]\MSSQL\DATA.<br />4. Restart SQL Server Service.<br />Passernoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-58617752254512430582013-11-27T23:47:21.334-08:002013-11-27T23:47:21.334-08:00It's work well for me.
1. Stop SQL Server ser...It's work well for me.<br /><br />1. Stop SQL Server service.<br />2. Rename or remove old files named MSDBData.mdf, MSDBLog.ldf in directory [SQL Server Instance name]\MSSQL\DATA (exsample C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS2008\MSSQL\DATA).<br />3. Copy files named MSDBData.mdf, MSDBLog.ldf in [SQL Server Instance name]\MSSQL\Template Data\ (exsample C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS2008\MSSQL\Template Data).<br />4. Restart SQL Server Service.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-23030844842411195822013-08-16T01:59:53.067-07:002013-08-16T01:59:53.067-07:00Great article. I am fully impressed.
LG Networks, ...Great article. I am fully impressed.<br />LG Networks, Inc. is a Microsoft Certified and a leading Microsoft Exchange Server Consulting firm.<br />Our <a href="http://www.microsoftexchangeserversupport.com/" rel="nofollow">Emergency Exchange Support</a> consultants can help you attain the maximum benefit and stability from<br />Microsoft Exchange Server with administrative, technical and onsite or remote troubleshooting support.<br />Waoou... What a tutorial you made? I think any body will be clear after seen this. Just not only looking nice , also<br />more helpful. <br /><a href="http://www.microsoftexchangeserversupport.com/" rel="nofollow">Emergency Exchange Support</a>Anonymoushttps://www.blogger.com/profile/01809457613635936222noreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-85531974650591674132013-05-04T00:21:11.761-07:002013-05-04T00:21:11.761-07:00Repair SQL server database form corrupted SQL serv...<a href="http://www.sqlrecovery.co.uk/" rel="nofollow">Repair SQL server database</a> form corrupted SQL server 2000, 2005 and 2008 with help of SQL server recovery software which is especially designed for recovery of SQL server.Anonymoushttps://www.blogger.com/profile/00764853921628445196noreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-42960560900414026652013-03-20T12:17:14.775-07:002013-03-20T12:17:14.775-07:00I have just notice that I have msdb (suspect).
W...I have just notice that I have msdb (suspect). <br /><br />What this mean, can this erase or remove my dts services files.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-56382942604362975532013-03-20T12:07:03.829-07:002013-03-20T12:07:03.829-07:00Hello, I have a sql 2000.
Usually I have 10 fil...Hello, I have a sql 2000. <br /><br />Usually I have 10 files in my Data Tranformation Services, Local Packages. I have lost those files. and I'm having this message when i tried to restore.<br /><br />Restore Database:<br /><br />Error 926: Database MSDB cannot be opened. it has been marked suspect by recovery. See the SQL Server errorlog for more informaitonAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-11404030433329184192013-02-12T07:40:56.087-08:002013-02-12T07:40:56.087-08:00Option 'EMERGENCY' cannot be set in databa...Option 'EMERGENCY' cannot be set in database 'msdb'<br />i m getting this error after executing this queryPrashant Agrawalhttps://www.blogger.com/profile/12145642170887101837noreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-70349561706252262532013-02-12T07:40:01.519-08:002013-02-12T07:40:01.519-08:00hi after executing this query i m getting an error...hi after executing this query i m getting an error "Option 'EMERGENCY' cannot be set in database 'msdb'"<br />plz helpPrashant Agrawalhttps://www.blogger.com/profile/12145642170887101837noreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-52005857529927592152012-05-04T06:25:43.626-07:002012-05-04T06:25:43.626-07:00Excellent post....
Thank you!!Excellent post....<br /><br />Thank you!!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-83835088641451222582011-04-08T00:43:10.219-07:002011-04-08T00:43:10.219-07:00Hello Dear,
Well written, i m a product reviewer ...Hello Dear,<br /><br />Well written, i m a product reviewer and i also write a article on the same topic. if you interested then check here <br /><br />http://sql-server-recovery.blogspot.com/2010/10/repair-restore-sql-server-database-from.htmlSQL Recoveryhttp://www.stellarsqldatabaserecovery.com/noreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-50997591454877184212011-04-04T17:28:56.238-07:002011-04-04T17:28:56.238-07:00my problem is with MS-SQL 2005 and MSDB is marked ...my problem is with MS-SQL 2005 and MSDB is marked corrupted and backup is missing at failure hard disk.<br />its posible recovery msdb?<br /><br />Joe<br /><br />joebanbino@yahoo.comAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-2206751425011452982011-03-13T23:51:39.953-07:002011-03-13T23:51:39.953-07:00Musab,
You need to repair it before using the dat...Musab,<br /><br />You need to repair it before using the database. Follow the articleMadhivananhttp://beyondrelational.com/blogs/Madhivanannoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-7045797244859914862011-03-12T04:05:08.868-08:002011-03-12T04:05:08.868-08:00This comment has been removed by the author.Unknownhttps://www.blogger.com/profile/04514232780923715709noreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-35213093025449866662011-03-12T04:04:43.398-08:002011-03-12T04:04:43.398-08:00thanks dear , actually i facing this issue .. i wo...thanks dear , actually i facing this issue .. i wondering before do any action , is there any risk for data when i executing this solution ? <br />and should the SQL agent be stoped ?<br /><br />message : Database 'msdb' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information. (Microsoft SQL Server, Error: 926)<br /><br />SQL Server 2008<br /><br />wating for ur reply ?<br />Best Regareds ,Unknownhttps://www.blogger.com/profile/04514232780923715709noreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-92095911412386816342011-03-10T04:07:55.471-08:002011-03-10T04:07:55.471-08:00Thanks Nina for the feedbackThanks Nina for the feedbackMadhivananhttp://www.beyondrelational.com/blogs/madhivanannoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-85099973200881950112011-03-09T20:55:18.619-08:002011-03-09T20:55:18.619-08:00:hugs: thank you thank you thank you Madhivanan
-...:hugs: thank you thank you thank you Madhivanan<br /><br />-_- NinaAnonymousnoreply@blogger.com