Big Problem Sql server 2000 database crash

I have a small sql server 2000 database that has never been backed up. The
drive where the main database file resides failed on the server but the
drive where the transaction logs is still good.
Can I recover the database from just the transaction logs? And can you
point me to some documentation on how to do this?
Thank you
JoelYou can't restore any transaction logs without first restoring a full
backup.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Joel" <nowhere@.nowhere.com> wrote in message
news:%23gyxCqhxGHA.1248@.TK2MSFTNGP02.phx.gbl...
I have a small sql server 2000 database that has never been backed up. The
drive where the main database file resides failed on the server but the
drive where the transaction logs is still good.
Can I recover the database from just the transaction logs? And can you
point me to some documentation on how to do this?
Thank you
Joel|||If I remember correctly, you can't even back up the transaction log
without first backing up the database.
Roy Harvey
Beacon Falls, CT
On Tue, 22 Aug 2006 15:47:31 -0400, "Tom Moreau"
<tom@.dont.spam.me.cips.ca> wrote:
>You can't restore any transaction logs without first restoring a full
>backup.
>--
> Tom
>----
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Toronto, ON Canada|||Roy Harvey wrote:
> If I remember correctly, you can't even back up the transaction log
> without first backing up the database.
>
And for the OP, the moral of this story is...
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||I know it might be stretching it a bit, but can I recreate a database and
then somehow use the log file to repopulate the database file?
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:OSHYaPixGHA.2260@.TK2MSFTNGP03.phx.gbl...
> You can't restore any transaction logs without first restoring a full
> backup.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> "Joel" <nowhere@.nowhere.com> wrote in message
> news:%23gyxCqhxGHA.1248@.TK2MSFTNGP02.phx.gbl...
> I have a small sql server 2000 database that has never been backed up.
> The
> drive where the main database file resides failed on the server but the
> drive where the transaction logs is still good.
> Can I recover the database from just the transaction logs? And can you
> point me to some documentation on how to do this?
> Thank you
> Joel
>|||The moral is even if it is a semi "test" database back it up.
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:44EB6274.9080507@.realsqlguy.com...
> Roy Harvey wrote:
>> If I remember correctly, you can't even back up the transaction log
>> without first backing up the database.
> And for the OP, the moral of this story is...
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com|||Joel wrote:
> The moral is even if it is a semi "test" database back it up.
>
Bingo!!
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Nope, that's not possible.
Bob
"Joel" wrote:
> I know it might be stretching it a bit, but can I recreate a database and
> then somehow use the log file to repopulate the database file?
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:OSHYaPixGHA.2260@.TK2MSFTNGP03.phx.gbl...
> > You can't restore any transaction logs without first restoring a full
> > backup.
> >
> > --
> > Tom
> >
> > ----
> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> > SQL Server MVP
> > Toronto, ON Canada
> > .
> > "Joel" <nowhere@.nowhere.com> wrote in message
> > news:%23gyxCqhxGHA.1248@.TK2MSFTNGP02.phx.gbl...
> > I have a small sql server 2000 database that has never been backed up.
> > The
> > drive where the main database file resides failed on the server but the
> > drive where the transaction logs is still good.
> >
> > Can I recover the database from just the transaction logs? And can you
> > point me to some documentation on how to do this?
> >
> > Thank you
> >
> > Joel
> >
> >
>
>