can you any body tell me the how to decrease the logfile
- 4 Answers
- 5441 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 is difference between aggregate and analytic function?
What is failover clustering overview?
How does a profiler work?
What is user-defined function?
What is the security principal at the server level that represents your session?
What is the difference between char, varchar and nvarchar?
What is use of except clause? How does it differ from not in clause?
How do I shrink an ldf file?
What is temporary stored procedure?
What protocol does sql server use?
What is recompile sql server?
How many databases Microsoft SQL server provides?
What is triggers and stored procedures?
How many types of database relationship in sql server?
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
