![]() ![]() ![]() I restored the master on another server withĪ different name but (as expected) couldn't get the details of sys.server_principals for getting the required info. I do have backup of master database on tape (Backup solution used : Litespeed to TSM). ![]() The situation we have is that the old server can not be bought online and its data disks etc. : For ‘French’ default language, the first day of the week is ‘Monday’ whereas for logins using ‘us_english’, the first day of week is ‘Sunday’Ī lot of application connect to this server and it would be the last option to contact each application owner for default_language details. As a result, many users started experiencing date related issuesįor e.g. So all logins were created with default language as 'us_english'. Apparently, this procedure doesn't take care of Default_language of logins. Using sp_help_revlogin ) for transferring logins. I also transferred logins,jobs,linked servers etc. I migrated more than 200 databases from one SQL server to a new SQL server. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |