corrupt log file?

can someone please help with this?  i have a store whose log file (.ldf file) 
which has grown out of control.  the database size is 1.2gb and the log file 
is 560mb.  i am trying to switch to a new pc but this seems to be causing 
issues and i can not create the database on the new machine from the backup 
as recommended.  does anyone have an idea of how to fix this log growth 
problem?

Thanks,

Jim
0
WallOfFame (24)
4/7/2008 9:54:02 PM
pos 14173 articles. 0 followers. Follow

10 Replies
824 Views

Similar Articles

[PageSpeed] 36

Jim,

The log growth problem is most probably coz of the "Recovery Model", please 
right click on the DB then Properties|Options then change the recovery model 
from "Full" to "Simple"

The next step is to shrink the log file, right click on the DB then 
Tasks|Shrink|Files and shrink the log file to the minimum

-- 
Ahmed Nashat
http://ahmed.nashat.googlepages.com


"WallOfFame" <WallOfFame@discussions.microsoft.com> wrote in message 
news:62C0BCC3-EAA9-48E2-9753-564A31BCC21E@microsoft.com...
> can someone please help with this?  i have a store whose log file (.ldf 
> file)
> which has grown out of control.  the database size is 1.2gb and the log 
> file
> is 560mb.  i am trying to switch to a new pc but this seems to be causing
> issues and i can not create the database on the new machine from the 
> backup
> as recommended.  does anyone have an idea of how to fix this log growth
> problem?
>
> Thanks,
>
> Jim 


0
a_nashat (38)
4/8/2008 8:32:02 AM
Ahmed,

