Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Browse by Tags · View All
SQL server 7
Database 6
Tips 5
Tricks 5
#SQLServer 3
Backup 2
MSSQL 1
'E0' 1
isnumeric 1
Issues 1

Archive · View All
December 2011 4
March 2012 2
January 2012 1

Raghunath Bhandari's Blog

MSSQL transaction log

Dec 13 2011 11:05AM by Raghunath Bhandari   

It is good if you backed up the LOG file also when we take the full backup of the database.

If you are not backed up the .LDF file or LOG  then it will become huge and occupy the large number of space, if you need to clean up the transaction log. Follow the following steps and clean your LOG size.

1)  first take log backup


BACKUP LOG MYDB TO DISK='d:\TEMP.bak' with init

2) Shrink your Database.



USE MYDB GO
DBCC SHRINKFILE ('MYDB _log', EMPTYFILE);
GO

From GUI mode: Rclick  DB ==> Task ==> Shirinks ==> Database ==> specify size and press OK


3) Now see your log and file size.



SELECT name AS [FName] , file_id, physical_name AS [Phy.Name],
size/128 AS [SizeInMB],
size/128.0 - CAST(FILEPROPERTY(name, 'Used') AS int)/128.0
AS [Available Space In MB]
FROM sys.database_files;

MSDN:
You can reduce the default size of an empty file by using DBCC SHRINKFILE target_size. For example, if you create a 5-MB file and then shrink the file to 3 MB while the file is still empty, the default file size is set to 3 MB. This applies only to empty files that have never contained data.

Tags: Database, SQL server, Backup, Clear Log file, Tricks, How to clear Transactional log, LOG Backup, .LDF file backup, MSSQL Backup, Tips,


Raghunath Bhandari
183 · 1% · 253
1
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect



Submit

Your Comment


Sign Up or Login to post a comment.

"MSSQL transaction log" rated 5 out of 5 by 1 readers
MSSQL transaction log , 5.0 out of 5 based on 1 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]