Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
AskSQLTeam
Ask SQLTeam Question
0 Posts |
Posted - 2001-12-20 : 09:19:09
|
Harish writes "Presently working on a Finance Project with VB as Front End / SQL as BackEnd.I am using Views,Stored Procedures. till now i've used 10 to 15 S.Procedures, 3-5 Views. Problem is my LDF file has a file size of approx.1.3 GB with 200-250 transaction entries.Can you help me out?" |
|
royv
Constraint Violating Yak Guru
455 Posts |
Posted - 2001-12-20 : 09:24:07
|
There are *many* who have have asked about this. In general, I think, the consensus is if you want to completely remove the log, use sp_detach_db and sp_attach_db. Make sure to backup your database and log file before attempting to do this.*************************Just trying to get things done |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2001-12-20 : 11:48:19
|
If you want to keep your log from growing, there are a couple of things you can do. If you rely on transaction log backups, then you need to backup the log more often. If you don't take log backups, then set 'truncate log on checkpoint' to true (7.0) or recovery model to simple (2000).As for shrinking the file, use dbcc shrinkfile.-Chad |
|
|
|
|
|