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
Marcelo CamarateAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Vitor MontalvãoMSSQL Senior EngineerCommented:
I don't think it's a permission issue.
You should check if it's some heavy process running at same time and also check if the network bottleneck.
0
Marcelo CamarateAuthor Commented:
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
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
You should check if it's some heavy process running at same time and also check if the network bottleneck.
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

Marcelo CamarateAuthor Commented:
Hi Vitor,

Today, at 2:30 AM, I tried running the routine and the same error occurred.

The image below shows the existing infrastructure

INFRASTRUCTURE
I access the APPL_SERVER through a remote connection using an administrator login. Then, I establish a connection to DATABASE using a user that is owner of the database that I want to backup, and run the following command.

BACKUP DATABASE [<database name>] TO DISK = '\\APPL_SERVER\BACKUP.BAK'

Note that the path is in the network ("\\APPL_SERVER"). Ie, to the server that I'm logon. And it had been working fine until last week.

The problem is that don't have tools for network monitoring installed in APPL_SERVER, and I can not install any tool of this kind because the infrastructure is in my customer. Also, I haven't any user credential to login DATABASE_SERVER.

But I need to resolve the issue as soon as possible. Then, do you know (or other expert) a similar tool of the Microsoft Database Publishing? It does not work SQL Server 2008, because it was embed in Microsoft SQL Server Management Studio 2008, tool that also I can not install in APPL_SERVER in accordance with the policies of my customer. Would be ideal, because the Database Publishing generates a script to create/charge the database.

I'm waiting for your next suggestions.

Regards,

Marcelo Camarate
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Vitor MontalvãoMSSQL Senior EngineerCommented:
I'm sorry Marcelo. Somehow I missed your comment.
The database owner is a Domain Login or a SQL Login only?
0
Marcelo CamarateAuthor Commented:
Hi Vitor,

The database owner is a SQL Login only.

Regards,

Marcelo Camarate
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
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.
0
Marcelo CamarateAuthor Commented:
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
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Ok. Can you provide the link for the new question?
0
Marcelo CamarateAuthor Commented:
Hi Vitor,

The new questions is in http://whttp://www.experts-exchange.com/questions/28702123/SQL-Server-Web-tool-to-backup-restore.htmlww.experts-exchange.com/questions/28702123/SQL-Server-Web-tool-to-backup-restore.html.

Regards,

Marcelo Camarate
0
Marcelo CamarateAuthor Commented:
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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.