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 |
|
vb_bv
Starting Member
24 Posts |
 Posted - 2002-03-17 : 22:07:49
|
| Hi, All, I had a question about truncate transaction log from SQL server 6.5, Ordinary, my transaction log file size is around 1.2GB, and after I ran the "truncate log" from the Enterprise Manager, the log file size is reduced to 1GB, but this is not satisfied to reduced 2MB size only, does it any method that I can truncate much more.And I've been told what the "truncate log" actually done is:"To truncate all the "comitted transaction" from the SQL server", so if my log file size is around 1.2GB large, does it mean my server store many info. about unsuccessful transaction, how can I delete this record as well?thanks all you guys help!best regards, |
|
|
Nazim
A custom title
1408 Posts |
|
|
vb_bv
Starting Member
24 Posts |
Posted - 2002-03-17 : 23:47:41
|
| thanks, nazim, but I couldn't find the "detach database" from theSQL server 6.5 or 7.0, but I found this function from SQL server 2000,so what should I suppose to do if I am using SQL server 6.5 or 7.0?many thanks. |
 |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-03-18 : 00:13:16
|
| check sp_attach_db and sp_detach_db in BOL.-------------------------------------------------------------- |
|
|
|
vb_bv
Starting Member
24 Posts |
Posted - 2002-03-18 : 01:36:38
|
| yes, it works, thanks, nazim! |
|
|
|
|
|
|
|
|
about truncate transcation.