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$ : .
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?
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:
axavier1
76 Posts
1207
0
Posted 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