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

How to apply cascading referential integrity in place of triggers?

0 Answers  

Explain Geography datatype in SQL Server

0 Answers   Infosys,

what is the out put of below queries? a. select * from Emp where null = null; b. select * from Emp where 1=1;

13 Answers   Patni,

What is the difference between ‘having’ clause and a ‘where’ clause?

0 Answers  

What is the maximum size of column in sql server?

0 Answers  

Is SET a SQL Keyword?

4 Answers   BitWise,

What are the properties of the transactions?

0 Answers  

What are the advantages of using stored procedures? Please don't simply say compilation time will be saved as they are already complied. Please specify some other advantages.

3 Answers   247Customer,

How do I view views in sql server?

0 Answers  

What is data source view or dsv? : sql server analysis services, ssas

0 Answers  

What is the purpose of using COLLATE in a query?

1 Answers  

Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories