I have a remote routine to backup a SQL Server 2008 R2 database. The routine run in a different server of the database. So, I use the following command:
BACKUP DATABASE [<database name>] TO DISK = '\\<local server name>\BACKUP.BAK'
I do not connect to the database with the "sa" user, but with the database owner user, and the routine work well until now.
The problem is that now I get the error below when I run the routine:
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. When execute the SQL command (BACKUP DATABASE [<database name>] TO DISK = '\\<local server name>\BACKUP.BAK')
How I fix this?
It is important to remember that, as I haven't the "sa" user credentials, I can not change parameters of the SQL Server installation. Also, due to the strict security policy, initially my client does not permit this type of change.
Thanks in advance,