June 17, 2009 at 11:47 am
I am re installing my sql server enterprise due to collation conflicts errors.
1. Dettach all databases
2.install sql server
3.Attach all databases
Please Let me know if in need to keep track of anything before uninstalling sql server.
Also is there any script that attach all the databases which has mutlple files for each db.
June 17, 2009 at 11:54 am
I hope u've already planned but thought it worthwhile to mention here.
1. Are you going to restore msdb from backup? If not, you might want to script out all ur jobs and then apply the script to the new installation.
2. Since u're reinstalling because of collation changes which are stored in master, i rule out the possibility that u'll be restoring master database. In this scenario, script out ur logins.
June 17, 2009 at 12:33 pm
do i need to update statistics after attaching databases and anything else to be done?
June 17, 2009 at 1:01 pm
under Latin1_General what is the option i have to select to get
Latin1_General_CI_AS
Option are
Binary
CAse-sensitive
Accent - sensitive
Binary- code point
Kana-sensitive
Width-sensitive
June 17, 2009 at 11:53 pm
Tara (6/17/2009)
do i need to update statistics after attaching databases and anything else to be done?
That wont be necessary as you will be restoring the databases on the same version of sql server. If you were upgrading from say 2000, you might need to update the statistics.
DBCC SHOW_STATISTICS (table_name , index_name)
will show you when the statistics for a particular index on a table were updated. Generally this should not be a cause of concern. Check if auto update statistics is turned ON on ur database.
under Latin1_General what is the option i have to select to get
Latin1_General_CI_AS
Generally Latin1_General_CI_AS collation settings supports wide range of languages. If you're using english as ur default language, then leave it as default. The list of entire collation settings for various languages is here: http://msdn.microsoft.com/en-us/library/ms143508.aspx
You may want to refer http://msdn.microsoft.com/en-us/library/ms143515(SQL.90).aspx"> http://msdn.microsoft.com/en-us/library/ms143515(SQL.90).aspx for various sort orders. Leave it to defaults if you're using english and if you're not upgrading.
For backward compatibility, you may want to use SQL Collation.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply