Our user has a "live" system and and a completely separate "test" system which should have the same disk layout etc. Should "master" & "msdb" be refreshed from "live" to "test" along with users' database or just the users' database?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Refresh of system and user databases required?
- Thread starter grimwyre
- Start date
i proably wouldnt want to bring them over. If you have users in test that are needed in prod, add them. same goes for dts packages and any other changes.
I heartly reccomend that all changes made to test master and msdb be done via scripts then saved for the move to production. Dts packages can easily be saved as on the production system. Script everthing out. its a pain, but it helps to make sure you get everthing.
I heartly reccomend that all changes made to test master and msdb be done via scripts then saved for the move to production. Dts packages can easily be saved as on the production system. Script everthing out. its a pain, but it helps to make sure you get everthing.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question