can you any body tell me the how to decrease the logfile
Answer Posted / rahul
dbcc shrinkfile ( 'databasename', 'size to be shrinked upto
(in mb)')
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How extra digits are handled with numeric data type literals?
What should be the fill factor for indexes created on tables? : sql server database administration
What is inner join in sql server joins?
which table keeps the locking information? : Sql server administration
What is 3nf normalization form?
List the different normalization forms?
What is difference between clustered and non clustered index?
What are four major operators that can be used to combine conditions on a where clause?
Can we hide the definition of a stored procedure from a use?
How can we check the sql server version?
How to provide login information for a new odbc dsn?
What is scan table/view and seek table/view when its occurs? : sql server database administration
Can I use sql azure as a backup with log shipping or database mirroring?
A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?
What are the advantages of using stored procedures in sql server?