can you any body tell me the how to decrease the logfile
- 4 Answers
- 5108 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 do you understand by mirroring?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
What are different types of constraints?
When is the use of update_statistics command?
what is a traditional network library for sql servers? : Sql server database administration
What are locks in sql?
Do you know what are acid properties of transaction?
What is the difference between a stored procedure and a user defined function?
What is the temp table?
Explain few examples of RDBMS?
How we create SQL Server 2005 Reporting Services ? Give me Sample
Can you tell me some of the common replication dmv's and their use? : sql server replication
How to enter date and time literals in ms sql server?
How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?
