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
- 4881 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 rs.exe utility?
What is difference between aggregate and analytic function?
What is a recursive stored procedure in sql server?
Define master database?
How do you delete a data source?
How to use subqueries in the from clause in ms sql server?
How to check status of stored procedure in sql server?
When should you use an instead of trigger?
What is the use of sign function?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
How to rename an existing table with the "sp_rename" stored procedure in ms sql server?
how would you store your query in an SSRS report or a Database server?
What is the difference between function and stored procedure in sql server?
How do I install only the client tools of sql server 2000?
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
