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 |
|
mbevon
Starting Member
41 Posts |
 Posted - 2002-08-12 : 10:01:47
|
| HIiiWhat should i do ?I trying to reduce the size of the transaction log, the log was 3gb, so i did a fullback up the database, then shrink the files, i then reduce the Tlog to 500 megs, it filled in two days.I'll only use full back up, could i remove the TLog or how could i solve the above/thanksMarlon |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-08-12 : 10:08:56
|
| Marlon, in order to properly manage Log size, you must first understand how the Transaction Log works. If you read the materials available in Books Online about Transaction Logs, an answer will become clear for you situation.The last thing you want to do is jeopardize the value of your backup plan by blindly truncating and shrinking files without knowing exactly what you are doing.Jay White{0} |
 |
|
|
|
|
|
Transaction Log