Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
Jul 20, 1998

Backup

Question:
I am trying to back up a database to a disk backup device over a network. When I attempt my backup, I encounter an error 5 — Access denied. According to Microsoft, I need to have domain access rights. However, I seem to have full rights on all machines involved: my client, the server being backed up, and the server I am backing up to. Do you have any idea what I can do to fix this?

Answer:
Although you might have full rights, the ID that SQL Server is running under might not. Go to the services item in control panel and check who SQL Server is running under. In many cases it executes under the local system account. You can either change this to run under your account or, better yet, create an account just for this purpose.

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date