Shrink Database (MSSQL SERVER 2000)

You are maintaing the various Database in ur system while the space is also in ur consideration.If u wanna reduce the large space without deleting database, Run the query in ur SQL Query Analyzer


sp_helpdb 'databasename'

backup log DataBaseName with truncate_only

dbcc shrinkfile(databasename_log,10)


Now Check your Harddisk's Space,Really its reduce the space because of Shrinking operation.