database file replaced RRS feed

  • Question

  • How can recover database file ?

    actually during ERP upgradation database file has been replace and we have very old data backup.

    is there any way to recover files?


    Tuesday, October 23, 2018 12:36 PM

All replies

  • Did not you backup the database just before upgrading? If the file was replaced/upgraded  I think  you are out of luck 

    BTW you did not tell us the whole story, what is SQL Server version you are using? What is ERP upgrading means?

    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    Wednesday, October 24, 2018 5:40 AM
  • Hi Arvind,

    According to your description, my understanding is that SQL Server database files were replaced after ERP upgradation. If anything is misunderstood, please tell me.

    If the data loss is within acceptable limits, you can use the old backup to restore your database. But since the original database files are gone, you can only recover the hard disk to recover database files to the time before ERP upgradation.

    I would recommend you to increase the frequency of backups, so that this kind of situation can be prevented.

    Best Regards
    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Wednesday, October 24, 2018 6:34 AM