We are looking at Data Domain to assist us in our growing disk space issues.

I read this forum without seeing code provided by our contact (reference to nsrsqlsv.exe).

I don't know if the configuration is different, but I'm trying to get something like this going:

declare @sname varchar(25),@dname varchar(25),@stmt varchar(1000)

select @sname='SERVER1',@dname='DATABASE1'

select @stmt='nsrsqlsv.exe ' /*backup executable*/

+'-s server.domain.net '/*networker server*/

+'-c '+@sname+'.domain.net '/*client server*/

+'-A '+@sname+'.domain.net '/*virtual-server, for clusters*/

+'-l full '/*level*/

+'-S 10 '/*number of stripes (threads) */

+'-a "device interface=data domain" ' /*duplication node*/

+'-b "ourPool" '/*backup pool*/

+'-g "ourGroup" '/*group*/

+'"MSSQL:'+@dname+'"'/*database name*/

print @stmt

exec xp_cmdshell @stmt

I'll try to remember to repost when we get this working. We have a trial of NetWorker (they don't do that very often).