Restore database without transaction log

alext12

Hi,

I lost transaction log of SQL 2000 database.
How i can restore the database without transaction log ?
What is restore sequence ?
I can't attach the database only:it requires log file
--
Regards
Alex

Cranfield

Alex

Take a look ate:

sp_attach_single_file_db


This may be what you are after.

--
-- cranfield, DBA


"alext12" wrote:

> Hi,
>
> I lost transaction log of SQL 2000 database.
> How i can restore the database without transaction log ?
> What is restore sequence ?
> I can't attach the database only:it requires log file
> --
> Regards
> Alex

alext12

cranfield ,

we receive error something about NLS code is incorrect
--
Regards
Alex


"Cranfield" wrote:

> Alex
>
> Take a look ate:
>
> sp_attach_single_file_db
>
>
> This may be what you are after.
>
> --
> -- cranfield, DBA
>
>
> "alext12" wrote:
>
> > Hi,
> >
> > I lost transaction log of SQL 2000 database.
> > How i can restore the database without transaction log ?
> > What is restore sequence ?
> > I can't attach the database only:it requires log file
> > --
> > Regards
> > Alex

Mike Hodgson

Have you got a backup of the DB? Without a DB backup you can't restore
anything, regardless of whether you have tlog backups or not.

When you say you "lost" the transaction log, do you mean it's corrupt?
or you've stopped the SQL instance, misplaced the ldf file and now the
server can't recover the DB on start up? or something else?

--
Mike

alext12 wrote:
> cranfield ,
>
> we receive error something about NLS code is incorrect