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

    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
    Kansas City, MO
    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.
    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