Hi!

I wish i could backup a database so that some tables (precomputed
data) get backed up empty to save disk space.

Only way I can do it now is
1) backup database
2) restore the backup to a temporary database
3) connect to temp database and delete the computed info
4) backup again

Can anyone suggest a faster/simpler procedure?

Maybe steps 1 and 2 could be replaced by copying the database file to
a new file but I guess simply copying an online database is not safe.
Or is it?

Is there some other way for making a copy of an online database?

thanks in advance!

Aivar