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
- 4989 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 are the Prerequisites for Replication?
What is the difference between count () and rowcount ()?
What are different types of raid levels?
Define tool Manage Statistics in SQL Server 2000 query ?
what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
What is the difference between commit and rollback?
What is dirty read?
What is indexing a document?
Explain the different index configurations a table can have?
How to create a simple user defined function in ms sql server?
What is data block and how to define data block size?
Explain the use of keyword with encryption. Create a store procedure with encryption?
Explain the commands in sql server?
What is attribute? : sql server analysis services, ssas
What is the recovery model?
