collation problems

hello, i'm restoring a backup of a database of other sql server
instance, but this database has the collation: modern_spanish_cl_as,
the collation of my sql server is: sql_latin_general_cp1ci_as, its
posible change the collation of the database that i restoring
(modern_spanish_cl_as)?
thanksYou don't need to change Collation for restoring the database. SQL Server
will allow you to restore a database of modern_spanish_cl_as Collation on th
e
server with sql_latin_general_cp1ci_as Collation. Here is related informatio
n
from BOL (collations, multiple):
Collations in BACKUP and RESTORE
If you restore a database, RESTORE uses the collation of the source database
that was recorded in the backup file. The restored database has the same
collation as the original database that was backed up. Individual objects
within the database that have different collations also retain their origina
l
collation. The database can be restored even if the instance on which you ru
n
restore has a different default collation than the instance on which BACKUP
was run.
If there is already a database with the same name on the target server, the
only way to restore from the backup is to specify REPLACE on the RESTORE
statement. If you specify REPLACE, the existing database is completely
replaced with the contents of the database on the backup file, and the
restored version of the database will have the same collation recorded in th
e
backup file.
If you are restoring log backups, the destination database must have the
same collation as the source database.
"hongo32" wrote:

> hello, i'm restoring a backup of a database of other sql server
> instance, but this database has the collation: modern_spanish_cl_as,
> the collation of my sql server is: sql_latin_general_cp1ci_as, its
> posible change the collation of the database that i restoring
> (modern_spanish_cl_as)?
> thanks
>|||hello absar, i don't understand very well... i need to make a database
whit the collation that i want... and over that database restore de
backup... then, the backup take the backup of the 'target' database...
it this right?|||The restored database on the target server will have collation of the source
database. If you create a database with the target's collation to restore
from the backup file, you will have to specify the Replace option in the
command for database restoration. And the 'Replace Option' will ensure that
the 'restored version of the database will have the same collation recorded
in the backup file'.
However, you have the option of changing collation of the restored database.
After restoring the database on the target server, you can use the 'ALTER
DATABASE ...... COLLATE ...' and 'ALTER TABLE...... COLLATE ...'
commands. Please see details in the BOL (collations, changing).
"hongo32" wrote:

> hello absar, i don't understand very well... i need to make a database
> whit the collation that i want... and over that database restore de
> backup... then, the backup take the backup of the 'target' database...
> it this right?|||ok, thanks... i don't understand what you mean whit: BOL... is books
on line... jejejeje... thanks again, bye