Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
John_Idol
Starting Member
39 Posts |
 Posted - 2007-06-13 : 12:22:24
|
| Hi All,I got a job which runs every day this T-SQL code:BACKUP DATABASE [myDB] TO DISK = N'f:\BACKUPSDaily\myBKUP.bak' WITH NOINIT , NOUNLOAD , NAME = N'mybackup', NOSKIP , STATS = 10, NOFORMATIt runs just fine but in append Mode (the default one); the bak file is being taped every night, so I would like to overwrite it, in order it not to become huge after a few time, but I can't seem to find a clear way to do this.Any help or pointing would be appreciated!Cheers,Giovanni |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-13 : 12:30:44
|
| Change noinit to init. |
 |
|
|
John_Idol
Starting Member
39 Posts |
Posted - 2007-06-14 : 05:09:25
|
| thanks a million!G |
|
|
|
|
|
|
how to shut down BACKUP APPEND mode?