There are times when the Log file will not shrink even if the maint
routines are set properly running the following commands in Query
analyzer will force the shrink of the database and log file. Replace
dbName with the Name of the database, Percntage in the second line is
the percent of availa
Hi Cenk Ince,
If your log file is not being used to trace any transaction into database, then you may use backup with truncate using the command backup log and then shrink the log file using dbcc shrink file command.
The following script is to truncate all databases' log file. You can put the
The only way you can get the file to actually shrink the file is to move all
the data pages to the beginning of the file. This is an option on the shrink
database screen. Note the warning about performance being affected if you do
this. This is because the file becomes fragmented. My advice is
Hi,
there are many different ways for shrinking the log-Files. The clean one is
right-click on database, all tasks, shrink database.
This only works if you saved the transaction log before. If there are
several log files you can do it for each file.
The faster - and maybe a little less
Well not that I'm expert but TS came from Citrix(MS bought the
technology from Citrix), so the technology should be the same. I thought
Citrix Metaframe was just an enhanced client/management.
Don
-Original Message-
From: James Flavell [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June
First i want to thank for all replies;
But i couldn't solve problem, when i shrink db, the physical file size
is not getting smaller. How can i get it smaller?
Thanks in advance.
Yahoo! Groups Sponsor
ADVERTISEMENT
Yahoo! Groups Links
To visit your group on the we
Matt,
We have a client with 160 users spread across 2 AOS and they also have
an EMC SAN for SQL. Based on the DB growth your showing and your
expected additional users you should start working with MBS and your VAR
to help you optimize your Hardware config, and also optimize Axapta's
indexe
Absent without leave...(I think..)...sorry not sure why I used that.
probably the hotfix code should have the correct calculation and so you can
probably apply it or just manually change the value in the field I think is
okay but not 100% sure...
-Original Message-
From: Steeve Gilbert
Hello Matt,
I don't know how to quantify the "activeness" of our 45 concurrent users. 45 users is all of our Axapta users split between department like production, IT, Accounting, purchase, customer services, etc... So they don't all capture payment, create credits notes and run reports. Th
Hi Steeve,
So you find axapta to be pretty quick? How active are those 45 (concurrent,
right?) users? For interest sake, how many AOSs have you distributed your
users over (we're clustering two AOSs for our users)?
Matt Benic
Axapta Developer
UTi Sun Couriers Division
-Original Message-
Hi Tobias,
I was excluding the size of the log. Our DATA is 21 Gb. Our transaction log
has 6Gb allocated (to allow for optimisations), of which it is utilising
about 100 Megs.
If it makes any difference, our DB is running on an emc SAN with fibre
connected drives, and 4Gb caching enabled on th
Our database (MS SQL) is now 9.35Gb and the logs are 4Gb. Logs are growing and shrinking but never go over 5Gb. The DB is growing 1Gb a month and on a normal day we have about 45 users. No server overload for us yet.
Steeve...
-Message d'origine-
De : Matt Benic [mailto:[EMAIL PR
How much is data, how much is log? Maybe you should consider shrinking your logfile from time to time?
Hth, Tobias
> -Ursprüngliche Nachricht-
> Von: Matt Benic [mailto:[EMAIL PROTECTED]
> Gesendet: Donnerstag, 1. Juli 2004 14:26
> An: Axapta Dev
> Betreff: [development-axapta] Databas
AWOL?? What? ;-) What's this acronym? Thanks James, I'll check the fixs in SP2 and SP3 for this issue. Do you know how it can be fixed once it's messed up?
Steeve...
-Message d'origine-
De : James Flavell [mailto:[EMAIL PROTECTED]
Envoyé : 30 juin 2004 18:24
À : [EMAIL PROTECTED
Hi all,
The bulk of our installation has been live for about four months, and our DB
has reached a little over 20 Gb. Our monthly growth is about 3-5 Gb a month.
In a busy period such as our month-end we have 50-plus users capturing
payments and credit notes and running reports. We have found t
Hi all,
When I export to PDF File, double byte character is broken in PDF file.
Do you have any solution?
Best regards,
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
Yahoo! Groups Links
To visit your group
Thanks herbert, what about the silent installs?
Matt Benic
Axapta Developer
UTi Sun Couriers Division
-Original Message-
From: Mister L [mailto:[EMAIL PROTECTED]
Sent: 01 July 2004 10:44 AM
To: [EMAIL PROTECTED]
Subject: AW: [development-axapta] Fat clients using web deploym
Hi...
Sorry for interupting, actualy what is the log file function exactly..??
if it is very useful then why do we have to delete it???
and what kind of effect that might be happen if we do the shrinking process
???
Regards,
Yanti
- Original Message -
From: "Myrl Stadnick" <[EMAIL PR
Hi all.. I want to store queries on database... Because user can add new datasources
to standart query and add new ranges. After user must save this values, u can access
this values on the future..
i want to store query history..
Do you have any idea??
Thanks..
Anýl Özay
ERP Technical Con
Hi Matt,
| We currently have all of our clients connecting in three-tier
| thin mode, however we do have some client machines that are
| massively overspec'd and would like to run Axapta in 3-tier
| fat on them. I have three concerns in this case:
| - SQL client licensing: what are the lice
There was a known bug in ax3.0 sp1 (I think there was a hotfix issued and
also guess it should be fixed in SP2) that deliver remaining qty went AWOL
in certain situations...
-Original Message-
From: Steeve Gilbert [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 01, 2004 4:32 AM
To: [EMA
Hi Myrl
You can see a button called "lines" on every journal table form. The
menu item assigned to this lines button is controlled by a class so that
the appropriate menu can be invoked depending on type of journal.
In the case of tutorials journal, change menuitemstrlines method of
tu
If you do a backup of the db and then run ashrink job, it should reduce
the size of the file.
From: Myrl Stadnick [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 30, 2004 4:25 PM
To: [EMAIL PROTECTED]
Subject: RE: [development-axapta] (urgent) how to delet
I take this is MS SQL database. check the propertieis of the db and you
will probably find the 'Restore' is set as FULL change it to SIMPLE and then
backup the database. You should then find the log has been
deleted/truncated I believe (read up the SQL help on this setting should
explain t
Hi All,
We currently have all of our clients connecting in three-tier thin mode,
however we do have some client machines that are massively overspec'd and
would like to run Axapta in 3-tier fat on them. I have three concerns in
this case:
- SQL client licensing: what are the licensing implicat
Can someone just put me on the right path as to the main differences with
just a Terminal Server client and a Cytrix client... I have been told TS
requires higher bandwidth per client but have not found anywhere that
explains when TS is enough and when Citrix should be used etc...
Thanks
--
26 matches
Mail list logo
