December 30, 2011 at 6:06 am
Hi Guys...
How to migrate sql server database and all system databases from one server to another server?
Reply.
thanks...
December 30, 2011 at 6:11 am
Saggy (12/30/2011)
Hi Guys...How to migrate sql server database
for user databases, detach copy and re attcah them or back them up and restore them.
Saggy (12/30/2011)
and all system databases...
you don't! You will need to extract any objects such as login agent jobs, etc and re import to the new server
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 30, 2011 at 8:36 am
December 30, 2011 at 8:39 am
Saggy (12/30/2011)
How to migrate sql server database and all system databases from one server to another server?
Adding on Perry's comment.
Is this a plain "migration" as in hardware refresh, no SQL Server upgrade at all - isn't it?
_____________________________________
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.Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply