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 |
|
mary_itohan
Posting Yak Master
191 Posts |
 Posted - 2012-02-26 : 18:43:44
|
| hi guys,I noticed the server space on our server was quickly used up, and checked out db, the largest table was 3million records, and transaction log for the database was 7gb.Is this normal or do i reduce it ?thanksM_____________________Yes O ! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Jayam.cnu
Starting Member
45 Posts |
Posted - 2012-02-27 : 02:54:55
|
| Hi Mary... i think you should provide all these details .. recovery model, how many data files and what is the maximum size of data file.. so that we can decide to reduce size of log file..... |
 |
|
|
|
|
|
Transaction log is 7 gb ???