Please rate this item: 1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

SQL: Reinstalled SQL Server 2005, with the wrong collation??

If yes, then following the instructions below[ref]Please ensure you test any script taken from my website on a test/development machine, before running on a production server.[/ref], from MSDN (http://msdn.microsoft.com/en-us/library/ms179254.aspx):

  • Make sure you have all the information or scripts needed to re-create your user databases and all the objects in them. See my note below
  • Export all your data using a tool such as bulk copy
  • Drop all the user databases.
  • Rebuild the master database specifying the new collation in the SQLCOLLATION property of the setup command. For example:

start /wait setup.exe /qb INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=test SQLCOLLATION=SQL_Latin1_General_CP1_CI_AI

  • Create all the databases and all the objects in them.
  • Import all your data.

However, if you detach your databases instead of exporting all the data, you can simply re-attach the databases once the rebuild is complete.  I was having problem with an installation of SQL Server, and when I had the server rebuilt, I selected the wrong collation for the server.  The database was correct, so I just detached the database before rebuilding the master, and now everything is fine

🙂

Leave a Reply

Your email address will not be published. Required fields are marked *

CJayMead's SQL Server, Endeca, MS Office Help © 2018