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)
  • 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: ESENT Logging
    ... SBS server 2003 has a backup job that will ... 145881 How to Use Jetpack.exe to Compact a WINS or DHCP Database ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • Re: Offline defrag
    ... Take a look at system utilization during BLB, specifically disk IO/ps ... If BLB reports corrupt item, it indicates problem with backup software, not with mailbox. ... how can I do some test to make sure everything in exchange - disk speed, network link throughput, read/writes of disk system - is working fine without dismounting the stores. ... Since white space in the database does not belong to any item BLB can not read it. ...
    (microsoft.public.exchange.admin)