www.webdeveloper.com
Results 1 to 3 of 3

Thread: Restore Database

  1. #1
    Join Date
    Mar 2006
    Posts
    1

    Restore Database

    Hi all

    for a reason or another my server was down and the harddisk was corrupted.. but i could managed to take the .mdf and .ldf files of the database... i have recently installed a new sql 2000 server and created a new database with same name of the previous database... then i tried to replace the new mdf and ldf files with the recovered files.. but it seems that the database is not working... anybody has an idea how to recover this database files.. since the database file is almost 20 GB size...
    please help

    thanx in advance....

  2. #2
    Join Date
    Mar 2006
    Location
    NCAA Tournament Hell
    Posts
    21
    What about the old log files. Do you have them?

  3. #3
    Join Date
    Aug 2005
    Location
    The Garden State
    Posts
    5,634
    Restoring a database is not a simple copy and paste of files. You need to actually run the restore from your last backup.

    You did do daily backups, right?

    (note: i have no clue what an mdf or ldf is, but i'm assuming its metadata and logical data files)
    Acceptable Use | SQL Forum FAQ | celery is tasteless | twitter

    celery is tasteless - currently needing some UI time

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
  •  
HTML5 Development Center



Recent Articles