p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   SQL Server 2000 (http://p2p.wrox.com/forumdisplay.php?f=20)
-   -   BackUp question (http://p2p.wrox.com/showthread.php?t=9665)

acko February 23rd, 2004 03:51 AM

BackUp question
He evryone
I 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?


All times are GMT -4. The time now is 09:07 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.