troubleshooting Question

SQL DB Backup to External Drive

Avatar of mlcktmguy
mlcktmguyFlag for United States of America asked on
Microsoft SQL ServerStorage Software
16 Comments4 Solutions294 ViewsLast Modified:
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.
ASKER CERTIFIED SOLUTION
Zberteoc

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 4 Answers and 16 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 4 Answers and 16 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros