Interested to Buy Any Domain ? << Click Here >> for more details...
can you any body tell me the how to decrease the logfile
- 4 Answers
- 6138 Views
- I also Faced
- E-Mail Answers
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 can you set the threshold at which sql server will generate keysets asynchronously?
How do I find the size of a sql server database?
What is dbcc? Give few examples.
What is cursors? And what are the different types of cursor?
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
What are Row versions of DataRow?
What are the advantages of using third-party tools?
Why are views required in the sql server or in any other database?
What is an execution plan? When would you use it?
What are the different types of Indexes available in SQL Server?
What are the different types of lock modes in sql server 2000?
What are trace flags?
What is the use of custom fields in report?
What is difference between equi join and natural join?
Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?
