I have read, that I can customize client backup, creating scripts in order to the save command.
I want to make a sql backup. I have configured on the client configuration the MSSQL: save set with the nsrsqlsv backup command. It works good, but I want that when backup is finished, execute one .bat archive.
I have read, that with the savepnpc command you can put pre and post operations, but it only makes a files backups, because it invokes the save command which is different to make sql backups (nsrsqlsv).
Module for SQL does not have pre/post option. What eventually you could do is savepnpc which calls script where you first call nsrsqlsv with required arguments and when it exists you could call you bat file.
I use the way you say, but I can't view execution details in the Monitoring window, besides if I cancell the process, the nsrsqlsv process dosen't stop.
That's why I want to make an script for viewing the process.
Have you got any script which make these? Or how can I do it?
Script in essence would do the same thing thus you would end up with the same result. Perhaps writing down nsrsqlsv wrapper would be better idea. You replace existing nsrsqlsv with your wrapper script and you call it with all arguments passed to script and as second line you call your bat. I never did that on Windows, but I assume it should work.
ble1
6 Operator
•
14354 Posts
•
56186 Points
192
1
Posted November 25th, 2009 07:00