when i right click on the DB (in the MSDE folders for data and go to 
properties i do not get "options" and can not find "revocery model".  am i 
looking in the wrong location?

thanks for any help you can provide!

Jim 

"Ahmed Nashat" wrote:

> Jim,
> 
> The log growth problem is most probably coz of the "Recovery Model", please 
> right click on the DB then Properties|Options then change the recovery model 
> from "Full" to "Simple"
> 
> The next step is to shrink the log file, right click on the DB then 
> Tasks|Shrink|Files and shrink the log file to the minimum
> 
> -- 
> Ahmed Nashat
> http://ahmed.nashat.googlepages.com
> 
> 
> "WallOfFame" <WallOfFame@discussions.microsoft.com> wrote in message 
> news:62C0BCC3-EAA9-48E2-9753-564A31BCC21E@microsoft.com...
> > can someone please help with this?  i have a store whose log file (.ldf 
> > file)
> > which has grown out of control.  the database size is 1.2gb and the log 
> > file
> > is 560mb.  i am trying to switch to a new pc but this seems to be causing
> > issues and i can not create the database on the new machine from the 
> > backup
> > as recommended.  does anyone have an idea of how to fix this log growth
> > problem?
> >
> > Thanks,
> >
> > Jim 
> 
> 
> 
0
WallOfFame (24)
4/8/2008 2:14:14 PM
you should do it in SQL Server Management Studio (Express) if u have SQL 
Server 2005, or Enterprise Manager for SQL Server 2000.

Would u plz tell me what version of RMS/SQL u r running?

-- 
Ahmed Nashat
http://ahmed.nashat.googlepages.com


"WallOfFame" <WallOfFame@discussions.microsoft.com> wrote in message 
news:A6E88F56-A075-4F14-BDAE-CE3CF02BC4E3@microsoft.com...
> Ahmed,
>
> when i right click on the DB (in the MSDE folders for data and go to
> properties i do not get "options" and can not find "revocery model".  am i
> looking in the wrong location?
>
> thanks for any help you can provide!
>
> Jim
>
> "Ahmed Nashat" wrote:
>
>> Jim,
>>
>> The log growth problem is most probably coz of the "Recovery Model", 
>> please
>> right click on the DB then Properties|Options then change the recovery 
>> model
>> from "Full" to "Simple"
>>
>> The next step is to shrink the log file, right click on the DB then
>> Tasks|Shrink|Files and shrink the log file to the minimum
>>
>> -- 
>> Ahmed Nashat
>> http://ahmed.nashat.googlepages.com
>>
>>
>> "WallOfFame" <WallOfFame@discussions.microsoft.com> wrote in message
>> news:62C0BCC3-EAA9-48E2-9753-564A31BCC21E@microsoft.com...
>> > can someone please help with this?  i have a store whose log file (.ldf
>> > file)
>> > which has grown out of control.  the database size is 1.2gb and the log
>> > file
>> > is 560mb.  i am trying to switch to a new pc but this seems to be 
>> > causing
>> > issues and i can not create the database on the new machine from the
>> > backup
>> > as recommended.  does anyone have an idea of how to fix this log growth
>> > problem?
>> >
>> > Thanks,
>> >
>> > Jim
>>
>>
>> 


0
a_nashat (38)
4/8/2008 2:25:20 PM
i am currently running RMS version 1.2 SP3 with sql 2000 (msde version, the 
free version).  can i do what you are telling me to with the version of SQL i 
am using?  if so, could you give me directions?  otherwise, can i use a SQL 
query in Store Operations Administrator?

i really appreciate your help - microsoft can not help with this since my 
version is no longer supported and we are not at a place where we can upgrade 
yet.

Thanks again!

Jim

"Ahmed Nashat" wrote:

> you should do it in SQL Server Management Studio (Express) if u have SQL 
> Server 2005, or Enterprise Manager for SQL Server 2000.
> 
> Would u plz tell me what version of RMS/SQL u r running?
> 
> -- 
> Ahmed Nashat
> http://ahmed.nashat.googlepages.com
> 
> 
> "WallOfFame" <WallOfFame@discussions.microsoft.com> wrote in message 
> news:A6E88F56-A075-4F14-BDAE-CE3CF02BC4E3@microsoft.com...
> > Ahmed,
> >
> > when i right click on the DB (in the MSDE folders for data and go to
> > properties i do not get "options" and can not find "revocery model".  am i
> > looking in the wrong location?
> >
> > thanks for any help you can provide!
> >
> > Jim
> >
> > "Ahmed Nashat" wrote:
> >
> >> Jim,
> >>
> >> The log growth problem is most probably coz of the "Recovery Model", 
> >> please
> >> right click on the DB then Properties|Options then change the recovery 
> >> model
> >> from "Full" to "Simple"
> >>
> >> The next step is to shrink the log file, right click on the DB then
> >> Tasks|Shrink|Files and shrink the log file to the minimum
> >>
> >> -- 
> >> Ahmed Nashat
> >> http://ahmed.nashat.googlepages.com
> >>
> >>
> >> "WallOfFame" <WallOfFame@discussions.microsoft.com> wrote in message
> >> news:62C0BCC3-EAA9-48E2-9753-564A31BCC21E@microsoft.com...
> >> > can someone please help with this?  i have a store whose log file (.ldf
> >> > file)
> >> > which has grown out of control.  the database size is 1.2gb and the log
> >> > file
> >> > is 560mb.  i am trying to switch to a new pc but this seems to be 
> >> > causing
> >> > issues and i can not create the database on the new machine from the
> >> > backup
> >> > as recommended.  does anyone have an idea of how to fix this log growth
> >> > problem?
> >> >
> >> > Thanks,
> >> >
> >> > Jim
> >>
> >>
> >> 
> 
> 
> 
0
WallOfFame (24)
4/8/2008 2:37:02 PM
This is a multi-part message in MIME format.

------=_NextPart_000_0023_01C8999D.7A1EC050
Content-Type: text/plain;
	charset="Utf-8"
Content-Transfer-Encoding: quoted-printable

yes this is doable in sql server 2000 too, but since u have the free =
MSDE version, u should use the following statements from SO =
Administrator: -

  a.. USE master
  ALTER DATABASE dbname SET RECOVERY SIMPLE

  a.. then execute the following to know the name of the DB log to be =
able to shrink it: -
        use dbname=20
        go
        sp_helpfile

  a.. then shrink the log file as follows: -
        DBCC SHRINKFILE(YourLogFileName, 2)

--=20
Ahmed Nashat
http://ahmed.nashat.googlepages.com


"WallOfFame" <WallOfFame@discussions.microsoft.com> wrote in message =
news:D57EBA30-14BB-486B-8098-A4A4ED60454D@microsoft.com...
>i am currently running RMS version 1.2 SP3 with sql 2000 (msde version, =
the=20
> free version).  can i do what you are telling me to with the version =
of SQL i=20
> am using?  if so, could you give me directions?  otherwise, can i use =
a SQL=20
> query in Store Operations Administrator?
>=20
> i really appreciate your help - microsoft can not help with this since =
my=20
> version is no longer supported and we are not at a place where we can =
upgrade=20
> yet.
>=20
> Thanks again!
>=20
> Jim
>=20
> "Ahmed Nashat" wrote:
>=20
>> you should do it in SQL Server Management Studio (Express) if u have =
SQL=20
>> Server 2005, or Enterprise Manager for SQL Server 2000.
>>=20
>> Would u plz tell me what version of RMS/SQL u r running?
>>=20
>> --=20
>> Ahmed Nashat
>> http://ahmed.nashat.googlepages.com
>>=20
>>=20
>> "WallOfFame" <WallOfFame@discussions.microsoft.com> wrote in message=20
>> news:A6E88F56-A075-4F14-BDAE-CE3CF02BC4E3@microsoft.com...
>> > Ahmed,
>> >
>> > when i right click on the DB (in the MSDE folders for data and go =
to
>> > properties i do not get "options" and can not find "revocery =
model".  am i
>> > looking in the wrong location?
>> >
>> > thanks for any help you can provide!
>> >
>> > Jim
>> >
>> > "Ahmed Nashat" wrote:
>> >
>> >> Jim,
>> >>
>> >> The log growth problem is most probably coz of the "Recovery =
Model",=20
>> >> please
>> >> right click on the DB then Properties|Options then change the =
recovery=20
>> >> model
>> >> from "Full" to "Simple"
>> >>
>> >> The next step is to shrink the log file, right click on the DB =
then
>> >> Tasks|Shrink|Files and shrink the log file to the minimum
>> >>
>> >> --=20
>> >> Ahmed Nashat
>> >> http://ahmed.nashat.googlepages.com
>> >>
>> >>
>> >> "WallOfFame" <WallOfFame@discussions.microsoft.com> wrote in =
message
>> >> news:62C0BCC3-EAA9-48E2-9753-564A31BCC21E@microsoft.com...
>> >> > can someone please help with this?  i have a store whose log =
file (.ldf
>> >> > file)
>> >> > which has grown out of control.  the database size is 1.2gb and =
the log
>> >> > file
>> >> > is 560mb.  i am trying to switch to a new pc but this seems to =
be=20
>> >> > causing
>> >> > issues and i can not create the database on the new machine from =
the
>> >> > backup
>> >> > as recommended.  does anyone have an idea of how to fix this log =
growth
>> >> > problem?
>> >> >
>> >> > Thanks,
>> >> >
>> >> > Jim
>> >>
>> >>
>> >>=20
>>=20
>>=20
>>
------=_NextPart_000_0023_01C8999D.7A1EC050
Content-Type: text/html;
	charset="Utf-8"
Content-Transfer-Encoding: quoted-printable

=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dutf-8">
<META content=3D"MSHTML 6.00.6000.16608" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2>yes this is doable in sql server 2000 =
too, but=20
since u have the free MSDE version, u should use the =
following&nbsp;statements=20
from SO Administrator: -</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<UL>
  <LI><FONT face=3DArial size=3D2>USE master<BR>ALTER DATABASE <FONT=20
  color=3D#ff0000>dbname</FONT> SET RECOVERY SIMPLE</FONT></LI></UL>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<UL>
  <LI><FONT face=3DArial size=3D2>then execute the following to know the =
name of the=20
  DB log to be able to shrink it: -</FONT></LI></UL>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; =
use <FONT=20
color=3D#ff0000>dbname</FONT> </FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;=20
go</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;=20
sp_helpfile</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<UL>
  <LI><FONT face=3DArial size=3D2>then shrink the log file as follows:=20
-</FONT></LI></UL>
<DIV><FONT face=3DArial =
size=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DBCC=20
SHRINKFILE(<FONT color=3D#ff0000>YourLogFileName</FONT>, 2)</FONT></DIV>
<DIV><BR><FONT face=3DArial size=3D2>-- <BR>Ahmed Nashat<BR></FONT><A=20
href=3D"http://ahmed.nashat.googlepages.com"><FONT face=3DArial=20
size=3D2>http://ahmed.nashat.googlepages.com</FONT></A></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>"WallOfFame" &lt;</FONT><A=20
href=3D"mailto:WallOfFame@discussions.microsoft.com"><FONT face=3DArial=20
size=3D2>WallOfFame@discussions.microsoft.com</FONT></A><FONT =
face=3DArial=20
size=3D2>&gt; wrote in message </FONT><A=20
href=3D"news:D57EBA30-14BB-486B-8098-A4A4ED60454D@microsoft.com"><FONT =
face=3DArial=20
size=3D2>news:D57EBA30-14BB-486B-8098-A4A4ED60454D@microsoft.com</FONT></=
A><FONT=20
face=3DArial size=3D2>...</FONT></DIV><FONT face=3DArial size=3D2>&gt;i =
am currently=20
running RMS version 1.2 SP3 with sql 2000 (msde version, the <BR>&gt; =
free=20
version).&nbsp; can i do what you are telling me to with the version of =
SQL i=20
<BR>&gt; am using?&nbsp; if so, could you give me directions?&nbsp; =
otherwise,=20
can i use a SQL <BR>&gt; query in Store Operations =
Administrator?<BR>&gt;=20
<BR>&gt; i really appreciate your help - microsoft can not help with =
this since=20
my <BR>&gt; version is no longer supported and we are not at a place =
where we=20
can upgrade <BR>&gt; yet.<BR>&gt; <BR>&gt; Thanks again!<BR>&gt; =
<BR>&gt;=20
Jim<BR>&gt; <BR>&gt; "Ahmed Nashat" wrote:<BR>&gt; <BR>&gt;&gt; you =
should do it=20
in SQL Server Management Studio (Express) if u have SQL <BR>&gt;&gt; =
Server=20
2005, or Enterprise Manager for SQL Server 2000.<BR>&gt;&gt; =
<BR>&gt;&gt; Would=20
u plz tell me what version of RMS/SQL u r running?<BR>&gt;&gt; =
<BR>&gt;&gt; --=20
<BR>&gt;&gt; Ahmed Nashat<BR>&gt;&gt; </FONT><A=20
href=3D"http://ahmed.nashat.googlepages.com"><FONT face=3DArial=20
size=3D2>http://ahmed.nashat.googlepages.com</FONT></A><BR><FONT =
face=3DArial=20
size=3D2>&gt;&gt; <BR>&gt;&gt; <BR>&gt;&gt; "WallOfFame" &lt;</FONT><A=20
href=3D"mailto:WallOfFame@discussions.microsoft.com"><FONT face=3DArial=20
size=3D2>WallOfFame@discussions.microsoft.com</FONT></A><FONT =
face=3DArial=20
size=3D2>&gt; wrote in message <BR>&gt;&gt; </FONT><A=20
href=3D"news:A6E88F56-A075-4F14-BDAE-CE3CF02BC4E3@microsoft.com"><FONT =
face=3DArial=20
size=3D2>news:A6E88F56-A075-4F14-BDAE-CE3CF02BC4E3@microsoft.com</FONT></=
A><FONT=20
face=3DArial size=3D2>...<BR>&gt;&gt; &gt; Ahmed,<BR>&gt;&gt; =
&gt;<BR>&gt;&gt; &gt;=20
when i right click on the DB (in the MSDE folders for data and go =
to<BR>&gt;&gt;=20
&gt; properties i do not get "options" and can not find "revocery =
model".&nbsp;=20
am i<BR>&gt;&gt; &gt; looking in the wrong location?<BR>&gt;&gt;=20
&gt;<BR>&gt;&gt; &gt; thanks for any help you can provide!<BR>&gt;&gt;=20
&gt;<BR>&gt;&gt; &gt; Jim<BR>&gt;&gt; &gt;<BR>&gt;&gt; &gt; "Ahmed =
Nashat"=20
wrote:<BR>&gt;&gt; &gt;<BR>&gt;&gt; &gt;&gt; Jim,<BR>&gt;&gt;=20
&gt;&gt;<BR>&gt;&gt; &gt;&gt; The log growth problem is most probably =
coz of the=20
"Recovery Model", <BR>&gt;&gt; &gt;&gt; please<BR>&gt;&gt; &gt;&gt; =
right click=20
on the DB then Properties|Options then change the recovery <BR>&gt;&gt; =
&gt;&gt;=20
model<BR>&gt;&gt; &gt;&gt; from "Full" to "Simple"<BR>&gt;&gt;=20
&gt;&gt;<BR>&gt;&gt; &gt;&gt; The next step is to shrink the log file, =
right=20
click on the DB then<BR>&gt;&gt; &gt;&gt; Tasks|Shrink|Files and shrink =
the log=20
file to the minimum<BR>&gt;&gt; &gt;&gt;<BR>&gt;&gt; &gt;&gt; -- =
<BR>&gt;&gt;=20
&gt;&gt; Ahmed Nashat<BR>&gt;&gt; &gt;&gt; </FONT><A=20
href=3D"http://ahmed.nashat.googlepages.com"><FONT face=3DArial=20
size=3D2>http://ahmed.nashat.googlepages.com</FONT></A><BR><FONT =
face=3DArial=20
size=3D2>&gt;&gt; &gt;&gt;<BR>&gt;&gt; &gt;&gt;<BR>&gt;&gt; &gt;&gt; =
"WallOfFame"=20
&lt;</FONT><A href=3D"mailto:WallOfFame@discussions.microsoft.com"><FONT =

face=3DArial =
size=3D2>WallOfFame@discussions.microsoft.com</FONT></A><FONT=20
face=3DArial size=3D2>&gt; wrote in message<BR>&gt;&gt; &gt;&gt; =
</FONT><A=20
href=3D"news:62C0BCC3-EAA9-48E2-9753-564A31BCC21E@microsoft.com"><FONT =
face=3DArial=20
size=3D2>news:62C0BCC3-EAA9-48E2-9753-564A31BCC21E@microsoft.com</FONT></=
A><FONT=20
face=3DArial size=3D2>...<BR>&gt;&gt; &gt;&gt; &gt; can someone please =
help with=20
this?&nbsp; i have a store whose log file (.ldf<BR>&gt;&gt; &gt;&gt; =
&gt;=20
file)<BR>&gt;&gt; &gt;&gt; &gt; which has grown out of control.&nbsp; =
the=20
database size is 1.2gb and the log<BR>&gt;&gt; &gt;&gt; &gt; =
file<BR>&gt;&gt;=20
&gt;&gt; &gt; is 560mb.&nbsp; i am trying to switch to a new pc but this =
seems=20
to be <BR>&gt;&gt; &gt;&gt; &gt; causing<BR>&gt;&gt; &gt;&gt; &gt; =
issues and i=20
can not create the database on the new machine from the<BR>&gt;&gt; =
&gt;&gt;=20
&gt; backup<BR>&gt;&gt; &gt;&gt; &gt; as recommended.&nbsp; does anyone =
have an=20
idea of how to fix this log growth<BR>&gt;&gt; &gt;&gt; &gt;=20
problem?<BR>&gt;&gt; &gt;&gt; &gt;<BR>&gt;&gt; &gt;&gt; &gt; =
Thanks,<BR>&gt;&gt;=20
&gt;&gt; &gt;<BR>&gt;&gt; &gt;&gt; &gt; Jim<BR>&gt;&gt; =
&gt;&gt;<BR>&gt;&gt;=20
&gt;&gt;<BR>&gt;&gt; &gt;&gt; <BR>&gt;&gt; <BR>&gt;&gt;=20
<BR>&gt;&gt;</FONT></BODY></HTML>

------=_NextPart_000_0023_01C8999D.7A1EC050--

0
a_nashat (38)
4/8/2008 3:25:01 PM
Ahmed, thanks for your help.  this worked on my test machine but something 
really odd is preventing it from working on my store computer.  when i 
checked the sp_helpfile to find the log file name it does not match to what 
is in the SQL folder with the database.  Inside the sql file folder it shows 
the log as being gfanc03 but the query returned a log name of gfanc02.  i 
tried to shrink gfanc02 and it says that it can't find the file.  i then 
tried what shows in the sql file folder (gfanc03) and it says that it can not 
find the file again.  this system did apparently crash last year and they 
hired someone to repair it.  i'm think the repair was not done properly and 
this is part of the problem.  can you think of any other way to possibly fix 
this?

thanks again for all the help!

Jim

"Ahmed Nashat" wrote:

> yes this is doable in sql server 2000 too, but since u have the free MSDE version, u should use the following statements from SO Administrator: -
> 
>   a.. USE master
>   ALTER DATABASE dbname SET RECOVERY SIMPLE
> 
>   a.. then execute the following to know the name of the DB log to be able to shrink it: -
>         use dbname 
>         go
>         sp_helpfile
> 
>   a.. then shrink the log file as follows: -
>         DBCC SHRINKFILE(YourLogFileName, 2)
> 
> -- 
> Ahmed Nashat
> http://ahmed.nashat.googlepages.com
> 
> 
> "WallOfFame" <WallOfFame@discussions.microsoft.com> wrote in message news:D57EBA30-14BB-486B-8098-A4A4ED60454D@microsoft.com...
> >i am currently running RMS version 1.2 SP3 with sql 2000 (msde version, the 
> > free version).  can i do what you are telling me to with the version of SQL i 
> > am using?  if so, could you give me directions?  otherwise, can i use a SQL 
> > query in Store Operations Administrator?
> > 
> > i really appreciate your help - microsoft can not help with this since my 
> > version is no longer supported and we are not at a place where we can upgrade 
> > yet.
> > 
> > Thanks again!
> > 
> > Jim
> > 
> > "Ahmed Nashat" wrote:
> > 
> >> you should do it in SQL Server Management Studio (Express) if u have SQL 
> >> Server 2005, or Enterprise Manager for SQL Server 2000.
> >> 
> >> Would u plz tell me what version of RMS/SQL u r running?
> >> 
> >> -- 
> >> Ahmed Nashat
> >> http://ahmed.nashat.googlepages.com
> >> 
> >> 
> >> "WallOfFame" <WallOfFame@discussions.microsoft.com> wrote in message 
> >> news:A6E88F56-A075-4F14-BDAE-CE3CF02BC4E3@microsoft.com...
> >> > Ahmed,
> >> >
> >> > when i right click on the DB (in the MSDE folders for data and go to
> >> > properties i do not get "options" and can not find "revocery model".  am i
> >> > looking in the wrong location?
> >> >
> >> > thanks for any help you can provide!
> >> >
> >> > Jim
> >> >
> >> > "Ahmed Nashat" wrote:
> >> >
> >> >> Jim,
> >> >>
> >> >> The log growth problem is most probably coz of the "Recovery Model", 
> >> >> please
> >> >> right click on the DB then Properties|Options then change the recovery 
> >> >> model
> >> >> from "Full" to "Simple"
> >> >>
> >> >> The next step is to shrink the log file, right click on the DB then
> >> >> Tasks|Shrink|Files and shrink the log file to the minimum
> >> >>
> >> >> -- 
> >> >> Ahmed Nashat
> >> >> http://ahmed.nashat.googlepages.com
> >> >>
> >> >>
> >> >> "WallOfFame" <WallOfFame@discussions.microsoft.com> wrote in message
> >> >> news:62C0BCC3-EAA9-48E2-9753-564A31BCC21E@microsoft.com...
> >> >> > can someone please help with this?  i have a store whose log file (.ldf
> >> >> > file)
> >> >> > which has grown out of control.  the database size is 1.2gb and the log
> >> >> > file
> >> >> > is 560mb.  i am trying to switch to a new pc but this seems to be 
> >> >> > causing
> >> >> > issues and i can not create the database on the new machine from the
> >> >> > backup
> >> >> > as recommended.  does anyone have an idea of how to fix this log growth
> >> >> > problem?
> >> >> >
> >> >> > Thanks,
> >> >> >
> >> >> > Jim
> >> >>
> >> >>
> >> >> 
> >> 
> >> 
> >>
0
WallOfFame (24)
4/8/2008 4:38:01 PM
i don't know any other way, plz double check what u r doing, i believe u 
should use the name returned from sp_helpfile regardless to physical file 
now, i suggest that u use the SQL server newgroup to get better support in 
this matter

-- 
Ahmed Nashat
http://ahmed.nashat.googlepages.com
"WallOfFame" <WallOfFame@discussions.microsoft.com> wrote in message 
news:7EBA5390-C199-4C5D-8959-E42793745768@microsoft.com...
> Ahmed, thanks for your help.  this worked on my test machine but something
> really odd is preventing it from working on my store computer.  when i
> checked the sp_helpfile to find the log file name it does not match to 
> what
> is in the SQL folder with the database.  Inside the sql file folder it 
> shows
> the log as being gfanc03 but the query returned a log name of gfanc02.  i
> tried to shrink gfanc02 and it says that it can't find the file.  i then
> tried what shows in the sql file folder (gfanc03) and it says that it can 
> not
> find the file again.  this system did apparently crash last year and they
> hired someone to repair it.  i'm think the repair was not done properly 
> and
> this is part of the problem.  can you think of any other way to possibly 
> fix
> this?
>
> thanks again for all the help!
>
> Jim
>
> "Ahmed Nashat" wrote:
>
>> yes this is doable in sql server 2000 too, but since u have the free MSDE 
>> version, u should use the following statements from SO Administrator: -
>>
>>   a.. USE master
>>   ALTER DATABASE dbname SET RECOVERY SIMPLE
>>
>>   a.. then execute the following to know the name of the DB log to be 
>> able to shrink it: -
>>         use dbname
>>         go
>>         sp_helpfile
>>
>>   a.. then shrink the log file as follows: -
>>         DBCC SHRINKFILE(YourLogFileName, 2)
>>
>> -- 
>> Ahmed Nashat
>> http://ahmed.nashat.googlepages.com
>>
>>
>> "WallOfFame" <WallOfFame@discussions.microsoft.com> wrote in message 
>> news:D57EBA30-14BB-486B-8098-A4A4ED60454D@microsoft.com...
>> >i am currently running RMS version 1.2 SP3 with sql 2000 (msde version, 
>> >the
>> > free version).  can i do what you are telling me to with the version of 
>> > SQL i
>> > am using?  if so, could you give me directions?  otherwise, can i use a 
>> > SQL
>> > query in Store Operations Administrator?
>> >
>> > i really appreciate your help - microsoft can not help with this since 
>> > my
>> > version is no longer supported and we are not at a place where we can 
>> > upgrade
>> > yet.
>> >
>> > Thanks again!
>> >
>> > Jim
>> >
>> > "Ahmed Nashat" wrote:
>> >
>> >> you should do it in SQL Server Management Studio (Express) if u have 
>> >> SQL
>> >> Server 2005, or Enterprise Manager for SQL Server 2000.
>> >>
>> >> Would u plz tell me what version of RMS/SQL u r running?
>> >>
>> >> -- 
>> >> Ahmed Nashat
>> >> http://ahmed.nashat.googlepages.com
>> >>
>> >>
>> >> "WallOfFame" <WallOfFame@discussions.microsoft.com> wrote in message
>> >> news:A6E88F56-A075-4F14-BDAE-CE3CF02BC4E3@microsoft.com...
>> >> > Ahmed,
>> >> >
>> >> > when i right click on the DB (in the MSDE folders for data and go to
>> >> > properties i do not get "options" and can not find "revocery model". 
>> >> > am i
>> >> > looking in the wrong location?
>> >> >
>> >> > thanks for any help you can provide!
>> >> >
>> >> > Jim
>> >> >
>> >> > "Ahmed Nashat" wrote:
>> >> >
>> >> >> Jim,
>> >> >>
>> >> >> The log growth problem is most probably coz of the "Recovery 
>> >> >> Model",
>> >> >> please
>> >> >> right click on the DB then Properties|Options then change the 
>> >> >> recovery
>> >> >> model
>> >> >> from "Full" to "Simple"
>> >> >>
>> >> >> The next step is to shrink the log file, right click on the DB then
>> >> >> Tasks|Shrink|Files and shrink the log file to the minimum
>> >> >>
>> >> >> -- 
>> >> >> Ahmed Nashat
>> >> >> http://ahmed.nashat.googlepages.com
>> >> >>
>> >> >>
>> >> >> "WallOfFame" <WallOfFame@discussions.microsoft.com> wrote in 
>> >> >> message
>> >> >> news:62C0BCC3-EAA9-48E2-9753-564A31BCC21E@microsoft.com...
>> >> >> > can someone please help with this?  i have a store whose log file 
>> >> >> > (.ldf
>> >> >> > file)
>> >> >> > which has grown out of control.  the database size is 1.2gb and 
>> >> >> > the log
>> >> >> > file
>> >> >> > is 560mb.  i am trying to switch to a new pc but this seems to be
>> >> >> > causing
>> >> >> > issues and i can not create the database on the new machine from 
>> >> >> > the
>> >> >> > backup
>> >> >> > as recommended.  does anyone have an idea of how to fix this log 
>> >> >> > growth
>> >> >> > problem?
>> >> >> >
>> >> >> > Thanks,
>> >> >> >
>> >> >> > Jim
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >> 


0
a_nashat (38)
4/8/2008 5:08:33 PM
ok, that sounds good.  thanks again for all the help you were aboe to provide.

Thanks!

"Ahmed Nashat" wrote:

> i don't know any other way, plz double check what u r doing, i believe u 
> should use the name returned from sp_helpfile regardless to physical file 
> now, i suggest that u use the SQL server newgroup to get better support in 
> this matter
> 
> -- 
> Ahmed Nashat
> http://ahmed.nashat.googlepages.com
> "WallOfFame" <WallOfFame@discussions.microsoft.com> wrote in message 
> news:7EBA5390-C199-4C5D-8959-E42793745768@microsoft.com...
> > Ahmed, thanks for your help.  this worked on my test machine but something
> > really odd is preventing it from working on my store computer.  when i
> > checked the sp_helpfile to find the log file name it does not match to 
> > what
> > is in the SQL folder with the database.  Inside the sql file folder it 
> > shows
> > the log as being gfanc03 but the query returned a log name of gfanc02.  i
> > tried to shrink gfanc02 and it says that it can't find the file.  i then
> > tried what shows in the sql file folder (gfanc03) and it says that it can 
> > not
> > find the file again.  this system did apparently crash last year and they
> > hired someone to repair it.  i'm think the repair was not done properly 
> > and
> > this is part of the problem.  can you think of any other way to possibly 
> > fix
> > this?
> >
> > thanks again for all the help!
> >
> > Jim
> >
> > "Ahmed Nashat" wrote:
> >
> >> yes this is doable in sql server 2000 too, but since u have the free MSDE 
> >> version, u should use the following statements from SO Administrator: -
> >>
> >>   a.. USE master
> >>   ALTER DATABASE dbname SET RECOVERY SIMPLE
> >>
> >>   a.. then execute the following to know the name of the DB log to be 
> >> able to shrink it: -
> >>         use dbname
> >>         go
> >>         sp_helpfile
> >>
> >>   a.. then shrink the log file as follows: -
> >>         DBCC SHRINKFILE(YourLogFileName, 2)
> >>
> >> -- 
> >> Ahmed Nashat
> >> http://ahmed.nashat.googlepages.com
> >>
> >>
> >> "WallOfFame" <WallOfFame@discussions.microsoft.com> wrote in message 
> >> news:D57EBA30-14BB-486B-8098-A4A4ED60454D@microsoft.com...
> >> >i am currently running RMS version 1.2 SP3 with sql 2000 (msde version, 
> >> >the
> >> > free version).  can i do what you are telling me to with the version of 
> >> > SQL i
> >> > am using?  if so, could you give me directions?  otherwise, can i use a 
> >> > SQL
> >> > query in Store Operations Administrator?
> >> >
> >> > i really appreciate your help - microsoft can not help with this since 
> >> > my
> >> > version is no longer supported and we are not at a place where we can 
> >> > upgrade
> >> > yet.
> >> >
> >> > Thanks again!
> >> >
> >> > Jim
> >> >
> >> > "Ahmed Nashat" wrote:
> >> >
> >> >> you should do it in SQL Server Management Studio (Express) if u have 
> >> >> SQL
> >> >> Server 2005, or Enterprise Manager for SQL Server 2000.
> >> >>
> >> >> Would u plz tell me what version of RMS/SQL u r running?
> >> >>
> >> >> -- 
> >> >> Ahmed Nashat
> >> >> http://ahmed.nashat.googlepages.com
> >> >>
> >> >>
> >> >> "WallOfFame" <WallOfFame@discussions.microsoft.com> wrote in message
> >> >> news:A6E88F56-A075-4F14-BDAE-CE3CF02BC4E3@microsoft.com...
> >> >> > Ahmed,
> >> >> >
> >> >> > when i right click on the DB (in the MSDE folders for data and go to
> >> >> > properties i do not get "options" and can not find "revocery model". 
> >> >> > am i
> >> >> > looking in the wrong location?
> >> >> >
> >> >> > thanks for any help you can provide!
> >> >> >
> >> >> > Jim
> >> >> >
> >> >> > "Ahmed Nashat" wrote:
> >> >> >
> >> >> >> Jim,
> >> >> >>
> >> >> >> The log growth problem is most probably coz of the "Recovery 
> >> >> >> Model",
> >> >> >> please
> >> >> >> right click on the DB then Properties|Options then change the 
> >> >> >> recovery
> >> >> >> model
> >> >> >> from "Full" to "Simple"
> >> >> >>
> >> >> >> The next step is to shrink the log file, right click on the DB then
> >> >> >> Tasks|Shrink|Files and shrink the log file to the minimum
> >> >> >>
> >> >> >> -- 
> >> >> >> Ahmed Nashat
> >> >> >> http://ahmed.nashat.googlepages.com
> >> >> >>
> >> >> >>
> >> >> >> "WallOfFame" <WallOfFame@discussions.microsoft.com> wrote in 
> >> >> >> message
> >> >> >> news:62C0BCC3-EAA9-48E2-9753-564A31BCC21E@microsoft.com...
> >> >> >> > can someone please help with this?  i have a store whose log file 
> >> >> >> > (.ldf
> >> >> >> > file)
> >> >> >> > which has grown out of control.  the database size is 1.2gb and 
> >> >> >> > the log
> >> >> >> > file
> >> >> >> > is 560mb.  i am trying to switch to a new pc but this seems to be
> >> >> >> > causing
> >> >> >> > issues and i can not create the database on the new machine from 
> >> >> >> > the
> >> >> >> > backup
> >> >> >> > as recommended.  does anyone have an idea of how to fix this log 
> >> >> >> > growth
> >> >> >> > problem?
> >> >> >> >
> >> >> >> > Thanks,
> >> >> >> >
> >> >> >> > Jim
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >> 
> 
> 
> 
0
WallOfFame (24)
4/8/2008 5:21:03 PM
Wall....after setting the recovery mode to simple, disconnect, then reconnect 
to your database and reindex.  check the properties of the database in store 
ops administrator (database - properties) and see if the log file shrank....

"WallOfFame" wrote:

> ok, that sounds good.  thanks again for all the help you were aboe to provide.
> 
> Thanks!
> 
> "Ahmed Nashat" wrote:
> 
> > i don't know any other way, plz double check what u r doing, i believe u 
> > should use the name returned from sp_helpfile regardless to physical file 
> > now, i suggest that u use the SQL server newgroup to get better support in 
> > this matter
> > 
> > -- 
> > Ahmed Nashat
> > http://ahmed.nashat.googlepages.com
> > "WallOfFame" <WallOfFame@discussions.microsoft.com> wrote in message 
> > news:7EBA5390-C199-4C5D-8959-E42793745768@microsoft.com...
> > > Ahmed, thanks for your help.  this worked on my test machine but something
> > > really odd is preventing it from working on my store computer.  when i
> > > checked the sp_helpfile to find the log file name it does not match to 
> > > what
> > > is in the SQL folder with the database.  Inside the sql file folder it 
> > > shows
> > > the log as being gfanc03 but the query returned a log name of gfanc02.  i
> > > tried to shrink gfanc02 and it says that it can't find the file.  i then
> > > tried what shows in the sql file folder (gfanc03) and it says that it can 
> > > not
> > > find the file again.  this system did apparently crash last year and they
> > > hired someone to repair it.  i'm think the repair was not done properly 
> > > and
> > > this is part of the problem.  can you think of any other way to possibly 
> > > fix
> > > this?
> > >
> > > thanks again for all the help!
> > >
> > > Jim
> > >
> > > "Ahmed Nashat" wrote:
> > >
> > >> yes this is doable in sql server 2000 too, but since u have the free MSDE 
> > >> version, u should use the following statements from SO Administrator: -
> > >>
> > >>   a.. USE master
> > >>   ALTER DATABASE dbname SET RECOVERY SIMPLE
> > >>
> > >>   a.. then execute the following to know the name of the DB log to be 
> > >> able to shrink it: -
> > >>         use dbname
> > >>         go
> > >>         sp_helpfile
> > >>
> > >>   a.. then shrink the log file as follows: -
> > >>         DBCC SHRINKFILE(YourLogFileName, 2)
> > >>
> > >> -- 
> > >> Ahmed Nashat
> > >> http://ahmed.nashat.googlepages.com
> > >>
> > >>
> > >> "WallOfFame" <WallOfFame@discussions.microsoft.com> wrote in message 
> > >> news:D57EBA30-14BB-486B-8098-A4A4ED60454D@microsoft.com...
> > >> >i am currently running RMS version 1.2 SP3 with sql 2000 (msde version, 
> > >> >the
> > >> > free version).  can i do what you are telling me to with the version of 
> > >> > SQL i
> > >> > am using?  if so, could you give me directions?  otherwise, can i use a 
> > >> > SQL
> > >> > query in Store Operations Administrator?
> > >> >
> > >> > i really appreciate your help - microsoft can not help with this since 
> > >> > my
> > >> > version is no longer supported and we are not at a place where we can 
> > >> > upgrade
> > >> > yet.
> > >> >
> > >> > Thanks again!
> > >> >
> > >> > Jim
> > >> >
> > >> > "Ahmed Nashat" wrote:
> > >> >
> > >> >> you should do it in SQL Server Management Studio (Express) if u have 
> > >> >> SQL
> > >> >> Server 2005, or Enterprise Manager for SQL Server 2000.
> > >> >>
> > >> >> Would u plz tell me what version of RMS/SQL u r running?
> > >> >>
> > >> >> -- 
> > >> >> Ahmed Nashat
> > >> >> http://ahmed.nashat.googlepages.com
> > >> >>
> > >> >>
> > >> >> "WallOfFame" <WallOfFame@discussions.microsoft.com> wrote in message
> > >> >> news:A6E88F56-A075-4F14-BDAE-CE3CF02BC4E3@microsoft.com...
> > >> >> > Ahmed,
> > >> >> >
> > >> >> > when i right click on the DB (in the MSDE folders for data and go to
> > >> >> > properties i do not get "options" and can not find "revocery model". 
> > >> >> > am i
> > >> >> > looking in the wrong location?
> > >> >> >
> > >> >> > thanks for any help you can provide!
> > >> >> >
> > >> >> > Jim
> > >> >> >
> > >> >> > "Ahmed Nashat" wrote:
> > >> >> >
> > >> >> >> Jim,
> > >> >> >>
> > >> >> >> The log growth problem is most probably coz of the "Recovery 
> > >> >> >> Model",
> > >> >> >> please
> > >> >> >> right click on the DB then Properties|Options then change the 
> > >> >> >> recovery
> > >> >> >> model
> > >> >> >> from "Full" to "Simple"
> > >> >> >>
> > >> >> >> The next step is to shrink the log file, right click on the DB then
> > >> >> >> Tasks|Shrink|Files and shrink the log file to the minimum
> > >> >> >>
> > >> >> >> -- 
> > >> >> >> Ahmed Nashat
> > >> >> >> http://ahmed.nashat.googlepages.com
> > >> >> >>
> > >> >> >>
> > >> >> >> "WallOfFame" <WallOfFame@discussions.microsoft.com> wrote in 
> > >> >> >> message
> > >> >> >> news:62C0BCC3-EAA9-48E2-9753-564A31BCC21E@microsoft.com...
> > >> >> >> > can someone please help with this?  i have a store whose log file 
> > >> >> >> > (.ldf
> > >> >> >> > file)
> > >> >> >> > which has grown out of control.  the database size is 1.2gb and 
> > >> >> >> > the log
> > >> >> >> > file
> > >> >> >> > is 560mb.  i am trying to switch to a new pc but this seems to be
> > >> >> >> > causing
> > >> >> >> > issues and i can not create the database on the new machine from 
> > >> >> >> > the
> > >> >> >> > backup
> > >> >> >> > as recommended.  does anyone have an idea of how to fix this log 
> > >> >> >> > growth
> > >> >> >> > problem?
> > >> >> >> >
> > >> >> >> > Thanks,
> > >> >> >> >
> > >> >> >> > Jim
> > >> >> >>
> > >> >> >>
> > >> >> >>
> > >> >>
> > >> >>
> > >> >> 
> > 
> > 
> > 
0
convoluted (621)
4/8/2008 7:51:00 PM
Is there a rule of thumb as to how large your Log file should be?
Craig

"convoluted" <convoluted@discussions.microsoft.com> wrote in message 
news:0235AE69-C36A-4F94-A9BE-251C62EB105E@microsoft.com...
> Wall....after setting the recovery mode to simple, disconnect, then 
> reconnect
> to your database and reindex.  check the properties of the database in 
> store
> ops administrator (database - properties) and see if the log file 
> shrank....
>
> "WallOfFame" wrote:
>
>> ok, that sounds good.  thanks again for all the help you were aboe to 
>> provide.
>>
>> Thanks!
>>
>> "Ahmed Nashat" wrote:
>>
>> > i don't know any other way, plz double check what u r doing, i believe 
>> > u
>> > should use the name returned from sp_helpfile regardless to physical 
>> > file
>> > now, i suggest that u use the SQL server newgroup to get better support 
>> > in
>> > this matter
>> >
>> > -- 
>> > Ahmed Nashat
>> > http://ahmed.nashat.googlepages.com
>> > "WallOfFame" <WallOfFame@discussions.microsoft.com> wrote in message
>> > news:7EBA5390-C199-4C5D-8959-E42793745768@microsoft.com...
>> > > Ahmed, thanks for your help.  this worked on my test machine but 
>> > > something
>> > > really odd is preventing it from working on my store computer.  when 
>> > > i
>> > > checked the sp_helpfile to find the log file name it does not match 
>> > > to
>> > > what
>> > > is in the SQL folder with the database.  Inside the sql file folder 
>> > > it
>> > > shows
>> > > the log as being gfanc03 but the query returned a log name of 
>> > > gfanc02.  i
>> > > tried to shrink gfanc02 and it says that it can't find the file.  i 
>> > > then
>> > > tried what shows in the sql file folder (gfanc03) and it says that it 
>> > > can
>> > > not
>> > > find the file again.  this system did apparently crash last year and 
>> > > they
>> > > hired someone to repair it.  i'm think the repair was not done 
>> > > properly
>> > > and
>> > > this is part of the problem.  can you think of any other way to 
>> > > possibly
>> > > fix
>> > > this?
>> > >
>> > > thanks again for all the help!
>> > >
>> > > Jim
>> > >
>> > > "Ahmed Nashat" wrote:
>> > >
>> > >> yes this is doable in sql server 2000 too, but since u have the free 
>> > >> MSDE
>> > >> version, u should use the following statements from SO 
>> > >> Administrator: -
>> > >>
>> > >>   a.. USE master
>> > >>   ALTER DATABASE dbname SET RECOVERY SIMPLE
>> > >>
>> > >>   a.. then execute the following to know the name of the DB log to 
>> > >> be
>> > >> able to shrink it: -
>> > >>         use dbname
>> > >>         go
>> > >>         sp_helpfile
>> > >>
>> > >>   a.. then shrink the log file as follows: -
>> > >>         DBCC SHRINKFILE(YourLogFileName, 2)
>> > >>
>> > >> -- 
>> > >> Ahmed Nashat
>> > >> http://ahmed.nashat.googlepages.com
>> > >>
>> > >>
>> > >> "WallOfFame" <WallOfFame@discussions.microsoft.com> wrote in message
>> > >> news:D57EBA30-14BB-486B-8098-A4A4ED60454D@microsoft.com...
>> > >> >i am currently running RMS version 1.2 SP3 with sql 2000 (msde 
>> > >> >version,
>> > >> >the
>> > >> > free version).  can i do what you are telling me to with the 
>> > >> > version of
>> > >> > SQL i
>> > >> > am using?  if so, could you give me directions?  otherwise, can i 
>> > >> > use a
>> > >> > SQL
>> > >> > query in Store Operations Administrator?
>> > >> >
>> > >> > i really appreciate your help - microsoft can not help with this 
>> > >> > since
>> > >> > my
>> > >> > version is no longer supported and we are not at a place where we 
>> > >> > can
>> > >> > upgrade
>> > >> > yet.
>> > >> >
>> > >> > Thanks again!
>> > >> >
>> > >> > Jim
>> > >> >
>> > >> > "Ahmed Nashat" wrote:
>> > >> >
>> > >> >> you should do it in SQL Server Management Studio (Express) if u 
>> > >> >> have
>> > >> >> SQL
>> > >> >> Server 2005, or Enterprise Manager for SQL Server 2000.
>> > >> >>
>> > >> >> Would u plz tell me what version of RMS/SQL u r running?
>> > >> >>
>> > >> >> -- 
>> > >> >> Ahmed Nashat
>> > >> >> http://ahmed.nashat.googlepages.com
>> > >> >>
>> > >> >>
>> > >> >> "WallOfFame" <WallOfFame@discussions.microsoft.com> wrote in 
>> > >> >> message
>> > >> >> news:A6E88F56-A075-4F14-BDAE-CE3CF02BC4E3@microsoft.com...
>> > >> >> > Ahmed,
>> > >> >> >
>> > >> >> > when i right click on the DB (in the MSDE folders for data and 
>> > >> >> > go to
>> > >> >> > properties i do not get "options" and can not find "revocery 
>> > >> >> > model".
>> > >> >> > am i
>> > >> >> > looking in the wrong location?
>> > >> >> >
>> > >> >> > thanks for any help you can provide!
>> > >> >> >
>> > >> >> > Jim
>> > >> >> >
>> > >> >> > "Ahmed Nashat" wrote:
>> > >> >> >
>> > >> >> >> Jim,
>> > >> >> >>
>> > >> >> >> The log growth problem is most probably coz of the "Recovery
>> > >> >> >> Model",
>> > >> >> >> please
>> > >> >> >> right click on the DB then Properties|Options then change the
>> > >> >> >> recovery
>> > >> >> >> model
>> > >> >> >> from "Full" to "Simple"
>> > >> >> >>
>> > >> >> >> The next step is to shrink the log file, right click on the DB 
>> > >> >> >> then
>> > >> >> >> Tasks|Shrink|Files and shrink the log file to the minimum
>> > >> >> >>
>> > >> >> >> -- 
>> > >> >> >> Ahmed Nashat
>> > >> >> >> http://ahmed.nashat.googlepages.com
>> > >> >> >>
>> > >> >> >>
>> > >> >> >> "WallOfFame" <WallOfFame@discussions.microsoft.com> wrote in
>> > >> >> >> message
>> > >> >> >> news:62C0BCC3-EAA9-48E2-9753-564A31BCC21E@microsoft.com...
>> > >> >> >> > can someone please help with this?  i have a store whose log 
>> > >> >> >> > file
>> > >> >> >> > (.ldf
>> > >> >> >> > file)
>> > >> >> >> > which has grown out of control.  the database size is 1.2gb 
>> > >> >> >> > and
>> > >> >> >> > the log
>> > >> >> >> > file
>> > >> >> >> > is 560mb.  i am trying to switch to a new pc but this seems 
>> > >> >> >> > to be
>> > >> >> >> > causing
>> > >> >> >> > issues and i can not create the database on the new machine 
>> > >> >> >> > from
>> > >> >> >> > the
>> > >> >> >> > backup
>> > >> >> >> > as recommended.  does anyone have an idea of how to fix this 
>> > >> >> >> > log
>> > >> >> >> > growth
>> > >> >> >> > problem?
>> > >> >> >> >
>> > >> >> >> > Thanks,
>> > >> >> >> >
>> > >> >> >> > Jim
>> > >> >> >>
>> > >> >> >>
>> > >> >> >>
>> > >> >>
>> > >> >>
>> > >> >>
>> >
>> >
>> > 

0
craig6967 (916)
4/10/2008 4:10:01 PM
Reply:

Similar Artilces:

Changing a file name #3
Say I want to change the name of a certain file at run-time, how do I do this (and delete the original file)? Can I do this using MFC? Try CFile::Rename, http://msdn2.microsoft.com/en-us/library/0y89a13f(vs.80).aspx -- =================================================== If the message was helpful to you, click Yes next to Was this post helpful to you? Regards, Goldbach "hamishd" wrote: > Say I want to change the name of a certain file at run-time, how do I > do this (and delete the original file)? > > Can I do this using MFC? > > ...

Copy and paste a Publisher file with a background into email?
I need to copy and paste a Publisher publication foreground and background into an email to a client who does not have a publishing program. I have copied and pasted 100's of times but never something with a background. I can copy and paste the foreground and background individually but I need it to show as it does in Publisher, not as two separate pages. Is there any way I can do this? Send it as a .pdf file. -- JoAnn Paules MVP Microsoft [Publisher] "scorpio102362" <scorpio102362@discussions.microsoft.com> wrote in message news:71AEEED7-C4B8-44E3-9D01-B539...

Deleted Investments Re-appear in Money 05 File
When I upgraded from Money 2004 I now see some investments which were deleted in the 2004 version reappear. I cannot work with these "ghost" investments as Money will not buy, sell etc with them. They appear to have been incorrectly included during the upgrade. Trying to delete etc does nothing. I have updated to build 1105 in Money 05 then converted the Money 04 file again but to no avail. Any ideas how to remove? thanks Scott Its OK I finally manged to add a buy transactions to it then trying to delete it worked. No need for help scott "Scott Thomson" <v...

Count how many specific character there is in a string(readed from txt file)
Hi all, I'm looking a way to exit from the DO loop when the line finish. I read this line from a TXT file and i use ; to split che parameter. I need know how many ; there are in one line. Ex: line: test1;test2;test3;test4 result 3 (3 ; in the line) Someone can help me??? thx in advance. Maw "Maw" <maw81maw@gmail.com> wrote in message news:663ec1d3-b10c-4a62-a343-e80c504fdd2b@g19g2000yqc.googlegroups.com... > Hi all, > I'm looking a way to exit from the DO loop when the line finish. > I read this line from a TXT file and i use ; to ...

Excel files won't come up
I am having trouble bringing up any Excel file. I get an error message with a error signature like this AppName:Excel.exe AppVer 9.0.0.2719 ModName:mso9:11 ModVer:9.0.0.2720 Offset:00045909 When I look up the tech information at the bottom I get this c:\docume~1\HarryG~1\Locals~1\temp\2958_appcompat.txt I sent this message last week and the remark was to double click and copy the error and reply. I did and I haven't seen any reply yet. I really need to use the Excel files which I use often. All other ofice files OK Help!!! I don't have a guess about what's ...

First Slide with mp3 file not advancing in powerpoint show
I have inserted an .mp3 file on the first slide of my PowerPoint Show. I have added transition effects and timing. When I try to start the show slide 1 just sits there and doesn't transition to Slide 2. I don't know what I'm doing wrong but I need an answer today (Tueday 5/18) if at all possible. Look at problem 1 and answer 2 here. http://www.pptalchemy.co.uk/keep_playing.html -- john ATSIGN PPTAlchemy.co.uk Free PPT Hints, Tips and Tutorials http://www.pptalchemy.co.uk/powerpoint_hints_and_tips_tutorials.html "mpeters306" wrote: > I...

putting HTML into XSL files
Hi all, from every example I've ever seen on using XSL files, the user is able to put HTML into the XSL file Well, I'm making use of the XPathDocument and XSLTransform classes to transform some XML content into HTML. I would like to include "img" tags and potentially "br" tags in the XSL file, but I get errors like this The 'img' start tag on line '22' doesn't match the end tag of 'td' in file 'file:///c:/inetpub/wwwroot/SomeApplication/someXSLFile.xsl'. Line 22, position 33. when I call the XSLTransform.Load method - is there...

'file in use' not showing
Dear all, I'm new in this forum, sorry if problem I'm explaining isn't new fo you. I try to explain with my poor English: in company where I am, user works with Windows XP and Office XP sp3. Some times when they open excel file on a network share already opened by someone, doesn' receives the usual notification "file in use". I'm supposing that is caused by slow network performances. Someone can help me? TNX and sorry for my bad English:eek -- slupp ----------------------------------------------------------------------- sluppo's Profile: http://www.excelfo...

URGENT : Exchange server delete ZIP files, but filtering disable!!!!
Hi, I'm disappointed... I've a SBS 2003 server with Exchange Server 2003. I've just received an email with a "deleted0.txt" file instead-of a ZIP file. But the email attachment security is disable, and, in the past, ZIP files can be accessible to my users. The SecAttsConfig.xml is set to : <SecAttsConfig> <Enabled>False</Enabled> <SaveToFile Enabled="False" Location="" /> - <UnsafeAttachments> ..... I've change nothing in my config, I've just applyed latest services packs and updates. Where are the other se...

file time
hi, I need some code that find the 10 first files created in a directory, can any one sent me a function that do that for vc++/mfc - 6? Thanks Take a look at the CFileFind MFC class. -- Cheers Check Abdoul [VC++ MVP] ----------------------------------- "Dave" <dbg@012.net.il> wrote in message news:eMKa15o9EHA.2196@TK2MSFTNGP11.phx.gbl... > hi, > I need some code that find the 10 first files created in a directory, can > any one sent me a function that do that for vc++/mfc - 6? > Thanks > > Hi, Is there any way to change directory creation/ modif...

Removing file extensions on e-mail
How do I remove the file extension (i.e. xls or xlsx) when e-mailing an Excel workbook from directly within the workbook instead of attaching the workbook to an e-mail? Why ever would you want to do that? John S wrote: > How do I remove the file extension (i.e. xls or xlsx) when e-mailing an Excel > workbook from directly within the workbook instead of attaching the workbook > to an e-mail? ...

problem with creating mat files from C++ (visual studio 2005)
Hi, I am having trouble creating mat files from my visual studio 2005 express. For example, the matcreat.c file that is given as an example in the mathworks site, produced 13 linking errors of this type: 1>Linking... 1>matcreat.obj : error LNK2019: unresolved external symbol _mxGetString referenced in function _main (...) this happened although I set up the VC++ directories for include files and libraries to point to the matlab\extern\include and matlab\extern\lib\ respectively. Any help will be greatly appreciated. Thank you ilias PS. Some secondary questions I have: (a) mex -setup...

Can anyone tell me how to transfer an Excel file to a Pocket PC?
I have an Ipaq 3850 with pocket excel and pocket word. I need to make a file with passcodes that I can view on my Ipaq. Help? -- "You can have everything in life you want, if you will just help enough other people get what they want." -- Zig Ziglar If you mean password, then send it to the PDA without a password and then go to Pocket Excel and set the password from there -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS "vms" <vms@discussions.microsoft.com> wrote in message news:671F901A-BD27-4513-8102-E2B46...

Quicken Personal 2002 files
Can Money 2004 Standard (International English) convert Quicken Personal/Personal Plus 2002 files (Australia editions) It's not clear if it will or not. Generally converting international editions is more "dicey." -- Will you sponsor me in the Tour de Cure? http://main.diabetes.org/site/TR?pg=personal&fr_id=1058&px=1626087 "A.A. Fussy" <amarks@austarnet.com.au> wrote in message news:bfa9g2$v9k$1@austar-news.austar.net.au... > Can Money 2004 Standard (International English) convert Quicken > Personal/Personal Plus 2002 files (Australia edition...

Parse(?) data from text file
I have a large text file that has hundresds (or thousands) of compiled questionairres that I want to convert to a more usable format (excel?). Here is what it looks like: ======================== Name: Joe Jones Address: 123 main comment: varies from blank to 20+ lines may have muliple paragraphs others: 8 or 10 other fields =============================== next questionnaire ====================== A couple of details: the separator line of ====s vary in length, the individual questionnaires are not always identical. Some have a couple of extra 'fields'. I envision a separat...

Insert file name in header without showing extension
I know how to get the filename into a header/footer. Is there any way to get the filename in the header/footer WITHOUT showing the filename extension? 1) Click on 'My Computer' > 'Tools' > 'Folder Options...' > View tab and check the option "Hide extensions for known files". OR: 2) If you don't want to change the way your computer displays file names - make use of a Macro: ------------------------------------------------------- Sub Header_FileName_No_Extension() On Error Resume Next LFN = InStrRev(ActiveWorkbook.Name, "...

Importing CSV FIles #2
Does anyone know if there is a way to force Excel to expand columns to the maximun width needed when opening a .CSV file? I am looking to minimize user input. CSV is a text format. When u import txt. file, first "save as" Excel format. After that open the workbook again(now in excel format). Go to "data" menu use "text to columns" tab. Yr data would be converted to columns. >-----Original Message----- >CSV is a text format. When u import txt. file, first "save as" Excel format. After that open the workbook again(now in excel format). Go to ...

vba code for excel to extract data from txt file
USING Excel 2000. I have a text file that when viewed in excel lists the entire row of data in one cell. I cannot parse data because each line does not have the same break. I want to extract the fields into individual cells. I will need to define "what" I am looking for. Is there sample vba code for excel I can reference to learn how this may be done? sample report REF #:A1B CUSIP:12345678 TD:1/1/00 SYMBOL:ABC QTY: 1 SD:01/03/00 ACME COMPANY PRICE: 9.101 MKT:OTC want to extract REF# TD ...

i cant open a file for editing?
when i open a file, i cant edit? If this is a question, you have provided very little detail to assist with helping you. What prevents you from editing? What is the error message you get? Is the sheet protected with cells locked? Gord Dibben MS Excel MVP On Sat, 30 Jan 2010 07:49:02 -0800, caroline <caroline@discussions.microsoft.com> wrote: >when i open a file, i cant edit? ...

Delete lines from txt file
With code like the following: Open "c:\MyLog.txt" For Output As #1 Write #1, strError Close #1 I log the errors users encounter. However I don't want this file to become bigger than about 250 lines. So I am thinking of a cleaning routine which runs when the first user of that day logs in, and deletes the oldest lines, so that that are only 250 lines left. How would I go about this or are there better approaches / other ideas? Thanks, Lars One approach would be to read the entire content of the file into a variable, use the Split function to ...

How can I create an XSD document based on an XML file content?
Is it possible to create your won XSD to use with .NET based on an XML content? For example the one below: <?xml version="1.0"?> <pcats:FuelsDoc xmlns="http://www.naxml.org/Retail-EDI/Vocabulary/2003-10-16" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="NAXML-FuelPrice15.xsd"> <pcats:TransmissionHeader> <pcats:TransmissionId>200706040938</pcats:TransmissionId> <pcats:TransmissionDate>2007-06-04</pcats:TransmissionDate> <pcats:TransmissionTime>09:38:19-06:00</pcats:Transmis...

"Explorer /select" to select file in already-opened window
Hi, I need to programatically select/highlight a file in Windows Explorer. "Explorer /select,x:\path\to\file" works if the folder window is NOT already open, but it has no effect if the folder window is already open. I would rather not use /n to open yet another new Explorer window of the same folder. Is it possible to select a file regardless of whether the folder window is already open? Is there a Windows API for it? Thanks. ...

Can't attach files now
Hi, I have been using Windows Mail (The 2006 desktop version) for quite sometime now. I have always been able to attach files but today when I tried to send my resume like I always do, it wouldn't attach. It says some files could not be attached. What is the problem with that? "asiankelsey" <asiankelsey@discussions.microsoft.com> wrote in message news:747450D0-DDFC-4BBC-A833-21375EA27879@microsoft.com... > Hi, > > I have been using Windows Mail (The 2006 desktop version) for quite > sometime > now. I have always been able to attach files ...

Print to file: What format?
Hello, When a user checks the "Print to file" radio button in a print dialog, in what format will the file be and how can it be used? Thanks, John To quote an MSDN article: "The Print To File feature can come in handy if the printer on which you ultimately want to print your document isn't attached to your system. For example, you might be sending the final document to a service bureau to be printed on a high-resolution printer. When you use this feature, you can save the file in a special format that contains raw printer data specific to the selected printer. When you s...

covet a file to Word
I have a map drawn in Publisher. How can I get this into a word document. I realy need to make this map available to a party that does not have Publisher. They do have internet. I do have a scanner and could send as a jpeg file but I thought there might be an easier way. Thanks in advance, Ray Do a copy and paste into any paint program and save as any supported file type you choose. -- Hi Ray (rhaubelt@grandecom.net), in the Microsoft� newsgroups you posted: || I have a map drawn in Publisher. How can I get this into a || word document. || || I realy need to make this map availab...