Home > Archive > microsoft.public.sqlserver.server > October 2002 > Using database without transaction log





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Using database without transaction log
A. Hartmann

2002-10-05, 9:09 pm

Hi,

is it possible to attach a database to sql server 2000
only by using the MDF-File(s) without the LDF-File(s)?

Thanks
Anselm
Andrés Taylor

2002-10-05, 9:09 pm

Anselm,

Most of the times, you should be fine. Use the sproc
[sp_attach_single_file_db], or sp_attach_db if you have several datafiles.
But - unless you have correctly detached the db, you have no guarantee that
it'll work. And, unfortunatly, even when you've detached it properly, this
will sometimes not work.

Good luck!

--
Andrés Taylor

visit me @
http://www.sql.nu/

"A. Hartmann" <hartmann@sbh.de> wrote in message
news:08ba01c25e13$6e613890$39e
f2ecf@TKMSFTNGXA08...
> Hi,
>
> is it possible to attach a database to sql server 2000
> only by using the MDF-File(s) without the LDF-File(s)?
>
> Thanks
> Anselm



Sponsored Links





Free Braindumps | MCSE braindumps software forum

Copyright 2003 - 2008 examnotes.net