How do I know if we back up our database with the
overwrite option? By default, doess the back up just
append to the media? If that is the case, how can I set up
the backup with the overwrite option?
Thanks in advance, all helps are greatly appreciated.
Anh Tran.

SQL Server will append to the media and the way you would distiguish things
is through the position no. (FILE = )

Look at the options for BACKUP DATABASE (WITH INIT)

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Anh Tran" <atran (AT) sycamores (DOT) org> wrote