I've searched for most of today and I haven't found anyone asking about my situation. I've done everything I've seen on forums, not just this one, and I cannot seem to get it to work.
I've got a batch file that contains the string to launch SQLCMD.exe with the necessary parameters to tell the server to run a backup. Note, I copied the SQL for this from SSMS, so it should work.
This fails with the log in 'Management->SQL Server Logs-> Current' showing the infamous message:
<BACKUP failed to complete the command BACKUP DATABASE ***. Check the backup application log for detailed messages.
Error: 3041, Severity 16, State 1>
I've seen far too many threads where people have asked what this means and not received an answer. Hell, one reply even directed them to server log in Management of SSMS, which as I noted above is where
I'm getting that message from...
I've searched MSDN and all I can find is people askin ...
Go to the complete details ...