Problemas con Respaldos de Db sql server y Vb net

Como Resuelvo que en mi Aplicacion de VB NET, ¿al hacer un BACKUP con una DB de SQL-SERVER de mas de 15 GB no mande TIME OUT?

Ya provee que se realice la copia en varios bak pero aun asi siempre manda time out

  dim query as string = "set statistics io on 
set statistics time on backup database " & txtdb.text.trim & " to disk = '" & txtpath.text & "\" & txtbackupname.text & "_1.bak' "
query = query & ",disk = '" & txtpath.text & "\" & txtbackupname.text & "_2.bak'"
query = query & ",disk = '" & txtpath.text & "\" & txtbackupname.text & "_3.bak'"
query = query & " with noformat, noinit,"
query = query & " medianame = '" & txtbackupname.text & "',"
query = query & " name = '" & txtbackupname.text & "', skip, norewind, nounload, compression,stats = 10 set statistics io off

ejecutado es

set statistics io on 

 set statistics time on

backup database sijatinvcar to disk = 'c:\xml\SIJATINVCAR_20200911_1.bak' ,disk = 'c:\xml\SIJATINVCAR_20200911_2.bak',disk = 'c:\xml\SIJATINVCAR_20200911_3.bak' with noformat, noinit, medianame = 'SIJATINVCAR_20200911', name = 'SIJATINVCAR_20200911', skip, norewind, nounload, compression,stats = 10

set statistics io off

set statistics time off

Que estoy haciendo mal.

Añade tu respuesta

Haz clic para o