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

How to use subqueries with the exists operators in ms sql server?

798


What is extent? Types of extents?

791


List out the differences between global and local temp tables in sql server?

753


Explain magic tables in sql server?

726


Can truncate be rolled back?

703






What is difference between table aliases and column aliases? Do they affect performance?

714


Do you know what is blocking?

727


What security features are available for stored procedure?

769


What is always encrypted?

695


What is relationship? What number of sorts of relationship are there?

827


What does REVERT do in SQL Server 2005?

711


What is default port number for sql server 2000?

755


What are synonyms?

716


What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?

131


How can you list all the columns in a database?

719