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.