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 can we use ConnectorJ JDBC Driver with MS SQL?
What happens if an integer is too big for int date type?
What are the new scripting capabilities of ssms? : sql server management studio
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?
How many databases can we create in a single server?
Explain primary key?
What is your recommendation for a query running very slow? : sql server database administration
Which autogrowth database setting is good?
Do you know what are the restrictions that views have to follow?
In which files does sql server actually store data?
Can you explain full-text query in sql server?
in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration
Do you know how to send email from database?
What is transaction server consistency?
Data table as parameter in sql server?