Where results make sense

About us   |   Why use us?   |   Reviews   |   PR   |   Contact us

Topic: Transaction log

    Note: these results are not from the primary (high quality) database.

Ads by Google

In the News (Tue 8 Dec 09)

Northern Trust

Marvin Harrison

Peter Chernin

Gary Locke

Match Play

Penelope Cruz

Mickey Rourke

AR Rahman

Danny Boyle

Hugh Jackman

SQL Server 2000 Administrator's Pocket Consultant: Database Backup and Recovery Transaction logs are always applied in sequence—with the completion time of the last complete or differential backup marking the beginning of a transaction log sequence. Transaction log backups Transaction logs are serial records of all database modifications and are used during recovery operations to commit completed transactions and to roll back uncompleted transactions. If any changes were made to the files or filegroups, you must also restore all transaction log backups that were created after the files or filegroups were backed up. www.microsoft.com /technet/prodtechnol/sql/2000/books/c11ppcsq.mspx

SQL BLOG WITH LOG This rule guarantees the transaction log can be read and reapplied in SQL Server when the server is turned on after an abrupt shut down during which the transactions written into the data cache are not yet flushed to the data files. Transaction logging is primarily sequential write I/O. Separating transaction logging activity from other nonsequential disk I/O activity can result in I/O performance benefits. For SQL Servers with busy databases, transaction log files should be physically separated from each other. vsql.blogspot.com /2004/03/introduction-good-application.html

Automated script to restore database and transaction logs This is achieved with two separate SQL Servers which are independent of one another, but the transactions are applied in the same manner based on the sequential nature of the database transaction log. Restoring full database and transaction log backups, as you have mentioned, quickly turns into a log shipping solution supporting an overall high availability solution. Under this scenario the database recovery model is set to 'Full' to capture all of the database transactions. expertanswercenter.techtarget.com /eac/knowledgebaseAnswer/0,295199,sid63_gci980071,00.html   (595 words)

Transaction Manager All the transactions on system files are logged onto an XM system log file on the master volume of each volume set, just as all the transactions on user files (such as IMAGE/SQL and KSAM files) are logged onto an XM user log file on the master volume. This copying forward is done on such slow transactions for a certain number of times (about 100 times, as of now), and then, if they are not over even then, it would issue SA 2200, concluding that there is something that can put the system in jeopardy. Typical long-running system transactions are those that involve insertion of a file into a group/directory at the beginning, initializing file contents at creation time, and others. docs.hp.com /en/30216-90269/ch10s08.html   (595 words)

BMC Software The transaction log data is accessed in-place — without copying the information into a relational database for processing. The DBA now can see everything that occurred in that transaction by querying the bmclogm.all_records table, which is used to display the contents of every record in the transaction log. By using SQL to access the transaction data, the wealth of information found in those log files can be the key to solving critical business problems. www.bmc.com /technews/981/981tn3.html   (595 words)

Embedded database gains transaction logging Database read performance is unaffected by transaction logging and, while developers have control over the degree of the logging’s impact on database writes, write performance far exceeds traditional disk-based databases in all cases. Version 2.3, expands eXtremeDB's options for persistence with transaction logging, a process in which changes made to a database by transactions are recorded to a log as they occur, according to McObject. The principal new feature in this release of eXtremeDB is an option to write database changes into a transaction log on persistent media, thereby combining the performance and efficiency benefits of an in-memory database with the persistence of a conventional disk-based database, the company says. www.windowsfordevices.com /news/NS8411078443.html   (542 words)

SQL Server Log Shipping Transaction log backups are applied to the database on the standby server in the order that they were taken on the primary server. Copy all transaction log backups to the standby server and apply them in the same order they were taken on the primary server. Transaction log backups are placed on a shared drive; standby server's SQL Server Agent account must have access to this shared drive. www.informit.com /articles/article.asp?p=331402   (648 words)

SQUID Frequently Asked Questions As a kind of transaction log it is ususally used for debugging purposes. Please note that the entries are logged after the reply finished being sent, not during the lifetime of the transaction. The store.log file covers the objects currently kept on disk or removed ones. www.squid-cache.org /Doc/FAQ/FAQ_long.html   (648 words)

McObject — Precision Data Management: The eXtremeDB Main Memory Embedded Database for Smart Devices For example, transaction logging may be turned on or off at runtime and, when turned on, logging may be set to different levels of transaction durability, allowing system designers to make intelligent trade offs between performance and risk for unrecoverable transactions. A disk-based database, however, will perform many writes per transaction (data pages, index pages, transaction log, etc) and the larger the transaction and the more indexes that are modified, the more writes that are necessary. Transaction logging does not alter the all in-memory architecture of eXtremeDB which retains a performance advantage over disk-based databases. www.mcobject.com /logging.shtml   (648 words)

