forum.venkateswarlu.net
      Register      Login
I got an error while taking the backup of DB in SQL Server

1 replies to this topic

Nagendra Kodavalluri #1
Member
14 Points
 Posted on 11 Apr 2012 11:47 AM IST Msg 3201, Level 16, State 1, Procedure usp_DB_BackupDatabase, Line 35
Cannot open backup device 'C:\IDT\DBBackup\IDT\IDT_Wednesday.bak'. Operating system error 5(Access is denied.).
Msg 3013, Level 16, State 1, Procedure usp_DB_BackupDatabase, Line 35
BACKUP DATABASE is terminating abnormally.

Can anyone help me please 
SQL Server     851 views     Reply to this topic
Sushil Rout #2
Member
12 Points
 Replied on 27 Apr 2012 06:59 AM IST Hi,

Two things you need to be check first.

1.Check which user account SQL Server services are running.
2.Give full permission to that account to get rid of the error.

Note: Do not apply above method on your production server without consulting your network administrator

Cheers

 
Reply to this topic