Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / prasadhari_m@yahoo.com

Answers were Sorted based on User's Feedback



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

Answer / vani

The log files must be backed up, so that the inactive log
records are truncated after every checkpoint thus freeing
up the logspace to be reused.

Schrink your database (Database-All task-Schrink database)
leave 10% free and the size of the log will schrink

Is This Answer Correct ?    1 Yes 0 No

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

Answer / prasadhari_m@yahoo.com

take a backup using this command
backup log dbname with no_log

Is This Answer Correct ?    1 Yes 0 No

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

Answer / 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

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

Answer / rahul

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

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is multi-statement table-value user-defined function?

0 Answers  

how to insert the values in 5 table at a time Using any single statement ?

6 Answers   Infosys, Value Labs,

What is database replication?

0 Answers  

What does the automatic recovery do?

1 Answers  

Which tcl commands are available on the sql server?

0 Answers  

How secure is sql server database?

0 Answers  

In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

0 Answers  

Why do we use trigger?

0 Answers  

What are different types of views?

0 Answers  

What does it mean to invest in the index?

0 Answers  

difference between sql server2000 and sql server2005

1 Answers   KPMG,

Can sql server 2016 run on windows 7?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories