How NOT to generate the LDF file

Nevermind why, but is there a command that will prevent an LDF file
from being generated when I attach the MDF using a script?
On Feb 8, 11:50 am, mstin...@.gmail.com wrote:
> Nevermind why, but is there a command that will prevent an LDF file
> from being generated when I attach the MDF using a script?
No, the transaction log is required. Without it, you don't have a
functional database.
|||On Feb 8, 9:53 am, "Tracy McKibben" <tracy.mckib...@.gmail.com> wrote:
> On Feb 8, 11:50 am, mstin...@.gmail.com wrote:
>
> No, the transaction log is required. Without it, you don't have a
> functional database.
So there is no option in the server settings that will allow you not
to generate the LDF file? I just don't want the physical file there.
|||<mstinawu@.gmail.com> wrote in message
news:1170957828.166662.205900@.l53g2000cwa.googlegr oups.com...
> On Feb 8, 9:53 am, "Tracy McKibben" <tracy.mckib...@.gmail.com> wrote:
> So there is no option in the server settings that will allow you not
> to generate the LDF file? I just don't want the physical file there.
That is equivalent to "I just don't want the database physically".
|||NO, you cannot just cross your arms and tell SQL Server you have no interest
in this physical log file thingy. It is not an option like a GPS unit on a
honda or a see-through window on a PC case. It is an absolutely crticial
and fundamental part of a relational SQL Server database.
<mstinawu@.gmail.com> wrote in message
news:1170957007.328167.269340@.v45g2000cwv.googlegr oups.com...
> Nevermind why, but is there a command that will prevent an LDF file
> from being generated when I attach the MDF using a script?
>