McObject — Precision Data Management: The eXtremeDB Main Memory Embedded Database for Smart Devices For example, transaction logging may be turned on or off at runtime and, when turned on, logging may be set to different levels of transaction durability, allowing system designers to make intelligent trade offs between performance and risk for unrecoverable transactions. A disk-based database, however, will perform many writes per transaction (data pages, index pages, transaction log, etc) and the larger the transaction and the more indexes that are modified, the more writes that are necessary. Logging is performed through periodic checkpoints, where the image of the database is saved to persistent storage, and all intermediate changes to the database are written to the log files. www.mcobject.com /logging.shtml   (423 words)

The Cornerstone Of Crash Recovery Then I'll show you how to use the information stored in a database's transaction log files to return a database to a consistent and usable state after a system crash or program failure. In a future column, I'll show you how to use transaction log files to replay operations to return the database to the exact state it was in at a given point in time. Transactions are initiated the first time an SQL statement executes after a connection to a database is established or immediately after an existing transaction is terminated. www.db2mag.com /shared/printableArticle.jhtml?articleID=59301135   (1383 words)

LOG-NET: Training Upload orders from an ERP system, add international details and then transmit to vendors and logistics service providers. This transaction records the departure of shipments from a vendor, supplier or factory location where the ownership of the goods has not transferred to the cargo principle or consignee. This transaction records the delivery of merchandise at an origin prior to the transfer of ownership to the cargo principle or consignee. www.log-net.com /htm/Support/LN_ecommercemodules.htm   (551 words)

iPlanet Trustbase Transaction Manager 3.0.1 Beta Configuration and Installation: Chapter 5 Logs There is also a raw log that provides detail of all message transactions that take place. The Error log contains entries of any runtime problems both from the iPlanet Trustbase Transaction Manager framework and the Identrus specific components. iPlanet Trustbase Transaction Manager defines an error as a severity, the class of object defining the error, and a programmer defined message. docs.sun.com /source/816-6667-10/ittm30cf.htm   (551 words)

AdminLife : tracking database transaction on microsoft.public.sqlserver.server just be aware that it won't track SELECTs as those aren't recorded in the transaction log. That may be true for their log explorer product but according to the I think the Lumigent Entegra product will do this www.adminlife.com /247reference/msgs/12/62065.aspx   (144 words)

Transaction Management With Sybase - Taking Control Now Sybase could finally record the old transaction as complete; now it was no longer the oldest incomplete transaction in the log, and now the dump utility could remove the other records. Transaction: A program-defined logical unit of work where either all of it must get done correctly or none of it must get done at all. Transaction Management: A means to maximize concurrency and ensure consistency by using transactions to organize and control database activity. www.bcarter.com /syb1_d.htm   (144 words)

Transaction Logging Concepts Transactions can be rolled back explicitly at the request of the application or the user, or automatically by the database manager when an error occurs and the application is no longer able to communicate with the database. To recover the database, the roll-forward process combines a backup copy of the database with the records in the after-image log to redo all the changes that were made since the backup was created. Transactions are an error handling mechanism and a program structuring mechanism. www.peg.com /techpapers/monographs/logging/logging.html   (5515 words)

CREATE DATABASE (Transact-SQL Reference (SQL Server)) The size of the transaction log is the larger of these values:.5 MB or 25 percent of the sum of the sizes of all the data files for the database. If LOG ON is not specified, a single log file is automatically created with a system-generated name and a size that is the larger of these values:.5 MB or 25 percent of the sum of the sizes of all the data files for the database. LOG ON Specifies that the disk files used to store the database log (log files) are explicitly defined. msdn.microsoft.com /library/en-us/tsqlref/ts_create_1up1.asp?frame=true   (2725 words)

How to Perform Microsoft SQL Server Database Log Shipping But if the transaction logs are on the same drive array as the database files, and the drive array fails, then you have lost any data entered into the system since the last log file was shipped to the standby server. In order for the database user IDs (found in each database) to work on the standby server (where the database is restored), there must be a matching SQL Server login ID on that server, otherwise users will not be able to log into the database on the standby server. The database or databases that are being failed over to the standby server cannot be used for anything else. www.sql-server-performance.com /sql_server_log_shipping.asp   (4873 words)

