We have a standalone installation of database on sqlserver 2008R2 and want ot backup the database in external drive since the size of the back up file is 18G. Used script as well as Maintenance plan and got the error, how do I grant permission so that I can store in external USB drive
Msg 3201, Level 16, State 1, Line 1 Cannot open backup device 'P:\Backups.SQL\PWNT\PWNT_backup_2018_11_29_135357_7686135.bak'. Operating system error 3(The system cannot find the path specified.). Msg 3013, Level 16, State 1, Line 1 BACKUP DATABASE is terminating abnormally.