Backup database through Store Operations Administratro

- P
- Paul Houston / Eastern National
  
  Contact options for registered users
posted
16 years ago

Fri, Dec 7, 2007 3:30 PM

We're in the process of upgrading all our RMS sites to SQL 2005 Express and Dotnet 2.0 in preparations for upgrading to V2.0 from V1.3r1. I've noticed that after the SQL upgrade I recieve an error as follows. "Cannot open Backup Device 'c:\rmsposXXX.bck. Operating system error

5 (Access is Denied.). BACKUP DATABASE is terminated abnormally." Using OSQL statements it will backup and also using the SQL 2005 management studio will backup. Any sugestions on what is causing this or how to correct this issue.

Paul Houston Eastern National POS Support

Loading thread data ...

- P
- Paul Houston /
  
  Contact options for registered users
Vote on answer
posted
16 years ago

Fri, Dec 7, 2007 4:19 PM

Sory about that After further testing I found you can no longer sve your backup to the Root directory or to the DBfiles folder. You need to save it in another folder such as c:\backup.

Paul H.

"Paul Houst> We're in the process of upgrading all our RMS sites to SQL 2005 Express and

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.