-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: AnupPS
Message 6 in Discussion
Hi,
We too have the same problem frequently.
First we use
BACKUP LOG { database_name | @database_name_var }
{
[ WITH
{ NO_LOG | TRUNCATE_ONLY } ]
}
and then the dbcc shrinkfile
DBCC SHRINKFILE
( { file_name | file_id }
{ [ , target_size ]
| [ , { EMPTYFILE | NOTRUNCATE | TRUNCATEONLY } ]
}
)
We have created a procedure and then put it in a job, which takes care
of running these commands regularly.
A good amount of help about these commmands can be fould in
SQL-SERver-books online
See the article about "Truncating the Transaction Log" at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da2_7vaf.asp
Also check this link.
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/logship1.mspx
Please let me know if this helps.
Regards,
Anup Shinde.
On 9/11/05, Ravikumar.V <[EMAIL PROTECTED]> wrote:
>
> New Message on BDOTNET
>
>
> SQL log file (.ldf)
>
>
> Reply
>
> Reply to Sender Recommend Message 4 in Discussion
> From: Ravikumar.V
>
>
> Hi Bilal,
> Thanks for your help. Actually database size is frequently
> increasing. so we cant not do it manually everytime. if you know any
> permanent solution. please let me know.
>
> Regards,
> V.Ravikumar
> View other groups in this category.
>
>
>
> Also on MSN:
> Start Chatting | Listen to Music | House & Home | Try Online Dating | Daily
> Horoscopes
>
>
>
> To stop getting this e-mail, or change how often it arrives, go to your
> E-mail Settings.
>
> Need help? If you've forgotten your password, please go to Passport Member
> Services.
> For other questions or feedback, go to our Contact Us page.
>
> If you do not want to receive future e-mail from this MSN group, or if you
> received this message by mistake, please click the "Remove" link below. On
> the pre-addressed e-mail message that opens, simply click "Send". Your
> e-mail address will be deleted from this group's mailing list.
> Remove my e-mail address from BDOTNET.
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member
Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you
received this message by mistake, please click the "Remove" link below. On the
pre-addressed e-mail message that opens, simply click "Send". Your e-mail
address will be deleted from this group's mailing list.
mailto:[EMAIL PROTECTED]
