SQL Backup Question

jyoung127
jyoung127 used Ask the Experts™
on
Running Tsql to backup database nightly but the .bak file keeps growing. Is there a Tsql that will overwrite the .bak file?  
I am running the following:
 backup database [DBNAME]
to disk = '[Path]/name.bak'
Go
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Senior .Net Developer
Commented:
backup database [DBNAME]
to disk = '[Path]/name.bak' WITH INIT

Author

Commented:
Perfect thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial