Unsolved
This post is more than 5 years old
9 Posts
0
2221
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
axavier1
76 Posts
0
April 23rd, 2010 15:00
Hi Stefan,
It´s possible increase parallelism for SQL using NMSQL, just put MSSQL: in client save set for a single instance SQL Server, multiple instance SQL Server use MSSQL$ : .
Regards,
Anderson Xavier
amediratta
2K Posts
0
April 24th, 2010 11:00
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?
nsoto
16 Posts
0
April 24th, 2010 16:00
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: