i was trying to backup the database when exiting the manger when i got an error about abnormal exiting of database any suggestions ?
*This post is locked for comments
This is rather old but I wanted to document what did the trick for me as I was having the same error. When doing a backup to the HQ database, you have to turn off HQ Server.
Create a folder C:\Backups. Backup to that folder. If that works, its a permissions issue.
I've posted here numerous times backup routines that use Task Scheduler for some VBS scripts, here it is again: dl.dropbox.com/.../Backups.zip
For systems we setup, we backup the SO/HQ SQL database(s) every hour (:45 & :50) and then use Norton Ghost/Backup Exec/Acronis etc to backup all incremental changes every hour, on the hour. The Master/Model/Msdb are backed up weekly in the middle of the night.
Edit them with Notepad, they also use the C:\Backups folder noted above, edit each script to change the SQL password that you use and on both the SOBack.vbs and HQBack.vbs also change the database name.
Arnie might be on to something!
Maybe it is a windows security issue.
I would also ask if your user has folder write permission.
Hi Omar,
I had a similar issue when I recently set up our system. My server is running on Win7. I had to add permissions in Windows for the SQL user to write to the desired backup folder.
Otherwise, have you tried to save the backup into the same folder where the database resides? That folder probably already has the proper permissions. After completed, you could then move the backed up file where you want.
well jerry thank you but still no luck see when i followed your steps which i actually did before it asked me where i want to save and i selected desktop and a random name and then it gave me the same error
"cannot open backup device 'C:\Users\omar\Desktop\mnnm.bck'.Operating system error 5(error not found) . BACKUP DATABASE is terminating abnormally ." so>????????!!!
Oh ok.
1. Open Store Ops Admin
2. Click File / Connect
3. Enter 'OSOS96\SQLEXPRESS' in server
4. Check sql authentication
5. Enter sa for user
6. Enter password
7. Click on down arrow next to database drop down
8. Wait for it...
9. When you get a drop down choose your database
10. Click ok
11. Click Database / Backup
12. Follow the bouncing ball
Good luck.
-Jerry
JR Data Inc
in the store operations adminstrator this is the configs
serve namer : OSOS96\SQLEXPRESS
Username:sa
Password: ******
Database :MSRMS
Connection timeout :60
and btw im the only device using it so??!!! what to do please mention STEPS LIke 1-goto XXXX==>XXX ==>xxxxxx
maybe you have two sql servers going, so maybe your server is 'mymachine\sqlexpress' instead of just 'mymachine'
What is the setting to connect in so / config/ database?
you don't get it when i select as local and try to select the data base my database(MSRMS) isn't there it is just master and....... etc the default ones
You are on the right track, but choose the database before clicking ok, or after connecting, go database/select and choose the database.
Easier to do it from the manager on the database server.
Like my professor used to say, RTFM :)
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,902 Super User 2024 Season 2
Martin Dráb 229,297 Most Valuable Professional
nmaenpaa 101,156