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
Write SQL queries on Self Join and Inner Join.
plss anybody specify tha constrian management system in dbms
What are the triggers in sql?
How to concatenate two binary strings together?
Do you know how to store and query spatial data?
How can you know if the row fetched from cursor is still valid in underlying table?
What is the concept of optimization?
Tell me what is difference between clustered and non clustered index?
How to create a new table in a given schema?
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
Explain ms sql server reporting services vs crystal reports?
where can you add custom error messages to sql server? : Sql server administration
Explain what is log shipping?
Which trace flags are enabled in sql server?
If we delete pack Spec what will be the status of pack Body ?