Server failure

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Proli
    #1

    Server failure

    Hi,

    I have lost my win 2k server where I had my Sql 2000 data.

    Now I need to attach to sql server my database, but I have lost the log
    file.

    If I use the enterprise manager I get an error, if I use a stored
    procedure I get an error.

    How can I do to attach my .mdf file to Sql Server?

    Thanks in advance

    Marco Dell'Oca


    Tags: None
    • Dan Guzman
      #2
      Re: Server failure

      A database might not attach if it wasn't properly detached. You can try
      running sp_attach_singl e_file_db from Query Analyzer, specifying the path to
      your database file. If this doesn't work, you best option is to restore
      from backup.

      If you have no backups, contact Microsoft PSS for assistance. They may be
      able to help you salvage data but data integrity will be questionable
      without the log.

      --
      Hope this helps.

      Dan Guzman
      SQL Server MVP

      "Proli" <info@proli.i t> wrote in message
      news:AIG_b.1898 5$IT2.672883@ne ws4.tin.it...[color=blue]
      > Hi,
      >
      > I have lost my win 2k server where I had my Sql 2000 data.
      >
      > Now I need to attach to sql server my database, but I have lost the log
      > file.
      >
      > If I use the enterprise manager I get an error, if I use a stored
      > procedure I get an error.
      >
      > How can I do to attach my .mdf file to Sql Server?
      >
      > Thanks in advance
      >
      > Marco Dell'Oca
      >
      >[/color]


        Comment

        • Greg D. Moore \(Strider\)
          #3
          Re: Server failure


          "Proli" <info@proli.i t> wrote in message
          news:AIG_b.1898 5$IT2.672883@ne ws4.tin.it...[color=blue]
          > Hi,
          >
          > I have lost my win 2k server where I had my Sql 2000 data.
          >
          > Now I need to attach to sql server my database, but I have lost the log
          > file.
          >
          > If I use the enterprise manager I get an error, if I use a stored
          > procedure I get an error.
          >
          > How can I do to attach my .mdf file to Sql Server?[/color]

          There's a method, but you need to contact MS SUpport.

          Note that if you have unresolved transactions (i.e. the server died in the
          middle of doing stuff) you will now have inconsistent data.

          [color=blue]
          >
          > Thanks in advance
          >
          > Marco Dell'Oca
          >
          >[/color]


            Comment

            • Simon Hayes
              #4
              Re: Server failure

              "Proli" <info@proli.i t> wrote in message news:<AIG_b.189 85$IT2.672883@n ews4.tin.it>...[color=blue]
              > Hi,
              >
              > I have lost my win 2k server where I had my Sql 2000 data.
              >
              > Now I need to attach to sql server my database, but I have lost the log
              > file.
              >
              > If I use the enterprise manager I get an error, if I use a stored
              > procedure I get an error.
              >
              > How can I do to attach my .mdf file to Sql Server?
              >
              > Thanks in advance
              >
              > Marco Dell'Oca[/color]

              At this point, your only real options are to restore from backup if
              you have one, or call Microsoft PSS, who may be able to help you
              recover data from the file.

              Simon

                Comment

                Previous template Next
                Working...