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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Restore: Collation ID is invalid

Author  Topic 

ewe1d@yahoo.de
Starting Member

17 Posts

Posted - 2004-11-09 : 03:44:01
Hi,
does anyone know what this is about?
- Added some files & filegroups to Northwind
- Did a database file backup and a differential file backup some time later
- Simulated a failure (stopped the sql server and deleted file)
- Backed up tail of log
- Restored the file backup and differential backup, all ok
- Restored tran log backups with norecovery, all ok
- Tried to restore tail of log with recovery, got following message:

Server: Msg 2774, Level 16, State 1, Line 1
Collation ID -16650191 is invalid.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE LOG is terminating abnormally.

Any ideas what's wrong here? This is MS SQL 2k Developer Edition (English) with SP3a running on Windows 2k Prof German. While I was testing the above I didn't change anything on the SQL Server.
Thanks
Chidd
   

- Advertisement -