Solved

SQL Server Backups

Posted on 1998-09-26
1
205 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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

707 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

20 Experts available now in Live!

Get 1:1 Help Now