Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    49

    Unanswered: autoshrink and msdb question

    I have a test database and I detach and reattch this database during my testing on my test system. This database is originally from my production system. I have a couple questions that came up during my testing:

    1. When you detach/attach a database from a different server with the same setup, does it gather it database setup information from the model database on the current server?

    2. When you switch the autoshrink database option from enable to disable, do you have to restart the server?

    3. How to you change the default make of the model database?

    Thanks in advance for any help.

  2. #2
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    1. No. It doesn't need to. It just attaches it. You can have users out of sync if you do this though, because the users main information is stored in master.

    2. No.

    3. errrrr, what???? You just change it. You might want to explain this one a little.
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •