SQL7 og reducering af Transaction-log/fysisk

Idé :
Hvad med at tilføje et nyt mindre stykke diskplads og så fjerne det store stykke fra loggen bagefter?
(Under properties på databasen, fanen Transaction Log)

Et lille udtræk:

1. Detach db
ie. : EXEC sp_detach_db \'clientzone\', \'true\'
This will detach the database, if an error \'in use\' occurs, stop and start mssqlserver and run again
True will update statistics on all tables.
2. Delete the log file
physically delete the ldf file

3. Attach DB
EXEC sp_attach_db @dbname = N\'clientzone\',
@filename1 = N\'C:\\MSSQL7\\Data\\clientzone_Data.MDF\'
it will then make a new log file of minimun size.

This could also be used to attach a db to another server.
NB this method only works for db\'s with one log file. Otherwise check
Q256650 (for SQL 7.0) and article # Q272318 (for SQL 2000) in Microsoft Knowledge Base.

Vil dette spørgsmål blive lukket snart?