UNSOLVED

ulma

updated

17 years ago

U

ulma

5 Posts

0

539

November 25th, 2009 03:00

Script for Sql backup

Hi!!

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).

How can I solve my problem?

Does somebody customized scripts to make backups?

Somebody has configured some client in this way?

Thanks in advance.

  • ble1

    6 Operator

    •

    14354 Posts

    •

    56186 Points

    192

    1

    Posted November 25th, 2009 07:00

    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.
  • ulma

    5 Posts

    192

    0

    Posted November 25th, 2009 08:00

    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?

  • ble1

    6 Operator

    •

    14354 Posts

    •

    56186 Points

    192

    0

    Posted November 25th, 2009 10:00

    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.