|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Hidden Master, Model, MSDB, and Tempdb Databases.I have an instance of Enterprise Manager for SQL Server 2000 on my desktop that does not list the above databases. When I attempt to add any of them, I receive: "Error 5123: CREATE FILE encountered operating system error 32.". I see all the databases in the server's copy of EM. My questions are twofold. What is the likely reason my workstation copy of EM got this way? How do I best fix this? I suspect I may have to wait for no users to be on the system, but I hope someone knows a way to fix this without doing so. Also the TempDB does not appear as an mdf file, which I guess is because it is a temporary construct that exists in memory only. So I do not even being to know how to make that appear in my list. Mark Simmerman SQL Learner Napa, California Right-click on the Server, select 'Edit SQL Server Registration properties
and make sure 'show system databases and system objects' is checked. -- Show quoteHope this helps. Dan Guzman SQL Server MVP "Mark" <xxxdba***@gmail.com> wrote in message news:1148081170.238568.164540@38g2000cwa.googlegroups.com... > Thanks in advance. > > I have an instance of Enterprise Manager for SQL Server 2000 on my > desktop that does not list the above databases. When I attempt to add > any of them, I receive: "Error 5123: CREATE FILE encountered operating > system error 32.". I see all the databases in the server's copy of EM. > > > > My questions are twofold. What is the likely reason my workstation > copy of EM got this way? How do I best fix this? I suspect I may have > > to wait for no users to be on the system, but I hope someone knows a > way to fix this without doing so. Also the TempDB does not appear as > an mdf file, which I guess is because it is a temporary construct that > exists in memory only. So I do not even being to know how to make that > > appear in my list. > > > Mark Simmerman > SQL Learner > Napa, California > Except for MSDB, those system databases MUST exist on your server, so trying
to 'add' them is pointless. They're already there which is why you're getting the message you reported. I presume you also have Query Analyzer, so you could run a query: exec sp_helpdb and you should see the system databases listed with all the others. Right click on the name of your server (or LOCAL) in Enterprise Manager. Choose 'Edit SQL Server Registration Properties' Check the box near the button of the dialog box that says 'Show system databases and system objects' Click OK Now when you expand your Databases node in Enterprise Manager, you should see the system databases. Show quote "Mark" <xxxdba***@gmail.com> wrote in message news:1148081170.238568.164540@38g2000cwa.googlegroups.com... > Thanks in advance. > > I have an instance of Enterprise Manager for SQL Server 2000 on my > desktop that does not list the above databases. When I attempt to add > any of them, I receive: "Error 5123: CREATE FILE encountered operating > system error 32.". I see all the databases in the server's copy of EM. > > > > My questions are twofold. What is the likely reason my workstation > copy of EM got this way? How do I best fix this? I suspect I may have > > to wait for no users to be on the system, but I hope someone knows a > way to fix this without doing so. Also the TempDB does not appear as > an mdf file, which I guess is because it is a temporary construct that > exists in memory only. So I do not even being to know how to make that > > appear in my list. > > > Mark Simmerman > SQL Learner > Napa, California > |
|||||||||||||||||||||||
Other interesting topics