-
Transactional Log Problem
Hi,
I have got a database (SQLSRV2000 Enterprise), and it has got one transactional log file.
if I set the Transactioal file size to 1500MB and auto growth on (no limit) over night the trans. log expands up to 2300MB
I have tried to set the Initial value the trans. file to 2500MB but next day the log file will be 1500 again!! in the database options the auto shink is on.
My understanding was that the auto shrink option, shrinks transactional log and also data(.mdf) file.
Is there any way to disable the shrinking option only on the transaction log not the data files(.mdf)
Thanks
S
-
The right way to do this is to
a. uncheck remove autoshrink option
b. Set your database to FULL recovery mode
c. set min size + autogrowth option on data and log files.
d. Take frequent transaction log backup.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|