I am not sure but you can try increasing the size of the db and than
truncate the logs.
-----Original Message-----
From: Chris Wood
[mailto:mssqldba-ezmlmshield-x71757088.[Email address protected]
Sent: Friday, July 29, 2005 5:18 PM
To: LazyDBA Discussion
Subject: RE: Log file filing up in minutes!
Have now set it too simple mode but can't get into EM as screen is
frozen,
Tried back up log with truncate_only and also shrinking the file but
query analyser suggests it is completes these tasks but no change
appears to take place if I look at the size of the file manually...
-----Original Message-----
From: Chris Wood
[mailto:mssqldba-ezmlmshield-x3188438.[Email address protected]
Sent: 29 July 2005 12:31
To: LazyDBA Discussion
Subject: Log file filing up in minutes!
Ermergency!
I have a database that was in Simple mode so the log was getting
truncated at checkpoints. I explained to the users that this meant they
would lose all data if it goes down at all and setup a backup of the log
and set it too full recovey mode.
Now the log is expanding so fast I cannot enter EM to change the
properties... back to simple till I work out why it is expanding at
about 1gb every 5 mins... what is the syntax to set it back to simple?
HELP!
----------------------------------------------------------------------
Scope is a registered charity number 208231.
Visit our website at http://www.scope.org.uk
This message, and any file(s) transmitted with it are confidential and
are intended only for the person(s) to whom they have been addressed by
the sender. This message may contain confidential and/or privileged
material. If you are not the intended recipient of this message, or if
you believe it was transmitted to you in error, you are required to
delete the message and any copies of it, and to notify the sender
immediately. Any unauthorised disclosure, copying, distribution, or
printing of this message or accompanying files, or unauthorised use of
any information contained therein, by anyone other than the intended
recipient(s) is prohibited and may be unlawful.
Any views expressed in this message or in any file(s) transmitted with
it are those of the author, and may not necessarily represent the views
of Scope.
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html
----------------------------------------------------------------------
Scope is a registered charity number 208231.
Visit our website at http://www.scope.org.uk
This message, and any file(s) transmitted with it are confidential
and are intended only for the person(s) to whom they have been
addressed by the sender. This message may contain confidential and/or
privileged material. If you are not the intended recipient of this
message, or if you believe it was transmitted to you in error, you are
required to delete the message and any copies of it, and to notify the
sender immediately. Any unauthorised disclosure, copying, distribution,
or printing of this message or accompanying files, or unauthorised use
of any information contained therein, by anyone other than the
intended recipient(s) is prohibited and may be unlawful.
Any views expressed in this message or in any file(s) transmitted with
it are those of the author, and may not necessarily represent the
views of Scope.
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
MS Sql Server LazyDBA home page