Sql Server 2008, disk space

Found these commands useful, when dealing with Sql Server 2008 disk space allocation and log shrinking; in sql 2008 as you probably know you cannot use any more the command BACKUP LOG databasename WITH TRUNCATE ONLY as shown for example here: to obtain the same result you can do the following:

alter database [database_name] set recovery simple        
go

checkpoint        
go

alter database [database_name] set recovery full        
go

backup database [database_name] to disk = 'd:\temp\filename.bak' with init        
go

dbcc shrinkfile (N'DATABASE_NAME_log' , 1)        
go

To monitor disk space allocated, check for the usage of

EXEC sp_spaceused @updateusage = N'TRUE';

The following procedure uses the sp_spaceused procedure to list each table’s space:

CREATE PROCEDURE GetAllTableSizes      
AS       
-- Lists spaced used data for ALL user tables in the database       
DECLARE @TableName VARCHAR(100)    --For storing values in the cursor       
--Cursor to get the name of all user tables from the sysobjects listing       
DECLARE tableCursor CURSOR       
FOR       
    select [name]       
    from dbo.sysobjects       
    where  OBJECTPROPERTY(id, N'IsUserTable') = 1       
FOR READ ONLY

--A procedure level temp table to store the results      
CREATE TABLE #TempTable       
(       
    tableName varchar(100),       
    numberofRows varchar(100),       
    reservedSize varchar(50),       
    dataSize varchar(50),       
    indexSize varchar(50),       
    unusedSize varchar(50)       
)

--Open the cursor      
OPEN tableCursor

--Get the first table name from the cursor      
FETCH NEXT FROM tableCursor INTO @TableName

--Loop until the cursor was not able to fetch      
WHILE (@@Fetch_Status >= 0)       
BEGIN       
    --Dump the results of the sp_spaceused query to the temp table       
    INSERT  #TempTable       
        EXEC sp_spaceused @TableName

    --Get the next table name      
    FETCH NEXT FROM tableCursor INTO @TableName       
END

--Get rid of the cursor      
CLOSE tableCursor       
DEALLOCATE tableCursor

--Select all records so we can use the reults      
SELECT *       
FROM #TempTable

--Final cleanup!      
DROP TABLE #TempTable

GO