Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Lincolnburrows
Yak Posting Veteran
52 Posts |
 Posted - 2014-08-29 : 08:03:07
|
| Please guide me how to verify/repairing a MS SQL database without restore. At the moment our backup is failing on the Solarwinds database saying the database NetPerfMon is corrupted (we are using Backup Exec 12.5 to perform the backups). I have SQL studio express 2005 installed if that helps other than that I don't have much of an idea what to do with SQL other than little bits of dabbling with it. |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2014-08-29 : 10:52:43
|
| Could you post the relevant messages from the error logs?Jack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
Shanky
Yak Posting Veteran
84 Posts |
Posted - 2014-09-01 : 09:59:20
|
| Are you able to run>> dbcc checkdb (db_name) wuth no_infomsgs,all_errormsgs. Can you post output of this command. depending on level of corruption you can recover corrupt databases using dbcc checkdb repair methods IF YOU DONT HAVE BACKUPSHope this helpsRegardsShankyhttp://social.technet.microsoft.com/wiki/contents/articles/24253.list-of-articles-by-shanky.aspx |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
|
|
|
|
|
How to recover SQL database without restore?