Interested to Buy Any Domain ? << Click Here >> for more details...
can you any body tell me the how to decrease the logfile
- 4 Answers
- 6390 Views
- I also Faced
- E-Mail Answers
Answer Posted / lekhrajdeshmukh
We have to decrease the size of a log file by shrinking the
large file.
Syntex:-
DBCC dbname
go
DBCC shrinkfile(filename,sizevalue)
go.
for eg I want to shrink the filename data of databse userdb
to 7 mb.
dbcc userdb
dbcc shrinkfile(data,7)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the purpose of Normalisation?
explain what is raid and what are different types of raid configurations? : Sql server database administration
What language is sql server written in?
How to use group functions in the select clause in ms sql server?
What is sql azure database?
What is an example of a foreign key?
What are the different normalization forms?
Which command is used for user defined error messages?
What is the difference between a fill factor of 100 and 0?
What are sql servers used for?
Does sql server 2000 clustering support load balancing?
what is normalization? : Sql server database administration
What do you mean by a dependent functionality in a build?
What is Federation Root Database?
What are the approximate numeric data types?
