Solved

SQL Server Backups

Posted on 1998-09-26
1
211 Views
Last Modified: 2010-03-19
The SQL Server Backup seems have a bug: I want that he re-init the backup all weeks, and make a backup all the days, but the dump command, with the options: "..., init, retaindays=7, ..." don't convainced me.
0
Comment
Question by:ahampe
1 Comment
 
LVL 2

Accepted Solution

by:
Ezhil earned 50 total points
ID: 1090289
You cannot directly do this in a single scheduled command. But you can do like this. Create two commands, One runs every week, initialises the device and takes the backup. The second should run every day except the day the first one runs, and should take the backup to the same device without initialising.I hope this will  solve your problem.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now