Unanswered: Backup failed (Error 3041) while try to issue a BACKUP Statement in Local
I use the Transact-SQL BACKUP statement in Visual Basic to backup my local MSSQL Database. It give me this error
BACKUP failed to complete the command BACKUP DATABASE [BCFPC] to BCFPCBKP
I already created a backup device called BCFPCBKP and it is backup to the disk.
I tried to run the same BACKUP statement in SQL Query Analyzer and it worked fine. I tried to run my VB application in another PC. It worked fine when i use this command remotely. Can anyone tell me what's the problem?