on 04-30-2007 4:40 AM
Hi,
My server is ECC 6.0 on Nt 2003 with SQL 2000 server.
in log folder i have one file only. this size is increasing day by day. (up to 120 GB).
how to minimize this size. or i want remove this file ? (how to back up).
Regards,
swathi
Depending on your recovery model, you might be able to simply run this command to manually truncate the log:
BACKUP LOG <database name> WITH TRUNCATE_ONLY
This empties the log file but does not reduce its size. You will then want to use DBCC SHRINKFILE to reduce the size of the individual LDF file(s).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
I do not thnk the Oracle</b> forum is thecorrect one to post a SQL Server question.
Why don´t post your question on the
Probably you will get an answer there.
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
71 | |
26 | |
10 | |
9 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.