BACKUP DATABASE [Keyhouse] TO  DISK = N'D:\SQLData\Backup\Backup.bak' WITH  INIT ,  NOUNLOAD ,  NAME = N'keyhouse backup',  NOSKIP ,  STATS = 10,  NOFORMAT

=====

USE Keyhouse --Enter the name of the database you want to reindex 
 
DECLARE @TableName varchar(255) 
 
DECLARE TableCursor CURSOR FOR 
SELECT table_name FROM information_schema.tables 
WHERE table_type = 'base table' 
OPEN TableCursor 
FETCH NEXT FROM TableCursor INTO @TableName 
WHILE @@FETCH_STATUS = 0 
BEGIN 
DBCC DBREINDEX(@TableName,' ',90) 
FETCH NEXT FROM TableCursor INTO @TableName 
END 
 
CLOSE TableCursor 
DEALLOCATE TableCursor
 
DBCC DBREINDEX('diary',' ',50)
DBCC DBREINDEX('diarydelegations',' ',50)
DBCC DBREINDEX('diaryAttachments',' ',50)

=====

use keyhouse 
exec sys.sp_updatestats

=====

USE [Keyhouse]
GO
ALTER DATABASE [Keyhouse] SET RECOVERY SIMPLE WITH NO_WAIT
DBCC SHRINKFILE(Keyhouse_Log, 1)
ALTER DATABASE [Keyhouse] SET RECOVERY FULL WITH NO_WAIT
GO