hi guys , i am having the following error when starting SQL server service: Event Type: Error Event Source: MSSQL$SQL_2000 Event Category: (2) Event ID: 17055 Date: 22/01/2007 Time: 3:38:06 PM User: N/A Computer: SQLServer1 Description: 18052 : Error: 9003, Severity: 20, State: 1. For more information, see Help and Support Center athttp://go.microsoft.com/fwlink/events.asp. Data: 0000: 84 46 00 00 10 00 00 00 „F...... 0008: 10 00 00 00 4a 00 4d 00 ....J.M. 0010: 41 00 52 00 49 00 45 00 A.R.I.E. 0018: 5c 00 53 00 51 00 4c 00 .S.Q.L. 0020: 5f 00 32 00 30 00 30 00 _.2.0.0. 0028: 30 00 00 00 07 00 00 00 0....... 0030: 6d 00 61 00 73 00 74 00 m.a.s.t. 0038: 65 00 72 00 00 00 e.r... AKTHAR
Hi, there should be some more inforamtion about the error. Looks like the master database became corrupted. Before searching for the basic error (which is often relataed to physical problems) I would suggest you to backup the database on the server (if not done yet). This is just for the case that you have a physical failure on your harddrives. Afterwards I would try to restore a valid recent master database backup and see if the database is running again. Make sure to scan your harddrives ASAP for physical failures ! HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de ---
yep its a problem with the master db. unfortunately i havt got a backup of the master db for this server as it is a dev server. I guess i will have to re-install and restore the data thanks AKTHAR
you have to take master server even it is a development server ---------------------------------------- Contributing Editor, Writer & Forums Moderator http://www.SQL-Server-Performance.Com Visit my Blog at http://dineshasanka.spaces.live.com/