web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / SQL Server Database Ba...
Microsoft Dynamics AX (Archived)

SQL Server Database Backup Failed

(0) ShareShare
ReportReport
Posted on by w.sallam 2,259

when i try to make backup for Dynamics AX 2012 database it stop at 90% and shows this error message.

Backup Failed for Server 'Server_Name'. (Microsoft.SqlServer.smoextended)
Additional information
system.data.sqlclient.sqlerror:read on"database_name.mdf" faild: 2(faild to retrieve text for this error.Reason: 15100) (Microsodt.sqlserver.smo)

after that the database won't work in SQL Management Studio, so i have to restart the server to the AOS works.

I hope you can help me solving this issue.
it's so risky to work without backups
,,,,

*This post is locked for comments

I have the same question (0)
  • Verified answer
    DaxNigel Profile Picture
    DaxNigel 2,574 on at

    The error suggests the system was not able to read a sector of data from the hard drives.

    I would run a check disk on the data drive to ensure there is no problem with the underlying hard drive and that each sector is reporting correctly.

    My followup question would be what type of RAID are you using to store your data on? Are you using physical drives or a SAN for the data store?

    Let me know what the results of the check disk is?

  • Suggested answer
    Denis Macchinetti Profile Picture
    Denis Macchinetti 16,444 on at

    Hi Wasim

    In addition to what Nigel said, take a look at blogs.msdn.com/.../fixing-damaged-pages-using-page-restore-or-manual-inserts.aspx

    Seems that your database or disk are corrupted.

    Finally, see also dba.stackexchange.com/.../sql-server-table-backup

    Hope this help you

  • w.sallam Profile Picture
    w.sallam 2,259 on at

    actually we use raid 5 for storing the database on the hard disks, one of them had problem (corrupted and like that.) but we change it

    I will try to perform the check disk after employees finish work and tell you how it goes.

    thanks for your advice ..

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans