I have a SQL backup plan that writes the backups to a SAMBA network share. I have a T-SQL net use (with persistent:yes
) script that is the first part of the maintenance plan to access the share. This worked for a while but now it is failing now on my larger databases. Samba just says "write_data: write failure in writing to client 0.0.0.0. Error Broken pipe" in the log. In SQL Server, I just get Operating system error 64(The specified network name is no longer available').
If I backup just the big database manually with "Tasks" in SQL Server, it works.