Sunday, February 12, 2012

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.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.

No comments:

Post a Comment