can you any body tell me the how to decrease the logfile

Answer Posted / rahul

dbcc shrinkfile ( 'databasename', 'size to be shrinked upto
(in mb)')

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain trigger classes i.e. Instead of and after trigger?

485


What is normalization? What number of normalization shapes are there?

602


What stored procedure can you use to display the current processes?

490


What are the steps to take to improve performance of a poor performing query? : sql server database administration

598


why would you call update statistics? : Sql server database administration

571






If you want to send some data from access database to sql server database. What are different component of ssis will you use?

503


Is mysql the same as sql server?

509


What are the essential components of sql server service broker?

560


What do you understand by sql server agent?

531


Mention the different types of triggers?

545


What is data block and how to define data block size?

602


What is the difference between TRUNCATE and DROP?

627


How do I completely remove sql server instance?

566


what is memory-optimized nonclustered indexes

557


what stored procedure can you use to display the current processes? : Sql server administration

528