I need to take an Back up of DB from sql server 2008 management studio
I used the below query
BACKUP DATABASE DB1 TO DISK='Localpath\db.bak'
This works fine in local server, but when I execute the same code in server
I am getting error as
Msg 3201, Level 16, State 1, Line 1
Cannot open backup device 'D:\DB.bak'. Operating system error 5(Access is denied.).
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.
Kindly let me know how to solve this issue...
Thanks in advance