Highlighted
1 Copper

SQL backup parallelism

Hi all,

Is it possible to achive parallelism for SQL backups using Networker Module for MSSQL?

Even if the client is configured for parallelism Networker only runs one database at the time.

We have MS SQL environments with almost 3000 databases and running them in sequence takes ages.

In earlier version of the module (v2.0 or so) i think I remember Networker was able to create multiple instances of nsrsqlsv.

We currently run Networker 7.6 and NMSQL v5.2.1.

regards,

Stefan

Reply
3 Replies
Highlighted
2 Iron

Re: SQL backup parallelism

Hi Stefan,

     It´s possible increase parallelism for SQL using NMSQL, just put MSSQL:<database_name> in client save set for a single instance SQL Server, multiple instance SQL Server use MSSQL$<instance>:<database_name>.

Regards,

Anderson Xavier

Reply
Highlighted
4 Ruthenium

Re: SQL backup parallelism

You can simply set the save set as MSSQL: and set the client parallelism to 4 or 8 Or whichever way you want. Based on the parallelism set, Networker picks up the databases simultaneously and backs them up. Is your group parallelism, server parallelism and target sessions set properly?

Reply
Highlighted
1 Copper

Re: SQL backup parallelism

NetWorker Module for Microsoft SQL Server also supports the use of multiple stripes for backing up and restoring Microsoft SQL Server data. (Though specifying each database separately should also send more than one stream). This option works better when using multiple tape drives (preferably one tape per stripe). To use stripes, you can append -Sn to the nsrsqlsv command, for example:

nsrsqlsv -S3
Reply