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 |
|
stooartbaby
Starting Member
1 Post |
 Posted - 2009-10-26 : 21:03:27
|
| Hi Guys,I am trying to create a nightly backup script for a DB, this one below works fine except that it appends the data each night... i just need it to overwrite. I think it has something to do with the NOINIT ?? is that correct?? i would really apprieciate some help...Thanks,Stuart.++++++++++++++++++++++BACKUP DATABASE [appname_local] TO DISK = N'D:\appname\appname_Backup\appname_DB_Nightly', DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\appname_local.bak' WITH NOFORMAT, NOINIT, NAME = N'appname_local-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10GO++++++++++++++++++++++ |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
SQL Backup script