sql - Backup stored procedure for full, differential and log backup -

-

I have written a simple stored procedure to support full, differential and LOG backups. This is my stored procedure: 

  Order Process Backup DB (@base location as Varchar (1024), @ Backup Type varchar (32)) @Debanem varchar (255) = db_name () Announce @phrankname Varchar ( 256) Announce @DateTimeDate = GateTit () Set Type @ Backup = UPPER (@ Backup Type) @philname = @DNA + '_' + Right ('00 '+ cast (in the form of month (date) varchar (2)), 2) + +' _ '+ cast (in the form of the year (@date) varchar (4) '_' + True ('00' + cast (in the form of day (date varchar (2)), 2) + Varchar (2)), 2) + '_' + right ('00 '+ cast ('_' + Wright ('00' + Cast (Date of Date (H.H., Date @) varchar (2)), 2) + '_' + Writ ('00' + Cast (as dated (date, date, date) varchar (2)), 2) + '_' + right ('000' + cast (dated date) (MS, @ date) varchar (3 ), 3) + '_' + UPPER (back) Type "Type" Backup type "Complete" or "Backup Type", then type 'BAC' other 'TRN'), declare @ flowerpath form (1280) = "If Is correct (@besolution, 1) & lt; & Gt; Type '\' Set @ Base Location = @ Base Location + '\' End Set @ FullPath = @ Base Location + @ Filename Print @ FullPath @ Backup Type 'Full' Backup Database To Debnize Disc = @ FullPath Type A backup @ Backup = 'interface' backup databases by dbnmmed disk = @ fullpath interceptor end if the backup LOG @ DBName to disk = @ fullpath end and live   
 I ran My stored procedure and it passed Fully working to specifications. Now the next step is to create a SQL job for this. However, before doing this, I should know that this is the right process? I have read many articles and they all point out to a line "test backup strategy".  
 I now weekly, daily and weekly full backup, daily differential and log backup every 5 minutes.  
 Do you think this stored procedure is written incorrectly or do you think it should be fine for my scenario?   
 
 
 It looks good for me, if it's a programming exercise, then it's okay. (You need to make error trapping and reporting included). However, if you do not want to use SQL Express, as per the above, a maintenance plan will be done with all this error reporting. If you are using SQL Express, then there is a good program for free SQLBackupAndFTP which I've used and recommended over the years. It has excellent error reporting which I have recently experienced, when MSDB was corrupted. This will also back up an Amazon S3 account (paid version but not more) Here's the full story:

Comments

Post a Comment

Popular posts from this blog

excel vba - How to delete Solver(SOLVER.XLAM) code -

-
After opening several examples of macro / code written, I suddenly get stuck with a code that seems safe. Solver (SOLVER.XLAM) is doing this notation and I would like to remove it from my system. I do not think this is a relativant code. Can anyone tell me what should I do? I have already installed something to remove the password but Solver is still asking for password and I can not get rid of it! itemprop = "text"> Solver Excel is add-in If you want to delete it, then Excel Application & gt; Options & gt; Add-ins & gt; Search for 'Go to' button and gt; Uncheck the solver on the list like press something (I can not give you the exact path because I have the Polish version of Excel). Trying to open Solver's VBA code is not good because it There is allegedly copyright. Besides, I do not think Solver creates any disadvantages while working with Excel or VBA.
Read more

jsp - Google line chart x-axis shrinks on transition -

-
I am using a Google line chart on my page, which refreshes every 5 seconds but weird thing It is that every refresh chart causes the line to be removed, although the size of the chart remains the same. My script - google.load ('visualization', '1', {package: ['corechart']}); Google.setOnLoadCallback (drawLine); // call clickChart when the google.load () function meets the drawLine () {var gaugeData = new google.visualization.DataTable (); GaugeData.addColumn ('string', 'time'); // X-axis gazeta.dk column ('number', 'memory'); // Y-axis gazedata.edc column ('number', 'cpu'); // Y-axis square gauge option = {title: 'system description'}; // tile of var gauge chart; Var tempArray; // store json object value from server var tempArray2; // Server gauge = Modify the json object value = new google.visualization.LineChart (document.getElementById ('line_chart_div')); SetInterval (function () {$ aja...
Read more

java - Reaching JTextField in a DocumentListener -

-
So, I ended up making a Sudoku Solver, but I want to improve it. To do this, I need to reach betterJTextField to documentListener . I am using a documentListener to read from my betterJTextFields in real-time, I have the problem that insertUpdate (DocumentEvent e) . I need to reach Better Zest Field that happened to DocumentEvent . For example, if invalid input, would be better zestfield turn red etc. I have all my better zestfield in the matrix if you should know. Each area handles a number in the Sudoku. @ Override public zero inserted (DocumentEvent e) {// Code removed which checks that the input in the fine zest field is OK. } ( JFormattedTextfield extended JTextField ) public class betterJeststeffiledJFormattedTextField {private int row; Private int column; Public BetterJustStस्टfield (format format, infinite row, EIT column) {super (format); This.row = Line; This.column = Column; // To-O Auto-Generated Constructor Stub} Public Ent Miller () {ret...
Read more