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...

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

Answer Posted / prasadhari_m@yahoo.com

take a backup using this command
backup log dbname with no_log

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is sql server difficult to learn?

964


How to create prepared statements using odbc_prepare()?

1099


What do you understand by recursive stored procedure?

982


whats the maximum size of view state??

2246


Why can there be only one clustered index and not more than one?

1040


OPTIMIZATION OF SP,CURSOR,TRIGGERS

2849


How is foreign key related to primary key?

1010


Tell about MOM Tool(Microsoft Operator Manager)?

1957


Why should one not prefix user stored procedures with ‘sp_’?

1095


Does table partitioning improve performance?

1012


Explain the difference between functions and stored procedures in sql server?

1018


Difference between 2NF &3NF ?

1127


Can select statements be used on views in ms sql server?

1104


What is user defined datatypes and when you should go for them?

1065


how can u get last observation in an unknown dataset ?

2483