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-08-23 : 19:56:04
|
| Nata writes "Hello,I have a few databases on the server and some of them has a huge Trunsaction_log fileI used methods which had been offered by the SQL-team : ... use master backup log transform with truncate_only ... use transform /*execute 10 trunsactions*/ ... use master dbcc shrinkdatabase (transform) print 'Shrunk Database' backup log transform with truncate_only print 'Truncated log' but it works only for some databases and doesn't for another. I can't use sp_detach_db because it is live web site and I can't stop activity on it. I tried all traditional methods ( shrinkdatabase and shrinkfile) and they also doesn't work. Please, help.Nataly." |
|
|
|
|
|
Trunsaction log