archieving and deleting SQL 2000 table

From: A. Tolga KILINĒ (kilinc@tis.havelsan.com.tr)
Date: 10/25/02


From: "A. Tolga KILINĒ" <kilinc@tis.havelsan.com.tr>
Date: Fri, 25 Oct 2002 10:15:40 +0300


Hi,
there is a strict requirement from one of my customer that some SQL tables
never deleted before they are archieved. First problem is how to achieve
archieving? Can I do backup instead??
I can set a user as backup operator, but then he can not delete the table.
If I give rights to delete it, he can do it without backing it up!!
Please suggest a solution about the requirement.
Regards,
Tolga