Shirink file:[Titr]

[ShortText]

USE eoffice
GO
DBCC SHRINKFILE(eoffice, 1) --Duration: 35s MDF Size: 39GB LDF Size: 81GB
DBCC SHRINKFILE(eoffice_log, 1) --Duration: 35s MDF Size: 39GB LDF Size: 1GB

transaction log Backup:[Titr]

[ShortText]

USE eoffice
BACKUP LOG eoffice  TO DISK = 'Nul' --Duration: 3min MDF Size: 40GB LDF Size: 81GB

SQL Server Backup:[Titr]

[ShortText]

declare MyC cursor
    forward_only read_only for
    select name from sys.databases order by name

    declare @dbname nvarchar(100)

    open MyC

    fetch next from MyC into @dbname

    while @@fetch_status=0
        begin
            print @dbname
            if @dbname in ('eoffice')
                begin
                    declare @command nvarchar(4000)
                    set @command='backup database ' + @dbname + ' to disk=''E:\xand\DB\Backup\eoffice_' +
                        convert(varchar(100),getdate(),112 ) + '-' + @dbname + '.bak'' WITH format, COMPRESSION'
                    select @command
                    exec (@command)
                end
            fetch next from MyC into @dbname
        end
    close MyC
    deallocate MyC