Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Change Collation Setting After Install 1

Status
Not open for further replies.
bradsta

bradsta

Programmer
Mar 27, 2003
4
GB
Hi,

I've got a live SQL Server installation that I need to change the setting of. I've found info on Books Online and need to back everything up, rebuild the Master database and then restore Master followed by the other databases.

Has anyone actually done this and is there anything else I should look out for? Also, where are DTS Local Packages stored so I can make sure those are backed up? It's a SQL Cluster, does that complicate anything?

Thanks,
Brad
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

TheBugSlayer
  • Locked
  • Question
High Availability - insert fails on primary replica but runs on secondary after failover.
Replies
0
Views
165
TheBugSlayer
TheBugSlayer
CodeWell
  • Locked
  • Question
SQL Server 2017 Install Issue - Database Not in Configuration Manager
Replies
0
Views
234
CodeWell
CodeWell
dgillz
  • Locked
  • Question
SQL Server timeouts after updating workstations to Windows 10
Replies
0
Views
174
dgillz
dgillz
Rajesh Karunakaran
  • Locked
  • Question
Restoring/Importing data from 2 backup files one after the other
Replies
0
Views
71
Rajesh Karunakaran
Rajesh Karunakaran
tekpr00
  • Locked
  • Question
Capture and Replicate Changes from Source to Target.
Replies
0
Views
65
tekpr00
tekpr00

Part and Inventory Search

Sponsor

Back
Top