Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
blakmk
Starting Member
45 Posts |
 Posted - 2003-05-14 : 06:56:16
|
| Does anyone know if its possible to restore a database with a different collation settings? |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-05-14 : 07:37:41
|
quote:
After a collation has been assigned to any object other than a column or database, you cannot change the collation except by dropping and re-creating the object. This can be a complex operation. To change the default collation for an instance of Microsoft® SQL Server™ 2000 you must: - Make sure you have all of the information or scripts needed to re-create your user databases and all of the objects in them.
- Export all of your data using a tool such as bulk copy.
- Drop all of the user databases.
- Rebuild the master database specifying the new collation.
- Create all of the databases and all of the objects in them.
- Import all of your data.
Note Instead of changing the default collation of an instance of SQL Server 2000, you can specify a default collation for each new database you create.Books Online - "Changing Collations"
Jay White{0} |
 |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-05-14 : 07:40:40
|
| You can restore a database, then change the default collation, if that's what you mean... The database has a default collation, but can still contain objects with other collations. |
|
|
|
|
|
|
Restore database with different collation setting