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
How to use subqueries with the exists operators in ms sql server?
What is extent? Types of extents?
List out the differences between global and local temp tables in sql server?
Explain magic tables in sql server?
Can truncate be rolled back?
What is difference between table aliases and column aliases? Do they affect performance?
Do you know what is blocking?
What security features are available for stored procedure?
What is always encrypted?
What is relationship? What number of sorts of relationship are there?
What does REVERT do in SQL Server 2005?
What is default port number for sql server 2000?
What are synonyms?
What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?
How can you list all the columns in a database?