Marcelo Camarate
asked on
sql server 2008 R2 remote backup timeout expired
Hi,
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,
Marcelo Camarate
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,
Marcelo Camarate
ASKER
Hi Vitor,
Thanks for your reply.
I know that is not permission issue because, as I said in my last post, the routine work well until now. But, in the last two days I try to run it at several moments of the day without success. Therefore, the user that I connects to the database have permission to execute this command.
I said about permissions only in relation to change some parameter of the SQL Server installation, because I don't have the "sa" credentials.
Any other ideas?
Regards,
Marcelo Camarate
Thanks for your reply.
I know that is not permission issue because, as I said in my last post, the routine work well until now. But, in the last two days I try to run it at several moments of the day without success. Therefore, the user that I connects to the database have permission to execute this command.
I said about permissions only in relation to change some parameter of the SQL Server installation, because I don't have the "sa" credentials.
Any other ideas?
Regards,
Marcelo Camarate
You should check if it's some heavy process running at same time and also check if the network bottleneck.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I'm sorry Marcelo. Somehow I missed your comment.
The database owner is a Domain Login or a SQL Login only?
The database owner is a Domain Login or a SQL Login only?
ASKER
Hi Vitor,
The database owner is a SQL Login only.
Regards,
Marcelo Camarate
The database owner is a SQL Login only.
Regards,
Marcelo Camarate
That's why you couldn't have this working. A SQL Login doesn't have access to a network share. You'll need to run the BACKUP command with a Domain Login and that Login must be at least member of db_backupoperator role.
ASKER
Hi Vitor,
This is exactly why I closed this topic and open another titled "SQL Server - Web tool to backup / restore". You could read it and suggest something.
Thanks and Regards,
Marcelo Camarate
This is exactly why I closed this topic and open another titled "SQL Server - Web tool to backup / restore". You could read it and suggest something.
Thanks and Regards,
Marcelo Camarate
Ok. Can you provide the link for the new question?
ASKER
Hi Vitor,
The new questions is in http://whttp://www.experts-exchang e.com/ques tions/2870 2123/SQL-S erver-Web- tool-to-ba ckup-resto re.htmlww.experts-exchange.com/qu estions/28 702123/SQL -Server-We b-tool-to- backup-res tore.html.
Regards,
Marcelo Camarate
The new questions is in http://whttp://www.experts-exchang
Regards,
Marcelo Camarate
ASKER
I did not received any reply since Oct 16, 2014 and at August 1, 2015 I opened another question titled "SQL Server - Web tool to backup / restore" to try solve the same problem.
You should check if it's some heavy process running at same time and also check if the network bottleneck.