Cannot view database properties

Hello all....

I am in the process of changing all of the collation to SQL_Latin1_General_CP1_CI_AS.

I have backed up all databases, and uninstalled SQL Server 2005. I then reinstalled SQL Server 2005, setting the server collation to SQL_Latin1_General_CP1_CI_AS.

The user databases have been restored and are accessible by all applications.

If I try to view the properties of any database (system or user), I get the following error:

*********************************************************************************************************************************

TITLE: Microsoft SQL Server Management Studio

Cannot show requested dialog.

ADDITIONAL INFORMATION:

Cannot show requested dialog. (SqlMgmt)

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AI" in the equal to operation. (Microsoft SQL Server, Error: 468)

****************************************************************************************************************************************

I have tried executing the "Alter Database [dbname] Collate SQL_Latin1_General_CP1_CI_AS" procedure, but that does seem to help. Does anyone have any ideas?

Thanks,

Forch

What is the collation or all the databases?

run select * from sys.databases.

How did you restore the databases, backup/restore, attach/dettach?

|||

Master is SQL_Latin1_General_CP_C1_AS, and the rest of the system dbs is Latin1_General_CI_AI. The user dbs are evenly divided between the 2.

I can't remember how I restored.... it was probably backup / restore.

Thanks,

Forch

|||

Hi Forch,

Probably the backed up databases have the old collation, but the SQL server system databases have the new collation.

You can do:

ALTER RESTORED_DATABASE { COLLATE SQL_Latin1_General_CP1_CI_AScollation_name }

to change the collation of the restored databases to the new collation

Cheers

|||Have you tried to access the database from the query analyzer too?

Cannot view database properties

Hello all....

I am in the process of changing all of the collation to SQL_Latin1_General_CP1_CI_AS.

I have backed up all databases, and uninstalled SQL Server 2005. I then reinstalled SQL Server 2005, setting the server collation to SQL_Latin1_General_CP1_CI_AS.

The user databases have been restored and are accessible by all applications.

If I try to view the properties of any database (system or user), I get the following error:

*********************************************************************************************************************************

TITLE: Microsoft SQL Server Management Studio

Cannot show requested dialog.

ADDITIONAL INFORMATION:

Cannot show requested dialog. (SqlMgmt)

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AI" in the equal to operation. (Microsoft SQL Server, Error: 468)

****************************************************************************************************************************************

I have tried executing the "Alter Database [dbname] Collate SQL_Latin1_General_CP1_CI_AS" procedure, but that does seem to help. Does anyone have any ideas?

Thanks,

Forch

What is the collation or all the databases?

run select * from sys.databases.

How did you restore the databases, backup/restore, attach/dettach?

|||

Master is SQL_Latin1_General_CP_C1_AS, and the rest of the system dbs is Latin1_General_CI_AI. The user dbs are evenly divided between the 2.

I can't remember how I restored.... it was probably backup / restore.

Thanks,

Forch

|||

Hi Forch,

Probably the backed up databases have the old collation, but the SQL server system databases have the new collation.

You can do:

ALTER RESTORED_DATABASE { COLLATE SQL_Latin1_General_CP1_CI_AScollation_name }

to change the collation of the restored databases to the new collation

Cheers

|||Have you tried to access the database from the query analyzer too?

Cannot restore databae successfully

Hi all,
I backed up a database called Citrix_DB through Enterprise Manager from a standalone MSSQL 2000. I tried to restore the DB to another MSSQL 2000 Cluster but failed. Would anyone know how to get it fixed? Thanks a lot. And below is the error message: -
Microsoft SQL-DMO (ODBC SQLState: 42000)
Cannot use file 'e\SQL-Data\MSSQL\data\Citrix_DB_Data.MDF' for clustered server. Only formatted files on which the cluster resource of the server has a dependency can be used. File 'Citrix_DB_Data' cannot be restored to 'e:\SQL-Data\MSSQL\data\Citrix_DB_Data.MDF'. Use WITH MOVE to identify a valid location for the file.
Cannot use file 'e\SQL-Data\MSSQL\data\Citrix_DB_Data.LDF' for clustered server. Only formatted files on which the cluster resource of the server has a dependency can be used. File 'Citrix_DB_Log' cannot be restored to 'e:\SQL-Data\MSSQL\data\Citrix_DB_Data.LDF'. Use WITH MOVE to identify a valid location for the file.
RESTORE DATABASE is terminating abnormally.
Regards,
On your new cluster, you have not made drive E: a dependency for SQL Server.
If you have a shared drive E:, then:
1) Take SQL Server offline
2) Create a disk resource for drive E:
3) Bring up the properties for the SQL Server service and make drive E: a
dependency
4) Bring the SQL Server group online
5) Restore your DB
If you don't have a drive E:, then restore the backup to another drive which
is a dependency for SQL Server.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
..
"vt2006" <someone@.somewhere.com> wrote in message
news:uYNrFdH8GHA.4572@.TK2MSFTNGP02.phx.gbl...
Hi all,
I backed up a database called Citrix_DB through Enterprise Manager from a
standalone MSSQL 2000. I tried to restore the DB to another MSSQL 2000
Cluster but failed. Would anyone know how to get it fixed? Thanks a lot. And
below is the error message: -
Microsoft SQL-DMO (ODBC SQLState: 42000)
Cannot use file 'e\SQL-Data\MSSQL\data\Citrix_DB_Data.MDF' for clustered
server. Only formatted files on which the cluster resource of the server has
a dependency can be used. File 'Citrix_DB_Data' cannot be restored to
'e:\SQL-Data\MSSQL\data\Citrix_DB_Data.MDF'. Use WITH MOVE to identify a
valid location for the file.
Cannot use file 'e\SQL-Data\MSSQL\data\Citrix_DB_Data.LDF' for clustered
server. Only formatted files on which the cluster resource of the server has
a dependency can be used. File 'Citrix_DB_Log' cannot be restored to
'e:\SQL-Data\MSSQL\data\Citrix_DB_Data.LDF'. Use WITH MOVE to identify a
valid location for the file.
RESTORE DATABASE is terminating abnormally.
Regards,

