We help IT Professionals succeed at work.
Get Started

SQL DB Backup to External Drive

279 Views
Last Modified: 2016-02-05
This is a single user, non networked machine.  SQL Server 2014 Developer, Win 7 Pro

I have an old fashioned .Bat file I run periodically that copies non SQL files to an external drive.

I recently started using SQL Server.

To back up SQL I originally added the directory where the SQL files are located to the .bat file but they won't copy.  I get an 'Access Denied' message and they are bypassed.

I don't know why I would be denied access since this is a single user machine and I am the only user.  I am denied access even if I run the bat file as Adminstrator (Run as Administrator)

The SQL DB was created on another machine, backed up and then restored on this machine.  Perhaps that has something to do with it.

Currently, when I want to back up the SQL DB, I do it manually using the 'Task', 'Backup' option from within the SQL Manager.

Is there a way to run the SQL backup I have set up in the SQL Manager from a bat file?

Are there better ways to accomplish this?

I have been looking into Cloud backups Carbonite, SOS, etc.. but I am hesitant because I'm not sure that they would be able to backup the SQL files either.
Comment
Watch Question
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 4 Answers and 16 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE