on 09-15-2015 3:05 PM
Hi, is everyone ok??
Well, basically i over-look the operation of several servers for various companies. One of the servers however will not send me reports. Ive checked the problem out and it appears that the SQLAgent$SBSMonitoring service is not running. When i open services.msc and try to start it, it comes up with the formentioned error. (Error 1068: The dependency service or group failed to start) Ive checked this out further and i believe that the master.mdf file is corrupt. As, the server is a new setup carried out by a colleague, no backups were created. Are they any suggestions for repairing the service?? We do not have any SQL repair software at hand.....
Cheers for the feedback, it is greatly appreciated!!
When you can’t restore .sql data via standard solutions make use of guide below or if even the guide can’t help you, it might be that your sql data was severely corrupted and you may get more powerful tips on next sources
http://itknowledgeexchange.techtarget.com/itanswers/it-seems-our-sql-database-is-corrupted/
http://forums.techguy.org/windows-xp/1137458-creating-new-database-using-mdf.html#post8996088
https://sql.recoverytoolbox.com/ Recovery Toolbox for SQL Server
Restore With Graphical Interface
Step 1
Right-click “Databases” and click the “Attach” option to open the Attach Databases dialog box.
Step 2
Click the “Add” button to open the Locate Database Files dialog box.
Step 3
Type in the full name of the .MDF file, including the full device and directory path, as the following example illustrates:
c:\data files\my_data.mdf
Click the "OK" button. SQL Server Management Studio loads the database from the .MDF file.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Aaron,
Usually when dealing with database corruptions in SQL Server, Microsoft is the best resource to find out options and solutions.
You have here Mark Weber's blog at MSDN: http://blogs.msdn.com/b/markweberblog/
And this blog post might give you some sort of help: The Easiest Way To Rebuild The master Database - Fort SQL - Site Home - TechNet Blogs
And this blog post at SAP on Microsoft Platform in MSDN: Corruption Handling in SAP Databases - Running SAP Applications on Microsoft Platform - Site Home -...
Best Regards,
Luis Darui
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.