|
|
Browse by Tags
All Tags » transaction log ( RSS)
-
|
You have seen the list of SQL Server 2008 Enterprise Edition: List of Microsoft Knowledge Base Articles (KBA) updated and now there are few additional KBAs that pertains to SQL Server Standard Edition has been updated recently with new and major modifications...
|
-
|
There hasn't been much changes to the KBAs and here is complete list of items/pages that were were recently modified: Source: Knowledge Base Product: Microsoft SQL Server 2008 Enterprise Edition FIX: You receive an incorrect result when you run a...
|
-
|
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...
|
-
|
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...
|
-
|
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...
|
-
|
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...
|
-
|
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...
|
-
|
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...
|
-
|
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...
|
-
|
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,...
|
-
|
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...
|
-
|
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...
|
-
|
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...
|
|
|