Answer

dbcc

raj chavan

12y

849

dbcc shrinkfile('databasename_log',1)
backup log databasename with Truncate_only
dbcc shrinkfile('databasename_log',1)

dbcc shrinkdatabase('databasename',10)

tell me meaning of every word from above query and use of both the queries

Next Recommended Forum

Is LightSwitch Useless?

DBCC commands in SQL

Leaderboard

View all

Deepak Tewatia

Sharp Talk

-12

Sharp Ai

-22

View all

Yesterday's leader

Deepak Tewatia

C#, Asp.net, DB, F#, AI, MVC

India

18.1k

16.4k

Member of the month

Rinki

Chennai (India)

5.4k

14.8k

Speaker of the month

Shivam Payasi

C#, .NET

Chitrakoot (India)

21.1k

19.7k

Upcoming events

View all

Suggested for you

View all

Allen James

Praveen Moosad

Jemmy Jackson James

Shivam Payasi

Priyanshu Agnihotri

Forum Statistics

Please welcome our newest member Divyansh Gupta.
2,380,744 users have contributed to 122,553 threads and 389,014
In the past 24 hours, we have 29 new threads, 57 new posts, and 0 new users.
In last week, the most popular thread is 'The new portal visibility'.