Απ: error 2601

KelMan — Tue, 20 Mar 2007 23:24:56 GMT

Μάλλον είναι corrupted το log file. Δοκίμασε να κάνεις sp_attach_single_file_db χρησιμοποιώντας μόνο το data file. Αν τελικά παίξει, θα χάσεις ότι έχει μέσα το log file από το τελευταίο backup.

error 2601

lskostas — Tue, 20 Mar 2007 22:58:32 GMT

κατα την διαρκεια attach ενος mdf,ldf εμφανιζεται το εξης μηνυμα?

Error 2601

Severity Level 14

Message Text

Cannot insert duplicate key row in object '%.*ls' with unique index '%.*ls'.

Explanation

This error occurs when you attempt to put duplicate index values into a column or columns that have a unique index. Microsoft® SQL Server™ does not allow two rows to have the same index value (including NULL) in columns that have a unique index. SQL Server checks for duplicate values when the index is created and each time the table is modified using the INSERT or UPDATE statement.

Action

If you need duplicate index values in the indexed column(s), drop the unique index and create a nonunique index.

To use a unique index on data that contains duplicate values, you must change some values to prevent the duplication. You can change the data already in the table by using the SELECT or UPDATE statement, or you can change the data to be inserted.

SQL Server (και άλλες databases)