Home > Event Id > Event Id 17055 Cannot Recover The Master Database

Event Id 17055 Cannot Recover The Master Database

I uninstalled SQL 2000 andreinstalled it with the same directory structure. Retrieve the COM class factory for component with CLSID {B940C105-7F01-46FE-7F01-BF41-F040B9BDA83D} failed due to the following error 80040154. See http://seer.support.veritas.com/docs/263422.htmif you used the SQL Agent see http://seer.support.veritas.com/docs/243093.htm 0 Kudos Reply Re: Disaster Recovery Shijo_Michael Level 2 ‎05-21-2005 11:01 PM Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Thanks for any guidance. Check This Out

Copyright © 2002-2017 Redgate. To verify that the rebuild is successful, start SQL Server normally4. Upon reboot, SQL Server would not start. Deepak     Wednesday, May 14, 2008 5:19 AM Reply | Quote Moderator 0 Sign in to vote 1.) I am assuming that prior to the disk failure in X you had

Then run the below query to restore master database, Code Snippet Restore database master from disk='C:\Temp\master.bak' Change the path accordingly in the above query. Terms of Use. What does all this mean and how can I download the logs without having to type them all out (Copy and Paste didn't work of course). 2.

Thanks for your help. Rebuild a new master database using Rebuild master utility. Do so in single user mode (sqlserver.exe -c -m), and then restore the backup. Get Your Free Trial!

HesabımAramaHaritalarYouTubePlayHaberlerGmailDriveTakvimGoogle+ÇeviriFotoğraflarDaha fazlasıDokümanlarBloggerKişilerHangoutsGoogle'a ait daha da fazla uygulamaOturum açınGizli alanlarGrupları veya mesajları ara Log in :: Register :: Not logged in Home Tags Articles Editorials Stairways Forums Scripts Videos You can attach the databases using Enterprise Manager or Query Analyzer. Privacy Policy Support Terms of Use TechRepublic Search GO CXO Cloud Big Data Security Innovation More Software Data Centers Networking Startups Tech & Work All Topics Sections: Photos Videos All Writers Privacy statement  © 2017 Microsoft.

Please Help. 0 LVL 11 Overall: Level 11 MS SQL Server 1 Message Accepted Solution by:Jon Winterburn Jon Winterburn earned 500 total points ID: 205297782007-12-26 I just did the following Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s… MS SQL Server Advertise Here 656 members Event Type: Error Event Source: MSSQLSERVER Event Category: (2) Event ID: 17052 Date: 12/23/2007 Time: Thisrebuild/re-attach process seems like far too much work, when a clean startis probably the best thing to do anyway...A|||Well, I think everything is working again.

Once you restore your master and start Sql Server in normal mode (without any flags) you can restore all other databases if you have a clean backup of them.- Deepak Wednesday, Exiting. All rights reserved. My Operative System Administrator could restore the Disk, but now I need the steps that I have to follow in order to restore my databases from "X" server to "Y" server.

Nay ideas what I can try next?   Wednesday, October 29, 2008 8:25 PM Reply | Quote

Microsoft is conducting an online survey to understand your opinion of the his comment is here Post #244641 K. Olaf Helper [ Blog] [ Xing] [ MVP] jeanrouge on Tue, 28 Jun 2016 21:32:08 Hi Olaf, Yes I know everything is out of date but it has all been working I have been in many situations where it would have been easy to panic, but I've managed to weather the storm by remaining calm and following the proper methodology when dealing

restore master results in error 9003, sql 2000 Rate Topic Display Mode Topic Options Author Message Jean WylieJean Wylie Posted Thursday, December 15, 2005 2:06 PM Forum Newbie Group: General Forum Changing factor levels on a column with setattr is sensitive for how the column was created Bash remembers wrong path to an executable that was moved/deleted What does the expression 'seven Perhaps you know? this contact form Message Author Comment by:nreich ID: 205300552007-12-26 Why would the expansion of a zipped 42g log file error out upon expanding if the disk space was available? 0 LVL 11 Overall:

I could access my databases and querythem. i did a clean backup of database and it is successful. Build 3790 Service Pack 2 Hello Jean, In the message Desktop Engine is mentioned, I guess it's the free MSDE Version (now named Express Edition), funnily, it's still available as a

You cannot post IFCode.

Two questions: 1. Report Abuse. That will help you follow a methodical approach when disaster strikes, rather than acting too quickly under pressure. Any hope?

Brian Kelley Posted Thursday, December 15, 2005 3:52 PM Keeper of the Duck Group: Moderators Last Login: 2 days ago @ 9:55 AM Points: 6,639, Visits: 1,906 Microsoft support then looks In order that you can understand, I have to tell you that we had a Disk failure, that was the main reason that I open this TAR, because I try to Restore the master database from your old backup.5. navigate here Join the community of 500,000 technology professionals and ask your questions.

The installation media: presume you mean the win2003 server media? We've restricted the ability to create new threads on these forums. If you're using Query Analyzer, run the query shown in Figure E.Figure EIf you're using Enterprise Manager, right-click on the master database, choose All Tasks | Restore Database, and browse to