Re: archieving and deleting SQL 2000 table

From: Uri Dimant (urid@iscar.co.il)
Date: 10/25/02 

From: "Uri Dimant" <urid@iscar.co.il>
Date: Fri, 25 Oct 2002 09:49:48 +0200

A. Tolga KILINĒ
Restore database as database_Archive from the backup your original database
Then you can write stored procedure transfering data from real database to
archive database (or to certian tables)

A. Tolga KILINĒ <kilinc@tis.havelsan.com.tr> wrote in message
news:Otut8Y$eCHA.2544@tkmsftngp11...
> 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
>
>

Relevant Pages

  • RE: How do I restore from mdf and ldf files?
    ... Tasks -> Backup Database ... Tasks -> Restore Database ... Windows 2003 Server with Latest Service Pack ... Pre-requisites for Sharepoint Backup and Restore: ...
    (microsoft.public.sharepoint.portalserver)
  • Re: RMAN restore of full backup fails completely
    ... You are not using a catalog database. ... You might have autobackup controlfile on, ... Your autobackup has been made *prior* to the backup! ... plus archivelog', when i try a restore on the other server however, the ...
    (comp.databases.oracle.server)
  • Backup and Restore Files
    ... What is the best way to backup and restore a runtime database file? ... pszDisplayName As String ...
    (microsoft.public.access.gettingstarted)
  • RE: ESENT Logging
    ... SBS server 2003 has a backup job that will ... 145881 How to Use Jetpack.exe to Compact a WINS or DHCP Database ... newsgroups so that they can be resolved in an efficient and timely manner. ...
    (microsoft.public.windows.server.sbs)
  • Re: NTBACKUP error
    ... Are you putting the oracle tablespaces in backup mode before doing the ... start of the backup which they will be doing if the database is ... Shutting down archive processes ... Undo Segment 1 Onlined ...
    (comp.databases.oracle.server)