Witam, wczoraj ustawiono nam skrypt do automatycznego backupu, jednak zamiast kopi tworzy sie plik tekstory log
Skrypt:
Kod:
sqlcmd -S SEM01\insertgt -U sa -P "haslo" -Q "BACKUP DATABASE Platnik TO DISK
='D:\archiwum\platnik\platnik-%DATE%.bak' WITH NAME = 'Platnik Database Backup',
NOFORMAT, SKIP, NOREWIND, NOUNLOAD, STATS = 10" -o D:\archiwum\platnik\platnik%DATE%.log
rem sqlcmd -S (local)\insertgt -U sa -P haslo -i D:\skrypty\platnik.sql
Log:
Kod:
Msg 3201, Level 16, State 1, Server SEM01\INSERTGT, Line 1
Cannot open backup device 'D:\archiwum\platnik\platnik-31.01.2020.bak'. Operating system error 5(Access is denied.).
Msg 3013, Level 16, State 1, Server SEM01\INSERTGT, Line 1
BACKUP DATABASE is terminating abnormally.