Thursday 18 August 2016

How to truncate transaction log file of a database in SQL Server

Cleaning templog  (tempdb transaction log file):
 
dbcc shrinkfile ('templog',0)

To look for  .mdf and .ldf  files and their locations. Use below statement:


select  *  from sys.database_files

1 comment:


  1. Actually I'm having bad luck with you and with the rolex replica sale. All the problems already mentioned have to add that yesterday I made a week watch as this morning was already replica watches sale. That I have to do? Fanciest more money and go to change the battery with only one week of use? This counting the cartier replica uk but it will make me a refund because it is not normal. I think for the problems that are giving me and so you can speak well of you, should give me the fake rolex sale or pay me this money. Please give me a solution. I ordered and paid for a watch, I was then advised that the replica watches sale is out of stock, I selected an alternate, was told there is too much of a price difference. I was then advised that my money would be rolex replica. I have made numerous attempts today to get any further assistance, my emails now go unanswered. I would like to know the status. I am a very reasonable person, I was not replica watches sale, I just want answers. I will give you an opportunity to resolve this matter between us, as a last resort, I will file an IC3 form with the FBI, they cover computer and internet rolex replica sale. If this is unacceptable, then continue with the refund process, I will purchase my replica watches sale from another vendor, they are a dime a dozen on the web.

    ReplyDelete

Tweets by @sriramperumalla