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 declare and use cursor variables?

0 Answers  

What are the difference between primary keys and foreign keys?

0 Answers  

What types of Joins are possible with Sql Server?

0 Answers   NA,

How to view existing indexes on an given table using sp_help?

0 Answers  

Explain about remote stored procedure?

0 Answers  

After removing a table from database, what other related objects have to be dropped explicitly?

0 Answers  

What is the difference between locking and multi-versioning?

0 Answers  

What is the difference between lock, block and deadlock? : sql server database administration

0 Answers  

What is normalization in Database ?

4 Answers  

What is the difference between ddl,dml and dcl commands?

0 Answers   BirlaSoft, Verifone,

When is update_statistics command used?

0 Answers  

Can we create clustered index on non primary key column

20 Answers   ABC, CTS,

For more SQL Server Interview Questions Click Here
Categories