get back deleted record

Question

i am in big trouble now. by mistake i was deleted the (some thing around 2,00,000) record from remote server(SQL 2008) table. is there any way,so i can get back this record.

please help,

thank you

additional *Server not granting me to access the backup file on server side.

Answer 1

for a quick fix, assuming no FK issues or a cascading delete:

1) restore backup to new database
2) in the database with the deleted data, run something like this:

INSERT INTO schema.YourTable
        (colA, colB, colC)
    SELECT
        colA, colB, colC
        FROM server.RESTORED_Database.schema.YourTable

if the table has an identity column use: SET IDENTITY_INSERT (Transact-SQL)

Answer 2

Restore it from the back-up database.