Tour Web Services Atomic Transaction operations If the transaction is not known by the coordinator (in other words, is before any record is on the coordinator's log), then the recovery rule is to Undo any actions (our databases use their Undo records). The code is the small piece of logic running somewhere behind the ATM Waldo is using -- perhaps within the datacenter of one of the financial institutions involved. Abstractly, a classic transaction is just a grouping of recoverable actions, the guaranteed outcome of which is that either all the actions are taken, or none of them are taken (see Figure 1). www-128.ibm.com /developerworks/webservices/library/ws-introwsat   (4941 words)

JodoHost Forums - Database transaction log file full, 3 times in 3 days. Database transaction log file full, 3 times in 3 days. Can the transaction log size be increase or something. I have been getting errors on my website due to transaction log file being full. support.jodohost.com /showthread.php?t=3822   (344 words)

Issues with Transaction Log Files When Moving an Exchange Mailbox Database Prior to this service pack, transaction log replay with Eseutil.exe required database files to be in the same logical path location as they were when the transaction logs were generated. For example, if databases are in C:\Databases at the time a series of transaction logs is generated, and you later move the databases to D:\Databases, then subsequent transaction log replay will result in a “File not found” error. Therefore, to move a database to a new storage group and log stream, you must first ensure that the database files are in clean shutdown state. www.microsoft.com /technet/prodtechnol/exchange/guides/DROpsGuide/56310995-1cd0-483a-874d-2b058674b03e.mspx   (684 words)

Log Shipping in Microsoft SQL Server 2000 The combination of a primary server, with the database to log ship, and a secondary server, with the database to which to apply the transaction logs, is known as a log shipping pair. Log shipping can be employed in conjunction with a third party snapshot backup solution, which mirrors disks in a remote location that are attached to another server. Since the log shipped database is only a small increment of time out of sync with the primary database, it is a good idea to use it to generate the full database backups. www.microsoft.com /technet/prodtechnol/sql/2000/reskit/part4/c1361.mspx   (6073 words)

Distributed Transactions Overview The transaction manager reads its log file to determine the outcomes of transactions for which it was the commit coordinator. For outgoing transactions, the transaction manager contacts each subordinate transaction manager to which it sent the transaction and informs them of the transaction outcome. MS DTC supports transactions that are distributed across two or more Windows 95, Windows 98, Windows NT, Windows 2000, and later systems. www.microsoft.com /windows2000/en/advanced/help/addtccpt_88fr.htm   (680 words)

Extended Log File Format The common log file format is supported by the majority of analysis tools but the information about each server transaction is fixed. Log file generators should follow the line termination convention for the platform on which they are executed. The log file format described permits customized logfiles to be recorded in a format readable by generic analysis tools. www.w3.org /TR/WD-logfile.html   (1205 words)

How to Perform Microsoft SQL Server Database Log Shipping But if the transaction logs are on the same drive array as the database files, and the drive array fails, then you have lost any data entered into the system since the last log file was shipped to the standby server. Once log shipping is successfully implemented, you will want to create your own scripts to implement an actual failover to the standby server, and then you will want to test your process to see that it works successfully. Another problem with login IDs using SQL Server Authentication is the fact that when you restore a database to another SQL Server, you must synchronize the login IDs on the server with the database user IDs in the database. www.sql-server-performance.com /sql_server_log_shipping.asp   (4875 words)

VMTN Discussion Forums: VirtualCenter Database Transaction Log ... The reason why it will not shrink the transaction log is because the transaction log pointer is still at the end of the transaction log but probably in the middle of the last allocated growth of the database. The transaction log will not truncate until it reaches the beginning of the first file after you have backed up the transaction log in the database. I think there is a transaction that SQL can't halt and thus it never is able to truncate the log. www.vmware.com /community/thread.jspa?threadID=14249&messageID=186889   (466 words)

Database Seal: Transaction Log Backup, error in translog backup on SQL Newsgroups Database Seal: Transaction Log Backup, error in translog backup Database Seal: Transaction Log Backup, error in translog backup on SQL Newsgroups This is a database option, not something you set in the maint plan. www.sqlnewsgroups.net /group/microsoft.public.sqlserver.server/topic1806.aspx   (511 words)

Database log file is full - JodoHost Forums Back up the transaction log for the database to free up some log space The log file for database 'StpWorksMain' is full. I have the same problem with mi log file support.jodohost.com /showthread.php?t=276   (197 words)

unloading Vs replication We are looking for a transaction log file starting at offset 0004885577. But if you could have any hint on how to obtain the LOG offset from code, then it would be ok for me. TIA, Michele "Reg Domaratzki (iAnywhere Solutions)" wrote in message news:418a3b33$1@forums-1-dub... Execution completed The guide tells that when using the dbunload -ar option there is no need to manually adjust log offsets with the dblog utility. www.webservertalk.com /message458617.html   (197 words)

Local MS DTC Transaction Manager on a Windows 2000 System The MS DTC transaction manager maintains an MS DTC log file on a local disk volume. The MS DTC transaction manager, MS DTC Proxy, and the Component Services administrative tool are always installed with Windows 2000. When a resource manager participates in the transaction, it enlists with its local MS DTC transaction manager. www.microsoft.com /windows2000/en/advanced/help/addtccpt_4nu5.htm   (197 words)

Try your search on: Qwika (all wikis)

About us   |   Why use us?   |   Reviews   |   Press   |   Contact us   Copyright © 2005-2007 www.factbites.com Usage implies agreement with terms.