The MASTER db and TEMPDB does appear in Enterprise Manager
-
Hello
After changing on the server with RAID5 the disks, when i open the enterprise
Manager the database MASTER and TEMDB does not appeared and the system is turn very slow. I don´t know if it´s cause by this problem.
But in the query analiser i can use and see them.
Can i changed through query analiser the path in the SYSDATABASES (Field filename),SYSDEVICES(phyname),SYSFILES (filename)and SYSFILES1(filename) to restore the original PATH.
I think maybe i can have problems if i changed the path on this files ?
Could you give me your suggestions.
Many thanks
Luis Santos
-
Do I grasp correctly that filename columns in tables sysdatabases, sysfiles and possibly sysaltfiles don't match for master and tempdb on your server? This condition shouldn't exist under any circumstances. I hope this is not a production server.
I came across a mismatch between sysdatabases and sysaltfiles entries for master db in test environment and one immediate consequence was that next master db restore didn't work. Who knows what else would have appeared later. I tried to update sysdatabases table directly and it started working but personally I would never do it in production env. If I had to tackle this situation I would go for a backup or detach of user dbs, at least rebuilding system databases (rebuildm utility) or reinstalling sql server and restoring/attaching user dbs. This is just my opinion - others may have different ideas.
-
[Stupid question alert]
Is EM set to show System Objects?
[/Stupid question alert]
-
Changing the underlying disk arrangement (say RAID 1 to RAID 5) has no bearing on whether or not things 'show up' in EM. If somehow you 'lost' the files for either the master or tempdb databases your SQL Server instance would not start at all. It seems that you have 2 issues here. Performance and EM. I'd first reinstall EM then tackle the performance piece.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
-
Hello Rudy
I have verify through QA the tables SYSDATABASES,SYSDEVICES,SYSFILES and SYSFILES1.
All of them have exactly the same path of the original installation, simply in EM i can´t see them.
In an another post reply , someone make me the following question :
Is EM set to show System Objects?
When i open EM i can´t find any option to hidding/showing system databases. Do you know where is that option?
However EM don´t show me the MASTER and TEMPDB , SQLSERVER work perfectly and also all the services.
Thanks for your help
Luis Santos
-
Right click on the registered server in question in EM and select "Edit SQL Server Registration Properties" ... make sure that the "Show system databases and system objects" check box is checked ...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
-
Hi Rudy
Thanks for your help, maybe the problem is that have not "Show system databases and system objects" checked.
When i install the SQLServer this propertie is always checked by default, i don´t know if someone deactivate this option, because is my client who have replace the disk (RAID 5) and he tell me that they don´t touch on the original disk (C
that contain O.S. and the Sql Server and also is has respect on changing disk the same partition letter.I will check if effectively that was this check box that my client was turn off without inform me.
it would like to be thankful for your help and interest.
Many thanks
Luis Santos
-
Ok I'll try to be clearer next time
.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply