August 20, 2010 at 8:45 pm
Installed a new server with diffrent collation from old server as that was the requirement so as to match the collation with all other servers in our environment.
After installing the new server when i try to check properties of any system databases i am getting a collation conflict error and i also tried restoring a database from old server and it restored with old collation, how do i resolve this issue?
I have to restore all databases from old server and the database has to match collation with the new server.
August 20, 2010 at 9:52 pm
How can i use different collation while restoring a database?
August 21, 2010 at 12:50 am
You can issue ALTER DATABASE... with COLLATE option but that will apply to only new objects. You can try using Collation Changer.
You may find this article useful
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 21, 2010 at 8:46 am
I am trying to alter "msdb" database but i dont think it will allow to do for system databases and so how would i restore msdb with differnt collation?
August 22, 2010 at 11:29 pm
you are right msdb db can not be altered. Instead of restoring this as different collation I would transfer contents like jobs, alerts/operators etc manually from old msdb db to new msdb.
[font="Verdana"]--www.sqlvillage.com[/size][/font]
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply