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 GP (Archived) / Re-Attach Databases
Microsoft Dynamics GP (Archived)

Re-Attach Databases

(0) ShareShare
ReportReport
Posted on by Mark Lindgren 490

Unfortunately removed and old SQL Server that is no longer supported.

Found out it is used to print out History from a program called IMUS.

Any suggestion of the steps needed to take so we have access to IMUS again and print out the Reports.

I have the 2005 SQL Server CD's and thought I will need to reinstall them.

We have a backup, but no one knows how to restore.

We still have the ODBC Files, for Imus or SQL 2005, and have the Data of IMUS.

I do know SQL SERVER 2005 is no longer supported by MICROSOFT.

Wanted to know if anyone had suggestions to help me with this challenge???!!!!

Thank You,

Mark S. Lindgren

*This post is locked for comments

  • Derek Albaugh Profile Picture
    Derek Albaugh on at
    RE: Re-Attach Databases

    Hello Mark,

    If you have the backup file (.bak) for the database, you can restore it using the steps mentioned in this webpage:

    docs.microsoft.com/.../restore-a-database-backup-using-ssms

    If you only have the MDF and LDF files for the database, you can use them to restore using these steps:

    1.First Put the .mdf and .ldf file in C:\Program Files\Microsoft SQL Server\MSSQL.#\MSSQL\DATA\ folder

    2.Then go to sql software , Right-click “Databases” and click the “Attach” option to open the Attach Databases dialog box

    3.Click the “Add” button to open and Locate Database Files From C:\Program Files\Microsoft SQL Server\MSSQL.#\MSSQL\DATA\folder

    4.Click the "OK" button. SQL Server Management Studio loads the database from the .MDF file.

    All of this information is found online.

    As for IMUS, we don't do any support or troubleshooting of that application, but maybe some others on this forum may be able to give you some info on that.

    Thanks,

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,468 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,287 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans