Backup Database is terminating abnormally

[Rupesh Kumar Swami]

hi all, i simply write a small code of piece which create backup of Sql server database. It works well but whenever i set the target path of back file to Desktop( or program files folder) then it gives following error "Can not open backup device" & Target Path & ". Operating system error 5(Access is denied) /or Operating system error 3(Error not found). Any body can help me to resolve this error ?

Rupesh Kumar Swami Software Developer, Integrated Solution, Bikaner (India) My Company Award: Best VB.NET article of June 2008: Create Column Charts Using OWC11

[HemJoshi]

Hi Rupesh, The backup crated by the sql server can be stored only on the machine where the SQL server is installed. Just create a folder in SQLServer and give full permission to this folder and then try to create the backup. I hope it will work. Thx