Wrox Programmer Forums
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old February 23rd, 2004, 03:51 AM
Authorized User
Join Date: Jun 2003
Posts: 60
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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?


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create backup folder & also backup files miracles Excel VBA 0 April 16th, 2007 02:28 AM
Backup scandalous Access 3 February 9th, 2007 01:19 PM
Backup help slesicki SQL Server 2005 2 December 28th, 2006 05:11 AM
What's the best way to backup? thomasks Visual Basic 2005 Basics 2 September 13th, 2006 03:36 PM
Backup (newbie question) Graham SQL Server 2000 2 June 13th, 2003 03:39 AM

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