T-Sql Script for SQL Server Backup Maintenance Plan? -

-

What is a T-SQL script for a backup maintenance plan? I want to manage it with the app.

In fact, I want to configure Auto Backup with Task Scheduler with T-SQL script from the app.

Thank you.

OK

You should use a SQL agent

In Object Explorer, connect to SQL Server, expand 'SQL Server Agent' node, expand Jobs; right click ;

Create a backup job

Click on 'New' to create a new job. Step

Type a name for the job step and type the T-SQL statement in the backup database

and in the last step, you can click ok to save or generate the script You can click on "script" to do this in your program.


Comments

Post a Comment

Popular posts from this blog

c++ - C/pp Sockets, recv()/send() works only under gdb -

-
Edit: In the socket: The CanReceive () argument was the reason I was checking the input 1 millisecond While stepping into GDB, everything worked out. I have a problem with C sock send () / recv () do nothing if they are in non-debug mode. Even if std :: cout can not return their return value for some reason std :: cout is not working in my method I std: : Cerr can not even make a mistake It does not make sense to check that in GDB, because everything works perfectly as a virus in non-debug mode. C does not. //b - buffer // s - size // sd - socket descriptor int32_t TCP :: reception (char * b, uint32_t s) {error :: critical. SetErrorNumber (error: List :: noor); If (! Socket :: valid (sd)) {error :: serious .sitemember (error :: list :: invalid socket); Return -1; } If (Disconnect ()) {Error :: Critical. SetErrorNumber (Error :: List :: Notepanked); Return -1; } If returned (! Socket :: canvasive (SD, readtimeout)) incorrect; If (! B) {B = new four [S + 1]; Std :: mem...
Read more

GO: Serve static pages -

-
I'm trying to display a static page with Go. Go: Package main import "net / http" function main () {fs: = http.FileServer (http.Dir ("static / house")) Http: .handle ("/", fs) http.ListenAndServe (": 4747", zero)} directory: project / stable home Html edit.html project.go When I run it, the web page displays links to edit.html and home.html instead of displaying a static page from home.html is. What am I doing wrong. Is this the best way to serve files? I know that there are other ways like From the HTML / templates package, but I'm not sure what is the difference between each of these methods and when. Thanks! fancy main () {http.Handle ("/", http.FileServer (Http) .ir ("static")) http.ListenAndServe (": 4747", zero)} You do not need static / home , just Static . and when you do not have index.html in / static , the directory instead Content appears. Just change the name of...
Read more

objective c - How to open front/back camera at the same time in iOS developing? -

-
I want to use the front and rear camera at the same time in iOS development: when I take a photo back After the camera, the front camera can be opened and another can take a photo. By the way, these two photos are in a picture: vertical arrangement. Has anyone done this before? UIImagePickerController to take the picture, and to determine which camera is used Is in. / P> To merge the pictures, I found an example through search (its recommendation in the future)
Read more