Browse by Tags

All Tags » transaction log (RSS)
SQL Server - Kill a KILLED/ROLLBACK status process without restarting Server or SQL services?
Published 6 May 8 3:2 AM | SSQA.net
This may be the typical situation within your database environment where the you might have killed a SPID (Process) that has been running for long time, without knowing the ROLLBACK operations for such processes. Say if you are executing a stored procedure...
Filed under: , , , , , , , , ,
SQL Server databases - checkpoint, cache and I/O request - what you need to know?
Published 22 April 8 1:51 PM | SSQA.net
Have you ever wondered about flushing databases? Well not quite possible to flush it straight away and not a best practice too on the live server, so what it is about and you need to know about transactions state when they occur. Say when the changes...
Filed under: , , , , , , , , , , ,
What is the significance of .TUF file in Log shipping?
Published 12 November 7 12:55 PM | SSQA.net
One of the user has been confused to see lot of .TUF file within their server where the log shipping is enabled. Basically this .tuf file is the T ransaction U ndo F ile, which is created when performing log shipping to a server in Standby mode. So if...
Filed under: , , , , , ,
More on Database Mirroring performance and index maintenance
Published 18 October 7 7:37 PM | SSQA.net
There's been some discussion over on the SQL Server Central forums about database mirroring performance, and one question in particular on how to do index rebuilds on mirrored VLDBs. Remember that in database mirroring, the database has to be in the...
Filed under: , ,
SQL Server 2008 - enhanced feature in database mirroing "log compression"
Published 15 October 7 4:11 AM | SSQA.net
Database Mirroring - new feature from SQL Server 2005 within High Availability ranch, a software based solution for database availability. Very important for the DBAs to keep up the database recovery model to FULL at all the times to achieve the High...
Filed under: , , , , , , ,
WRITELOG wait types - what your SQL Server is saying?
Published 12 October 7 7:41 AM | SSQA.net
Whenever the SQL Server is struggling to write the transactions to the disk, you would observe WRITELOG wait type within SP_WHO2 results. So when you observer such wait types then you should be worried on the disks performance, either you plan for shrinking...
Filed under: , , , , , ,
SQL Server 2008: Performance boost for Database Mirroring
Published 10 October 7 7:6 PM | SSQA.net
As I mentioned in a previous post, one of the new features for database mirroring in SQL Server 2008 is log stream compression. There's a good explanation of what this is (along with some example workloads and performance graphs) on the SQL Customer...
Filed under: , , , , ,
How to read Database transaction log in SQL Server?
Published 27 September 7 7:13 PM | SSQA.net
Another frequently asked questions in the forums and newsgroups, I have seen similar ones recently. I believe most of the newbie users ask this question and even more as interview based questions. So here is the catch in order to accomplish the task,...
Filed under: , , , , , , , , , ,
FIX: Error message when you restore a transaction-log backup that is generated in SQL Server 2000 SP4 to an instance of SQL Server 2005: "Msg 3456, Level 16, State 1, Line 1. Could not redo log record"
Published 12 September 7 12:28 PM | SSQA.net
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications FIX: Error message when you restore a transaction-log backup that is generated...
Filed under: , , , , , ,
Multiple transaction log backups or Single transaction log backup file, which is better?
Published 27 August 7 4:51 AM | SSQA.net
Say which is better, having multiple transaction log backups files or single transaction log backup file during a recovery point of time. In my experience both of them doesn't make any difference and if you are performing further backup to tape then...
Filed under: , , , , , ,
Changing database recovery models: FULL to BULK-LOGGED and vice-versa
Published 14 August 7 4:38 AM | SSQA.net
Since SQL Server version 2000 better enhancement of three types of recovery models: simple, full and bulk-logged are fetching long-run support for all kinds of database activies. As you know such recovery models offer varying levels of recovery for restoring...
Filed under: , , , , , ,
Transaction Log Guidelines
Published 19 June 7 4:9 AM | SSQA.net
I always see many posts in the forums asking about transaction log backups and their importance. For the point in time recovery they are must in order to provide the data upto date or atleast that are committed. Yet I have seen many articles out there...
Filed under: , , ,
SQL Server 2005 unable to shrink the transaction log, help? (peculiar issue)
Published 15 June 7 5:19 PM | SSQA.net
On one of the archive database (using SQL 2005) we have a monthly task to shrink the transaction log during every 1st week of the month, this is required due to clear up the space on one of the drives where the additional transaction log file located...
Filed under: , , , , , ,
Database consistency checks and transaction log is filing up, help?
Published 9 May 7 6:40 AM | SqlServer-QA.net (SSQA)
Yet anothe forums related question I would like to blog, as I have seen in my experience on newsgroups. There will be always a question asking about why Transaction log is filling up and blocking is ocurred when a DBREINDEX & CHECKDB processes are...
Filed under: , , , , , , ,