Moving Database from one server to other

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Moving Database from one server to other

Moving Database from one server to other

Rate Topic

Display Mode

Topic Options

Author

Message

ramuvanparti

Posted Friday, October 02, 2009 3:00 AM

Old Hand

Group: General Forum Members
Last Login: Thursday, July 05, 2012 1:14 AM
Points: 326, Visits: 392

hi

is it good to copy master msdb and user db to new server and restart it. will this restore all the setting.

Post #796787

Silverfox

Posted Friday, October 02, 2009 3:29 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 6:50 AM
Points: 2,719, Visits: 1,065

ramuvanparti (10/2/2009)

hi

is 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?

--------------------------------------------------------------------------------------
Recommended Articles on How to help us help you and
solve commonly asked questions

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden
Managing Transaction Logs by Gail Shaw
How to post Performance problems by Gail Shaw
Help, my database is corrupt. Now what? by Gail Shaw

Post #796790

ramuvanparti

Posted Friday, October 02, 2009 4:47 AM

Old Hand

Group: General Forum Members
Last Login: Thursday, July 05, 2012 1:14 AM
Points: 326, Visits: 392

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

Post #796813

PaulB-TheOneAndOnly

Posted Friday, October 02, 2009 6:14 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 12:20 PM
Points: 2,982, Visits: 4,401

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.

Post #796825

ramuvanparti

Posted Friday, October 02, 2009 8:01 AM

Old Hand

Group: General Forum Members
Last Login: Thursday, July 05, 2012 1:14 AM
Points: 326, Visits: 392

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.

Post #796935

« Prev Topic | Next Topic »

Permissions