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.