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
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
What is etl - extraction, transformation, and loading?
What is precedence constraint?
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
What is model database? : SQL Server Architecture
Explain datetime2 data type in sal server 2008?
What is the template in sql?
How many ways to create table-valued functions?
What does dml stand for?
Can coalesce return null?
What are the different types of indexes?
What do you understand by the denormalisation?
How to create an inline table-valued function?
How to connect Azure federated root database and apply federation in entity framework?
How to get @@error and @@rowcount at the same time?