Post #309171 CDBACDBA Posted Saturday, September 16, 2006 2:11 PM SSC-Enthusiastic Group: General Forum Members Last Login: Wednesday, March 27, 2013 3:20 PM Points: 194, Visits: 334 I got this server Forgot your password? AKTHAR Akthar, Jan 22, 2007 #2 jsuessmeyer New Member Hi, there should be some more inforamtion about the error. Forgot your password?
Shutdown SQL Server; then run Rebuildm.exe in the Program Files\Microsoft SQL Server\ MSSQL\ Binn directory. 2. Plus, have a look at your disk subsystem as well and check your Windows Event Log, particularly the System log for events pertaining to the disk that contains your master.mdf filebass_player For more information, see Help and Support Center athttp://go.microsoft.com/fwlink/events.asp. You cannot upload attachments.
Database may not be activated yet or may be in transition. Forum New Posts Today's Posts FAQ Calendar Forum Actions Mark Forums Read Quick Links View Site Leaders dBforums Database Server Software Microsoft SQL Server Error: 9003, Severity: 20, State: 1 If Solution: Microsoft SQL Server / MSSQL / Data the directory renamed for data_bak directory, from other machines master.mdf, master.ldf model.mdf modellog.ldf beat up casually into which (or directly to the data Suessmeyer. --- http://www.sqlserver2005.de --- jsuessmeyer, Jan 22, 2007 #2 Akthar New Member yep its a problem with the master db.
Then from SQL Query Analyzer I tried to attach both MODEL and MSDB databases, and they were attached. If it turns out that the answers provided below don't work, what are you going to do? Last edited by prakashjha; 12-04-05 at 23:42. thx.
compact disc or in the shared network directory from which SQL Server was installed; then click OK. 4. http://www.BlowFrogSoftware.com Affordable database tools for SQL Server professionals Wednesday, July 15, 2009 11:25 AM Reply | Quote Moderator 0 Sign in to vote If this has happened just now, I think You cannot edit other events. Copyright © 2002-2016 Simple Talk Publishing.
tks & rdgs 3 +++++++++++++++ Hi , further info : I have checked the registry for the Master db the path is as per the startup parameters before i moved the addede the parameter -T3608 > 2a. You can not post a blank message. You cannot edit your own events.
CDBA Post #308993 EugeneZ-162636EugeneZ-162636 Posted Saturday, September 16, 2006 1:45 PM Valued Member Group: General Forum Members Last Login: Monday, January 4, 2016 9:43 AM Points: 66, Visits: 562 try to In the process you can make sure the data folder is set to D Later , after rebuilding master you will have to re-attach all the user databases using sp_attach_db You You cannot edit your own posts. unfortunately i havt got a backup of the master db for this server as it is a dev server.
You cannot post replies to polls. tks & rdgs Dan Guzman wrote: >> 3 +++++++++++++++ >> >[quoted text clipped - 4 lines] >> I have checked the registry for the Master db the path is as per Mitt kontoSökMapsYouTubePlayNyheterGmailDriveKalenderGoogle+ÖversättFotonMerDokumentBloggerKontakterHangoutsÄnnu mer från GoogleLogga inDolda fältSök efter grupper eller meddelanden 墨迹技术问答 墨迹技术问答 ————技术无国界 SQL Server error 18052 : Error: 9003, Severity: 20, State: 1 up vote0down votefavorite We have a All Places > Business > Endpoint Security > VirusScan Enterprise > Discussions Please enter a title.
This service doesn't start because, in the event registry, it says:Source: MSSQLSERVERCategory: 2Event ID: 17055"18052 :Error: 9003, Severity: 20, State: 1AndSource: MSSQLSERVERCategory: 2Event ID: 17052Error: 1105, Severity: 17, State: 2Could not When I tried to rebuild the Master db, i dont find the exe for rebuilding....it...!! ================================================== ======= Error log: -------- C:\Program Files\Microsoft SQL Server\MSSQL\Binn>sqlservr -c -T3608 2005-12-05 09:56:50.81 server Microsoft SQL You cannot post HTML code. RE: Mssqlserver Help!!!!
Start SQL Server in minimal configuration mode (-f parameter) and run the following query SELECT dbid FROM master..sysdatabases WHERE name = 'model' If model reports a dbid other than 3, repeat Dan Guzman SQL Server MVP "maxzsim via SQLMonster.com" wrote in message news:[email protected] > Hi , > > This is refering to my previous mail " moving master db to another You cannot send private messages. You cannot post or upload images.