Shrinking SQL Server 2005 log files

There are different ways of doing this, you can try to do this through the SQL Server management studio but never really seems to work…

Best way of doing it that I’ve found is using the following script, this will shrink the log file to 1MB, the number of megabytes can be changed within the script. This script backups the database before it shrinks the file, so you can alway roll back if required.

USE DATABASENAME

GO

BACKUP LOG DATABASENAME TO DISK = ‘C:\DATABASENAME.bak’ WITH TRUNCATE_ONLY

DBCC SHRINKFILE(‘DATABASELOGNAME’, 1)

GO

 

DATABASENAME = the name of the database

DATABASELOGNAME = the logical name of the log file. This can be found if you right click on the database within the management studio, select Properties and then click on the ‘Files’ tab on the left hand navigation.

Youtube and Umbraco

I’ve implemented a solution to directly upload videos to YouTube through Umbraco, you are then able to link to the video within Umbraco and display it on your site.

I was going to write a tutuorial about it, would anyone be interested in a tutorial?

Dropscuttle

The development team have been working on a new search component, named Dropscuttle. This has been built as a standalone control, but we can also integrate it into a cms such as Umbraco.

More information coming soon!!