>We have a file with identity column. An old record, with identity key value 6447, has been deleted by accident. I need to insert this record back with the same value. The file is live and in constant use. How can I insert this record back into the file.

---

Take a look at

SET IDENTITY_INSERT

T-SQL command.