PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 7/21/2008 11:08 PM by  Rod Weir
SQL 2005 and V8
 2 Replies
AddThis - Bookmarking and Sharing Button
Sort:
You are not authorized to post a reply.
Author Messages
Anne Savoie
Helpdesker
Helpdesker
Posts:9
Points:19


--
7/20/2008 8:42 AM

    Hello,

    I need help with SQL.  I made the mistake of having my v7.5 database in the master.mdf database.  When attempting to load sql 2005 service pack 2 I lost the original master.mdf.  I have a backup master.bak (my whole helpdesk database!) but to no avail can I get it to restore, import or create a new database??  I've tried updating the master while is single-user mode but it will not go.  Creating a new database gives me an error about the sysnsobjs.  I have no helpdesk working right now and desperately need to get it back online, at least v7.5 if not up to v8.0, my original goal!

    Any help would be appreciated.

    Thanks,

    Anne Savoie

    C/W MARS, Inc

    Rod Weir
    HelpMaster development team
    Helpdesk Hall of Fame
    Helpdesk Hall of Fame
    Posts:555
    Points:1017


    --
    7/20/2008 5:34 PM
    Hi Anne,

    Sounds like you've got an interesting database challenge here. We've logged your support call and will contact you with information regarding this issue.

    The basic approach to the solution will be to move all of the HelpMaster Pro database objects out of the Master and into it's own database.

    Rod
    HelpMaster development team
    Check out the HelpMaster roadmap
    Rod Weir
    HelpMaster development team
    Helpdesk Hall of Fame
    Helpdesk Hall of Fame
    Posts:555
    Points:1017


    --
    7/21/2008 11:08 PM

    Hi Anne,

    I believe that I've fixed your database and have contacted you via our internal support channel with the details. For the benefit of anyone else reading this thread, basically ApexSQL Script saved the day again. I used this tool to script out the database (schema + data), and then ran the script to create a new, fixed database. ApexSQL Script is a fantastic database tool that anyone working with databases should look into http://www.apexsql.com/sql_tools_script.asp

    Rod

    HelpMaster development team
    Check out the HelpMaster roadmap
    You are not authorized to post a reply.


    New version - HelpMaster v24 now available! by Rod Weir in Announcements with 0 replies A new major release of HelpMaster is now available! Read about some of the new features and improvements here:  https://docs.helpmasterpr...-f...

    New version - HelpMaster v23 now available! by Rod Weir in Announcements with 0 replies A new major release of HelpMaster is now available! Read about some of the new features and improvements here:  https://docs.helpmasterpro.com...

    March 2023 v22.7 maintenance release now available by Rod Weir in Announcements with 0 replies A maintenance release for v22.7 HelpMaster is now available! The maintenance release fixes a number of issues that have been reported since the ini...

    July 2022 release now available - New version released! by Rod Weir in Announcements with 0 replies A new feature release of HelpMaster is now available!  v22.7.22 For a list of the major new features of v22, see the new documentation site ht...

    June 2022 v22.2 maintenance release now available by Rod Weir in Announcements with 0 replies A maintenance release for v22.2 HelpMaster is now available! The maintenance release fixes a number of issues that have been reported since the ini...

    RE: Use PowerBI for HelpMaster dashboards by Rod Weir in Reports and reporting Hi SR, Thanks for the post. Yes, the PowerBI reports for HelpMaster have been well received. Download the latest version, from here. https://www...

    RE: Use PowerBI for HelpMaster dashboards by Scenic_Rim_IT in Reports and reporting Hi Rod - just wondering how PowerBI reports are going? Any chance you have a beta/pre-release version we can help test for you?...

    New version - HelpMaster v24 now available! by Rod Weir in Announcements A new major release of HelpMaster is now available! Read about some of the new features and improvements here:  https://docs.helpmasterpr...-f...

    New version - HelpMaster v23 now available! by Rod Weir in Announcements A new major release of HelpMaster is now available! Read about some of the new features and improvements here:  https://docs.helpmasterpro.com...

    March 2023 v22.7 maintenance release now available by Rod Weir in Announcements A maintenance release for v22.7 HelpMaster is now available! The maintenance release fixes a number of issues that have been reported since the ini...

    July 2022 release now available - New version released! by Rod Weir in Announcements A new feature release of HelpMaster is now available!  v22.7.22 For a list of the major new features of v22, see the new documentation site ht...

    June 2022 v22.2 maintenance release now available by Rod Weir in Announcements A maintenance release for v22.2 HelpMaster is now available! The maintenance release fixes a number of issues that have been reported since the ini...

    February 2022 release now available - New version released! by Rod Weir in Announcements A new major release of HelpMaster is now available! For a list of the major new features of v22, see the new documentation site https://docs.helpma...

    November 2021 release now available - New Major Version! by Rod Weir in Announcements A new major release of HelpMaster is now available! For a list of the major new features of v22, see the new documentation site https://docs.helpma...

    May 2021 release now available - New Major Version! by Rod Weir in Announcements A new major release of HelpMaster is now available! For a list of the major new features of v21, see the new documentation site https://docs.helpma...