Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5067 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 bcnf normalization form?
Is the primary key column of a table an index in ms sql server?
What is the difference between implicit and explicit transaction?
How to create prepared statements using odbc_prepare()?
what's new in sql server 2016?
How to throw custom exception in Stored Procedure?
What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?
What is similarity and difference between truncate and delete in sql?
What are the ways available in sql server to execute sql statements?
Give me a SQL Query to find out the second largest company?
What is service broker?
How to update values in a table with update statements in ms sql server?
What are sql servers used for?
Explain ms sql server reporting services vs crystal reports?
What are tables in sql server?
