Backup database through Store Operations Administratro

Dec 07, 2007 1 Replies
P

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


Vote
Twitter Facebook LinkedIn
P

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

Vote
Twitter Facebook LinkedIn

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required