October 2, 2009 at 3:00 am
hi
is it good to copy master msdb and user db to new server and restart it. will this restore all the setting.
October 2, 2009 at 3:29 am
ramuvanparti (10/2/2009)
hiis it good to copy master msdb and user db to new server and restart it. will this restore all the setting.
erm nope. Why would you do that? or even want to do that.
What are you trying to achieve?
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
October 2, 2009 at 4:47 am
actually i wanted to asked that. iam downgrading the current SQL Server 2005 from Enterprise edition to Devloper edition with all existing users on new installed SQL Server 2005.
So if copy master and msdb database to the data folder of the new installation and user db's and restart the services will i get every thing back as it was.
Regards
Ramu V
October 2, 2009 at 6:14 am
Unfortunatelly you will have to script credentials, jobs, etc. on source server then apply scripts on target server.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.October 2, 2009 at 8:01 am
initially plan was that only but when i scripted the user in SSMS . It didnt script the Database roles i was i fix. What i tried i have copied the master and msdb db's to new location of course i have stopped the service and then i have uninstalled the SQL Server 2005 enterprise edition and renamed the data folder to something else installed the developer edition with sp3 also. then stopped the service and stopped the service and then copied back the master and msdb database into renamed folder and then renamed the new created data folder and also copied resource db from new data folder to old data folder. finally renamed back the old data folder as it was earlier and then restarted the service. i got everything back as it was.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply