+ Post New Thread
Results 1 to 3 of 3
MIS Systems Thread, DBAttach in Technical; Can anyone remind me about any problems or pitfalls of using DBATTACH? I seem to remember something about passwords being ...
  1. #1

    TechMonkey's Avatar
    Join Date
    Dec 2005
    Location
    South East
    Posts
    3,286
    Thank Post
    225
    Thanked 405 Times in 302 Posts
    Rep Power
    162

    DBAttach

    Can anyone remind me about any problems or pitfalls of using DBATTACH? I seem to remember something about passwords being dropped or needing to be reset. Problem is I can't remember definitvely so if it was a bug that has been fixed or a feature that needs handling.

    Long story short, been given a fix that is to just detach and re-attach the DB but of course I don't just want to do this if one evening if I am goin gto have to sort passwords or get staff to re-enter their passwords teh next day.

    Also the instructions given have a large warning saying "Do not try to re-attach a database back until the database has been removed from the data folder" Does re-attaching copy the data then? If I am just wanting to detach & re-attach can I ignore this?

  2. #2
    Ian_ICTDS's Avatar
    Join Date
    Jun 2009
    Location
    Warwickshire
    Posts
    70
    Thank Post
    11
    Thanked 15 Times in 12 Posts
    Rep Power
    13
    You should be fine as long as you do not choose to drop logins. You donít actually have to move the MDF and LDF out of the data folder but that warning is there because if you accidently pick the wrong MDF you can end up overwriting your database by accident.

    Detaching and re-attaching is a common solution. Usually the one you do after 'turning it off and on again'.

  3. Thanks to Ian_ICTDS from:

    TechMonkey (21st September 2009)

  4. #3

    TechMonkey's Avatar
    Join Date
    Dec 2005
    Location
    South East
    Posts
    3,286
    Thank Post
    225
    Thanked 405 Times in 302 Posts
    Rep Power
    162
    Thanks all

SHARE:
+ Post New Thread

Similar Threads

  1. Problem with batch backup or SIMS.net using DBAttach
    By GreenICT in forum MIS Systems
    Replies: 5
    Last Post: 18th August 2009, 08:48 AM
  2. Replies: 2
    Last Post: 11th August 2009, 12:17 PM
  3. SIMS: dropping logins when using dbAttach
    By Oops_my_bad in forum MIS Systems
    Replies: 4
    Last Post: 6th February 2009, 06:15 PM
  4. DBATTACH exit code
    By ajbritton in forum MIS Systems
    Replies: 0
    Last Post: 24th November 2006, 11:31 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •