Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2004
    Posts
    1

    Question Unanswered: attach data file

    I have MS SQL server database with two files
    1- x_data.mdf, 2- x_log.ldf
    The database become suspect and i have no space problem.
    now the problem is that the log file become corrupted because when i stop the database service I tray to copy the log file into another place but I can't
    Now the result is that I have one data file x_data.mdf and how can I solve the problem
    and the question is how can I back the data again when I have a data file without a log file
    Thanks

  2. #2
    Join Date
    Jan 2003
    Location
    India
    Posts
    523
    try attaching the database file.
    right click server --> attach database.
    while attaching it recreates the log file.

Posting Permissions

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