Home Forums SQL Server 2005 SQL Server 2005 General Discussion Help please? Tried moving installation directory of Cheftec (old restaurant management software) and broke the database(?) RE: Help please? Tried moving installation directory of Cheftec (old restaurant management software) and broke the database(?)

  • SQL Server is not a file-based database. Moving the files isn't enough. Someone (preferably someone with a mediocre of SQL knowledge) needs to log into the SQL instance on the new server and restore the backup (hopefully you took a backup, moving files is not guaranteed to result in a consistent, usable database) or if there's no backup attach the database files and hope they work.

    You may also need to change connection strings or set up data sources on the new machine, depending what the app needs.

    If I may suggest, find someone who knows SQL and get them in for a day or so to do what they can.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass