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

What is amo? : sql server analysis services, ssas

664


How to add more data to the testing table in ms sql server?

548


Explain full-text query in sql server?

533


You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?

241


List out a number of the wants to setup a SQL Server failover cluster?

579






What is the primary use of the model database?

619


How to loop through returning rows?

574


How to create a user name in a database?

584


What are the restraints imposed on the table design by a merge replication?

564


What are click through reports?

99


Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

517


How to sort the query output with order by clauses in ms sql server?

630


What is SubQuery in SQL Server 2008

547


What is raid? : SQL Server Architecture

589


How can a user-defined datatype be created?

538