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
- 1 Answers
- 4496 Views
- Cognizant, I also Faced
- E-Mail Answers
Answer Posted / purushothaman
It will remove the uncommitted data
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is star, snowflake and star flake schema? : sql server analysis services, ssas
What is a partition key?
Where is localdb stored?
What is entity data services?
What is the latest version of microsoft sql server?
How to restore performance issues and how to check?
What are the system database in sql server 2005?
Tell me the phases a transaction has to undergo?
How many types of schemas are there?
what is normalization? Explain different levels of normalization? : Sql server database administration
What is advantage data architect?
How to create a local temporary stored procedure?
What is explicit cursors?
What is merge replication?
What are data regions?
