When we are using this query to shrink the log file,what
exactly it will execute internally? Do we lose any data
when we run this script? which data it will truncate in the
log file and where it is saved. Please let me know...
USE DatabaseName
GO
DBCC SHRINKFILE(<TransactionLogName>, 1)
BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY
DBCC SHRINKFILE(<TransactionLogName>, 1)
GO
Answer Posted / purushothaman
It will remove the uncommitted data
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What are data regions?
What is intellisense?
What is clustered vs nonclustered index?
What is the server name for sql management studio?
What are the benefits and tasks of object explorer? : sql server management studio
Can you explain what is sql server english query?
Is candidate a key?
Explain the advantages of merge replication?
Is the primary key column of a table an index in ms sql server?
What are click through reports?
How does stuff differ from the replace function?
What are distinctive joins find as a part of sql?
What is normalization and its types?
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration
What the different components of Replication and what is their use?