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 |
|
acko
Yak Posting Veteran
52 Posts |
 Posted - 2004-02-23 : 02:50:18
|
| He evryoneI need help about backup. I have a several questions about this situation.In Database Maintenance Plan i created plan for backup some database. BackUp occurs every day at 01.00h, on disk to some directory on the network. I checked option Remove files older then (3 days). DMPlan created for me job that works backup. Job creates new bak file every day and remove files older than 3 days. So, i always have 3 .bak files in the backup directory.But if I create job by myself with standard backup statement (back up database ...) , i can put with noinit option so i will append .bak file to .bak file and i will have only one file in backup directory.1) If i use the DMPlan how can i use with noinit option?2) If i use BackUp Database statement how can i remove files older than some days?3) What is better solution, keep 3 or more diferent .bak files or only one with noinit option?ThanksAlex |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-02-23 : 03:54:13
|
| imhoIn Database Maintenance Plan i createdBad ideaBut if I create job by myself with standard backup statement Good ideaappend .bak file to .bak file and i will have only one file in backup directorybad ideaIf you append to a single file and that file gets corrrupted you lose all the files - backups should be as simple as possible as probably the most important part of the system.1) Don't bother2) Code to do deletes - better put this function in the process that copies the backups off the m/c (you do have this don't you?).3) 3 files - include the date in the filename.seehttp://www.nigelrivett.net/BackupAllDatabases.html==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
acko
Yak Posting Veteran
52 Posts |
Posted - 2004-02-23 : 10:01:45
|
| what is m/calex |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-02-23 : 11:18:56
|
| m/c = machine.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
BackUp question