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
Explain trigger classes i.e. Instead of and after trigger?
What is normalization? What number of normalization shapes are there?
What stored procedure can you use to display the current processes?
What are the steps to take to improve performance of a poor performing query? : sql server database administration
why would you call update statistics? : Sql server database administration
If you want to send some data from access database to sql server database. What are different component of ssis will you use?
Is mysql the same as sql server?
What are the essential components of sql server service broker?
What do you understand by sql server agent?
Mention the different types of triggers?
What is data block and how to define data block size?
What is the difference between TRUNCATE and DROP?
How do I completely remove sql server instance?
what is memory-optimized nonclustered indexes
what stored procedure can you use to display the current processes? : Sql server administration