Page 1 of 4 123 ... LastLast
Results 1 to 15 of 48
  1. #1
    Join Date
    Jul 2004
    Location
    Inverurie
    Posts
    628

    Unanswered: Need some guidance!

    I have been trying to rescue my company's helpdesk database because the company moved premesis and we lost that particular server.

    It was originally running SQL Server 6.5, and my line manager simply copied the database.DAT files straight out of the MSSQL\Data directory without running a backup through Enterprise Manager.

    Does anyone know how i can rescue these files so that we can get our helpdesk up and running again?!

    thanks in advance for any help you can provide.

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    I've never done this...but did you try and put the files in the exact location as the old box?

    Is the line manager your boss?

    If not, smack him/her in the head...

    If yes, say what a great job they did to back up the data....

    IOs the old box still available?

    And how big is the file?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Jul 2004
    Location
    Inverurie
    Posts
    628
    ok,

    Yes i have tried putting them back into the MSSQL\Data directory of an SQL server 6.5 install on a different server, but enterprise manager doesn't recognise them. I've tried creating databases with the said files in question and over-writing them with the originals, but it just makes them suspect, and therefore unusable.

    Yes the line manager is my boss, and unfortunately, there's not much i can really say about them, but the "great job" one has sprung to mind.

    The files are 77Mb for the main database i want to restore, and the master database is 100Mb.

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    As SA you can go into master and manually change the status of the database from Suspect to "AOK". This is not guaranteed to work, but I have done it succesfully on 6.5.

    If you got nothing to lose...
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  5. #5
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Ok, so he's your boss...buy him a drink...

    So you don't have a contact to someone where the old box is?

    I remember reading that you have to modify the system tables....

    It's not the best solution...
    I would try and find someone to help from the old box...is it decommisioned?

    Also try doing a search over at sqlteam...I know I saw it over there....
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  6. #6
    Join Date
    Jul 2004
    Location
    Inverurie
    Posts
    628
    thanks for that. we don't really have anything to lose, but thankfully we have an old version of the database that works, but it'll put us back to march 2002, and my boss thinks that is unacceptable.

    Unfortunately the old box has been formatted and is being used for something else.

    have you got the url for sqlteam? it won't hurt to go and have a look, and we might just get a solution to this (we've been working on it for almost a week now).

  7. #7
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Seriously. Try what you did before where you got the suspect database warnings.

    Then set the database to allow changes to the system tables, locate your database in the sysdatabases table, and change its status to the value for a database that is not suspect. What can you lose? Not all suspects are guilty, you know...
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  8. #8
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    http://www.sqlteam.com/default.asp

    Good luck....

    Formatted the box...sheesh....

    Do they have a tape backup?

    And if your boss thinks it's unacceptable....you might want to mention that taking backups with his method was un...well not the prefered method...

    Where are you from...want me to pay a visit?

    I don't have to be nice.....

    Or better yet...send the hit squad....

    The blind dude and rdjabarov should put the fear of god in to him....
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  9. #9
    Join Date
    Jul 2004
    Location
    Inverurie
    Posts
    628
    Got the first part done, but as for this part:

    Then set the database to allow changes to the system tables, locate your database in the sysdatabases table, and change its status to the value for a database that is not suspect. What can you lose? Not all suspects are guilty, you know..

    This is going to sound more than a little stupid, but where do i go to access the above? (i've just been going along blind, because A, im the only one who is free to do it, and B because i don't have any training on server software at all. Not even our IT guy knows how to work with SQL server 6.5, but if you could provide me with a bit of an idiots guide to get to those areas then i would really appreciate it.

    Brett, im from outside Aberdeen, but i dont think my boss would take too kindly to having to get someone in to sort this one out. Must be a manager thing...

  10. #10
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    That doesn't sound stupid. This is advanced crap.

    To set the allow updates option:

    Expand a server group.
    Right-click a server, and then click Properties.
    Click the Server Settings tab.
    Under Server behavior, select or clear the Allow modifications to be made directly to the system catalogs check box.

    Now run:
    select status, name from sysdatabases
    to see that status of all your databases

    Then run:
    Update sysdatabases set status = [YourDesiredStatus] where name = [YourDatabaseName]

    Then RESET THE ALLOW UPDATES OPTION!


    Here are the bit values for the status column. Select the options you want, add up their values, and that is [YourDesiredStatus].
    1 = autoclose; set with sp_dboption.
    4 = select into/bulkcopy; set with sp_dboption.
    8 = trunc. log on chkpt; set with sp_dboption.
    16 = torn page detection, set with sp_dboption.
    32 = loading.
    64 = pre recovery.
    128 = recovering.
    256 = not recovered.
    512 = offline; set with sp_dboption.
    1024 = read only; set with sp_dboption.
    2048 = dbo use only; set with sp_dboption.
    4096 = single user; set with sp_dboption.
    32768 = emergency mode.
    4194304 = autoshrink.
    1073741824 = cleanly shutdown.

    I'd run backups of any critical data on the server before doing this, just as a matter of principle.

    You now know enough to be very dangerous.

    Oh, and we DBAs prefer to call it "Books Online" rather than "Idiot's Guide".
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  11. #11
    Join Date
    Jul 2004
    Location
    Inverurie
    Posts
    628
    ok, cheers for that. I just had a thought though. Would the same be possible on a server 2000 install? i.e. re-naming the old .DAT files to the respective file formats and following the above (with the obvious changes due to the software).

    If it does then i can put 2000 on the test machine to see if that works out. I seem to remember something about 6.5 databases being incompatible with 2000 for some reason, unless a direct upgrade is carried out...

  12. #12
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    You don't know them to well...

    I didn't say they'd come in and fix it...mostly berate the guy....

    And it's 6.5....I didn't look to close....

    I try to forget everything pre 7...

    A search...this was a fun thread

    http://www.sqlteam.com/forums/topic....th%2Cdb%2Cfile

    Need to do more digging....
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  13. #13
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by blindman
    That doesn't sound stupid. This is advanced crap.

    You now know enough to be very dangerous.

    Oh, and we DBAs prefer to call it "Books Online" rather than "Idiot's Guide".
    AMEN brother

    Your a DBA?...go figure....

    And it's BOL
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  14. #14
    Join Date
    Jul 2004
    Location
    Inverurie
    Posts
    628
    im nowhere near a DBA (just incase that was intended for me), i just seem to be the try and fix it guy.

    Oh, here's another challenge for you. I've just discovered that i need to have it up to service pack 5a, looking through the microsoft site there's only post service pack 5a, not much use there. do you guys know where to find the relevant service packs 'cause im now stumped. (and it all started off with my boss saying "no you don't need the service packs. It should run fine enough without them.")

  15. #15
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by cruickshanks
    and it all started off with my boss saying "no you don't need the service packs. It should run fine enough without them.")
    I'm speechless....

    What line of business are you in?

    I hope it's one where you don't need to worry about data

    http://www.microsoft.com/sql/downloads/2000/sp3.asp
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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