Wednesday, March 28, 2012

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.|||On Feb 8, 12:03 pm, mstin...@.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.
NO... Do you understand what that file is used for?|||<mstinawu@.gmail.com> wrote in message
news:1170957828.166662.205900@.l53g2000cwa.googlegroups.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.googlegroups.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?
>sql

No comments:

Post a Comment