Results 1 to 3 of 3

Thread: SQL Database Recovery

  1. 05-08-2003, 08:05 PM #1
    samman
    samman is offline Registered User
    Join Date
    May 2003
    Posts
    1

    Unhappy SQL Database Recovery

    I just had to reload my windows 2000 server because of corrupt files. I was able to ghost my data across to another disk. Unfortunately, i lost my database backup files but still have the .mdf and .ldf files. Is there any way of restoring these databases using these files?
    Reply With Quote Reply With Quote
  2. 05-08-2003, 10:17 PM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    sp_attach_db

    and

    sp_attach_single_file_db

    refer bol for the above these two commands
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  3. 05-09-2003, 09:47 AM #3
    KnooKie
    KnooKie is offline Registered User
    Join Date
    Jan 2003
    Location
    UK
    Posts
    277
    unless you need the ldf file you can just attach the mdf and a new minimum size ldf will be auto created for you.

    A good if unorthodox way of clearing out a massive log file as well. Make sure you don't need anything that may be in it though.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules