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 |
|
sumwanlah
Starting Member
43 Posts |
 Posted - 2001-04-27 : 00:36:56
|
| I've been like trying for ages to remove unused transaction log space from all my databases.Honestly I made a mistake of letting these database logs grow limitlessly. Now I can't simply shrink it.I've tried DBCC and shrinks (pun intended ;) ), but still nothing works. In most instances, I have several transaction log files that are about 1Gb in size but only 2Mb is utilised! And it does take up that much space on the harddisk!I've read that it's possible to try detaching the database and just re-attaching only the data file. This would allow the SQL server to create a new log file for this database.But I'm running a production server, so stopping short of experimenting with this concept, does anyone else have any solution? |
|
|
|
|
|
Unused Transaction Log Space