Post reply

cannot view the model, msdb, tempdb and model database

  • May 9, 2006 at 4:22 am

    #114540

    Hi, Under the MS SQL 2000 database, i cannot view the model, msdb, tempdb and model database. Any explanation on this?

    Thanks

  • May 9, 2006 at 4:53 am

    #636677

    What are you using Enterprise manager or Query analyser?

    regards,

    Holger

  • May 9, 2006 at 5:33 am

    #636683

    Hm,

    Nope in Enterprise Manager but with Query Analyser, yes. I manage to see the Database.

    My purpose is to shirnk the these files.? Any Tips.?

    Thank you.

  • May 9, 2006 at 5:43 am

    #636684

    If you want to shrink them you can use dbcc shrinkdatabase or shrinkfile from QA.

    It is a bit strange that you can not see the system databases in EM. What account have you used to register the server in EM? Does this account have the permissions?

    regards,

    Holger

  • May 9, 2006 at 6:03 am

    #636689

    Thank you. Yes, it's funny. Using sa account. Anyway to get its out?

    Actually i try to attach the DB, but EM mentioned that the file is in use. Sigh.

    On QA, is the comman below correct?

    dbcc shrink model.mdf

    or

    dbcc shrink modellog.ldf

    Is that correct? Which one i need to issue first?? Will this affect the entire DB.??

    Pls guide. Thank you.

  • May 9, 2006 at 6:17 am

    #636693

    Right click on the Server in Enterprise Manager and select 'Edit SQL Server Registration Properties'. See if the Show system databases and system objects is unchecked. Check it to see system dbs.

     

  • May 9, 2006 at 6:27 am

    #636702

    Thank for the great help, yes, the object is unchecked.

    Oh ya. The file did not shrunk after i ran the shrink database. It's a huge 1.7G.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply