Skip to main content

Notifications

Microsoft Dynamics RMS (Archived)

error trying to backup database !

Posted on by 175

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

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: error trying to backup database !

    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.

  • Jeff @ Check Point Software Profile Picture
    Jeff @ Check Point ... 13,380 on at
    Re: error trying to backup database !

    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.

  • Gerald Rothaus Profile Picture
    Gerald Rothaus 2,930 on at
    Re: error trying to backup database !

    Arnie might be on to something!

    Maybe it is a windows security issue.

    I would also ask if your user has folder write permission.

  • Arnie Clawson Profile Picture
    Arnie Clawson 115 on at
    Re: error trying to backup database !

    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.

  • Omar Ossama Profile Picture
    Omar Ossama 175 on at
    Re: error trying to backup database !

    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>????????!!!

  • Suggested answer
    Gerald Rothaus Profile Picture
    Gerald Rothaus 2,930 on at
    Re: error trying to backup database !

    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

  • Omar Ossama Profile Picture
    Omar Ossama 175 on at
    Re: error trying to backup database !

    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

  • Gerald Rothaus Profile Picture
    Gerald Rothaus 2,930 on at
    Re: error trying to backup database !

    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?

  • Omar Ossama Profile Picture
    Omar Ossama 175 on at
    Re: error trying to backup 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

  • Suggested answer
    Gerald Rothaus Profile Picture
    Gerald Rothaus 2,930 on at
    Re: error trying to backup database !

    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 :)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,902 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,297 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans