Hi

I am wanting to trip some records from a DB before I do a backup. I
plan to get a copy of the DB, run some delete SQLs and then backup.
Sound ok?

Anyway the only same way I know to copy a running DB is to Backup and
restore. Is there another way I could use as otherwise my process
becomes...

Backup DB
Restore DB to temp area
Remove Data
backup temp DB

i.e. two backups and one restore to create once backup.

Thanks
Rob