dbcc shrinkfile ( 'databasename', 'size to be shrinked upto

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

Question Posted / rahul

Answer Posted / rahul

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

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Describe in brief sql server monitoring ways.

1004

How do I manually uninstall an instance of sql server 2016?

965

What is ddl command?

928

What type of locking occurs during the snapshot generation? : sql server replication

1264

Can a table be created inside a trigger?

924

What are the advantages of policy management?

944

What is extent? Types of extents?

1089

Describe and explain about SQL native client?

1041

what is the system function to get current user's user id? : Sql server database administration

951

Do you know what is sql injection?

939

Explain the etl (extraction, transformation, and loading)?

940

What is the significance of null value and why should we avoid permitting null values?

919

What is the use of group by clause?

902

Explain the Ways to improve the performance of a sql azure database?

What is an execution plan? When would you use it?

921