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
- 4971 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
How to update multiple rows with one update statement in ms sql server?
Explain tablesample?
What is database mirroring?
What is a Join and explain its types?
Define outer join in sql server joins?
Delete duplicate rows without using rowid.
how can a database be repaired? : Sql server administration
What is shared lock?
How do we synchronize On-Premise SQL server with SQL Azure?
How do I open port 1433?
What is the difference between nvl and nvl2?
What is exporting and importing utility?
Define Unique Key?
where the connection string store in the database
What is a benefit of using an after insert trigger over using a before insert trigger?
