Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2004
    Location
    Australia
    Posts
    3

    Unanswered: attaching DB using single MDF file

    Hi there,
    I'm trying to attach a DB using a single MDF file. The file was not properly detached as our server had crashed suddenly neither was the a proper backup done..When I try to attach it says
    "the file you've specified is not a valid sql server database file" . But another database was restored using a MDF file without any problems ?
    Please do get back if anyone may get what the problem likely is ? It'd be of great help. Let me know if my problem was clear or if I've to put it in a different fashion.

    Cheers
    Ganesh

  2. #2
    Join Date
    Jan 2003
    Location
    India
    Posts
    523

    Re: attaching DB using single MDF file

    Originally posted by gans_sr
    Hi there,
    I'm trying to attach a DB using a single MDF file. The file was not properly detached as our server had crashed suddenly neither was the a proper backup done..When I try to attach it says
    "the file you've specified is not a valid sql server database file" . But another database was restored using a MDF file without any problems ?
    Please do get back if anyone may get what the problem likely is ? It'd be of great help. Let me know if my problem was clear or if I've to put it in a different fashion.

    Cheers
    Ganesh
    what do u mean by
    other database was restored using a MDF file without any problems ?
    was it the same file which u r trying to restore again??
    to me it seems that the database file is corrupted and u will have to look for the most recent backup for the database.

  3. #3
    Join Date
    Feb 2004
    Location
    Australia
    Posts
    3
    Harshal,
    Its not the same file and its a differnt one . I also reckon it could be corrupt, but do you think it can be repaired by any chance ?
    About backup, somehting had happened to hte server it seems , may be some virus and it stopped job schedule on sql server also.
    Thanks for any ideas
    Ganesh

  4. #4
    Join Date
    Jan 2003
    Location
    India
    Posts
    523
    Originally posted by gans_sr
    Harshal,
    Its not the same file and its a differnt one . I also reckon it could be corrupt, but do you think it can be repaired by any chance ?
    About backup, somehting had happened to hte server it seems , may be some virus and it stopped job schedule on sql server also.
    Thanks for any ideas
    Ganesh
    In that case u r in a real problem! I haven't heard of repairing a corrupt database file yet.The only solution that I see is to get the latest workable backup from the backup sets and restore them. I hope you have some backups before the job stopped running.
    and also once every thing is running, do configure an alert for all the jobs so that their status is mailed to u every time they run.
    regards,
    Harshal.

  5. #5
    Join Date
    Feb 2004
    Location
    Australia
    Posts
    3
    Thanks Harshal .Looks like thats the only option available now.

Posting Permissions

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