Cannot restore

I have backed up a database created a .bak.
Now I created another database with other name. Then tried to restore the
.bak file into this new database.
However, I got an error:
"The backup set int file 'D:\Temp\Employee.bak' was created by BACKUP
DATABASE...FILE=<name>
and cannot be used for this restore operation.
RESTORE DATABASE is terminating abnormally.
Any idea?Alan
How many files the .BAK file is contain?
Check out 'WITH MOVE...' command in the BOL
"Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:%235AfdvxoGHA.4996@.TK2MSFTNGP05.phx.gbl...
>I have backed up a database created a .bak.
> Now I created another database with other name. Then tried to restore the
> .bak file into this new database.
> However, I got an error:
> "The backup set int file 'D:\Temp\Employee.bak' was created by BACKUP
> DATABASE...FILE=<name>
> and cannot be used for this restore operation.
> RESTORE DATABASE is terminating abnormally.
> Any idea?
>|||Sorry, what do you mean by "How many files the .BAK file is contain" ?
I tried to restore in EM and got the error.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OYsjJ1yoGHA.524@.TK2MSFTNGP05.phx.gbl...
> Alan
> How many files the .BAK file is contain?
> Check out 'WITH MOVE...' command in the BOL
>
>
>
> "Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
> news:%235AfdvxoGHA.4996@.TK2MSFTNGP05.phx.gbl...
>>I have backed up a database created a .bak.
>> Now I created another database with other name. Then tried to restore the
>> .bak file into this new database.
>> However, I got an error:
>> "The backup set int file 'D:\Temp\Employee.bak' was created by BACKUP
>> DATABASE...FILE=<name>
>> and cannot be used for this restore operation.
>> RESTORE DATABASE is terminating abnormally.
>> Any idea?
>|||Alan T wrote:
> Sorry, what do you mean by "How many files the .BAK file is contain" ?
> I tried to restore in EM and got the error.
>
You might have to use the REPLACE option if you want to overwrite an
existing database and use WITH MOVE if the files has to be moved to
another location. Try looking up RESTORE DATABASE in Books On Line. Here
you can find the syntax.
Regards
Steen Schlüter Persson
Databaseadministrator / Systemadministrator

Cannot restore

I have backed up a database created a .bak.
Now I created another database with other name. Then tried to restore the
.bak file into this new database.
However, I got an error:
"The backup set int file 'D:\Temp\Employee.bak' was created by BACKUP
DATABASE...FILE=<name>
and cannot be used for this restore operation.
RESTORE DATABASE is terminating abnormally.
Any idea?Alan
How many files the .BAK file is contain?
Check out 'WITH MOVE...' command in the BOL
"Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:%235AfdvxoGHA.4996@.TK2MSFTNGP05.phx.gbl...
>I have backed up a database created a .bak.
> Now I created another database with other name. Then tried to restore the
> .bak file into this new database.
> However, I got an error:
> "The backup set int file 'D:\Temp\Employee.bak' was created by BACKUP
> DATABASE...FILE=<name>
> and cannot be used for this restore operation.
> RESTORE DATABASE is terminating abnormally.
> Any idea?
>|||Sorry, what do you mean by "How many files the .BAK file is contain" ?
I tried to restore in EM and got the error.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OYsjJ1yoGHA.524@.TK2MSFTNGP05.phx.gbl...
> Alan
> How many files the .BAK file is contain?
> Check out 'WITH MOVE...' command in the BOL
>
>
>
> "Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
> news:%235AfdvxoGHA.4996@.TK2MSFTNGP05.phx.gbl...
>|||Alan T wrote:
> Sorry, what do you mean by "How many files the .BAK file is contain" ?
> I tried to restore in EM and got the error.
>
You might have to use the REPLACE option if you want to overwrite an
existing database and use WITH MOVE if the files has to be moved to
another location. Try looking up RESTORE DATABASE in Books On Line. Here
you can find the syntax.
Regards
Steen Schlter Persson
Databaseadministrator / Systemadministrator