Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SQL Backup

Posted on 2014-08-08
1
Medium Priority
?
103 Views
Last Modified: 2014-08-21
How to create an addition task on SQL Backup Job such that it will remove all subfolder under a particular directory before starting the backup job ?

Tks
SQLBackup.png
0
Comment
Question by:AXISHK
1 Comment
 
LVL 23

Accepted Solution

by:
Thomas Grassi earned 2000 total points
ID: 40250631
You can use t-sql and setup a script to run once you get the script with the sql command created you save it to your c drive then you can add code to delete folders or files using dos commands

check this out

http://msdn.microsoft.com/en-us/library/ms170572.aspx

Hope this helps
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

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

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

571 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