Re: Recovering SQL Server 2000 database without a backup

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 02/17/04


Date: Mon, 16 Feb 2004 23:16:41 -0500

Not really. They do allow you to download a trial version. You may want to
check that out.

-- 
Andrew J. Kelly
SQL Server MVP
"actranet" <anonymous@discussions.microsoft.com> wrote in message
news:11a6c01c3f4f2$853657e0$a501280a@phx.gbl...
> Is there any other option other than Log Explorer? I think
> it costs something like $1500 and I don't really have that
> kind of money.
>
>
> >-----Original Message-----
> >Yes a backup would have saved a lot of trouble but you
> may still have a
> >chance with a product from www.lumigent.com.
> >
> >
> >-- 
> >
> >Andrew J. Kelly
> >SQL Server MVP
> >
> >
> >"actranets@hotmail.com"
> <anonymous@discussions.microsoft.com> wrote in
> >message news:119c501c3f4e0$7cf8d600$a501280a@phx.gbl...
> >> I boo boo'd. I accidentally dropped all the tables in my
> >> database and I don't have a recent backup. I looked in
> the
> >> transaction log and I don't see anything associated with
> >> the database in question. Is there a way for me to
> recover
> >> these tables? I am open to anything at this point. I'm
> >> getting pretty desperate here.... and I know, I know. I
> >> should have made a backup file. Live and learn, I guess.
> >> Can anyone help me?
> >>
> >> Thank you.
> >
> >
> >.
> >


Relevant Pages

  • Re: Questions - Repost
    ... James ... >Andrew J. Kelly SQL MVP ... You are Following a backup plan for a database. ...
    (microsoft.public.sqlserver.server)
  • Re: reindex or update stat
    ... change in the way the queries are run. ... Andrew J. Kelly ... SQL Server MVP ... > I have a database that will have couple thousands row inserted normally, ...
    (microsoft.public.sqlserver.server)
  • Re: detaching db and stopping services
    ... > Tibor Karaszi, SQL Server MVP ... >>> backup the filecreated by that process and you should have your database ... >> blown the standby database once. ...
    (microsoft.public.sqlserver.server)
  • Re: Using maint plan to backup db to network drive
    ... Tibor Karaszi, SQL Server MVP ... In setting up our system imaging software I wanted to move our database ... I see that when I click browse to select the backup location it allows you ... UNC path it says its invalid but lets me enter it anyway, ...
    (microsoft.public.sqlserver.tools)
  • Re: Restore Database Dialog Shows Old Backup File Location
    ... Some of the links refer to methods that can be used to move to a new server ... Andrew and Johnny! ... > moving database backup files. ... we moved the backup directory to the new location. ...
    (microsoft.public.sqlserver.server)