SQL Backup

[George Aviles]

I am running SQL 6.5. I have scheduled a backup to dump to a dat file. Instead of overwriting it , it adds to the file size which is nice if I want to restore from last week but that is not needed. I just want to get it to overwrite the file. Any help appriciated.
George

[Jason(UK)]

I'm having a similar problem, whenever I use the truncate table command, my table get smaller. Thank god for the Atlantic(Yanks!!)

[Eli Benjamin]

Before posting a sarcastic response, at least take the time to check that your statement is gramatically correct!

[Ray Miao]

Use 'wint init' option in your db dump statement.


------------
George Aviles at 2/11/00 8:51:32 AM


I am running SQL 6.5. I have scheduled a backup to dump to a dat file. Instead of overwriting it , it adds to the file size which is nice if I want to restore from last week but that is not needed. I just want to get it to overwrite the file. Any help appriciated.
George