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
what are the critical issues you have resloved in your company
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
What are the different types of triggers in SQL SERVER?
What is recompile sql server?
What is use of except clause? How does it differ from not in clause?
What is outer join in sql server joins?
How to insert stored procedure result into temporary table?
When we should use and scope of @@identity?
1 01 101 01010
what are the different types of SSRS reports?
Tell me in brief how sql server enhances scalability of the database system?
How will you know when statistics on a table are obsolete?
What are the common performance issues in sql server?
What is the difference between substr and charindex in the sql server?
How to find the service pack installed? : sql server database administration