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 and why use sql server?

0 Answers  

Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?

0 Answers  

Does order by actually change the order of the data in the tables or does it just change the output?

0 Answers  

What are sub-queries? Give example? In which case sub-queries are not feasible?

4 Answers   Infosys,

Explain what is the difference between a local and a global temporary table?

0 Answers  

What is truncate table?

0 Answers  

Explain comment on transactions?

0 Answers  

What is dirty read?

0 Answers  

explain databases and sql server databases architecture? : Sql server database administration

0 Answers  

What happens if time-only values are provided as date and time literals?

0 Answers  

Do you know 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?

0 Answers  

Is t sql the same as sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories