Browse by Tags

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: sql server, high availability, transaction log, log file, log shipping, files, .tuf

Log Shipping error "Unable to copy the initialization file"

Published 3 October 7 6:49 AM | SSQA.net

When configuring log shipping on a highly transactional environment (with SQL Clustering setup), we were hit by above error. All the Logins and their privileges are intact within the primary and standby servers along with Local server policies & group...

Filed under: sql server, high availability, server, login, cluster, log shipping, service account, firewall, unable, filecopy

Can we do logshipping from sql 2005 to 2000? How it is different between 2 SQL versions?

Published 27 September 7 7:17 AM | SSQA.net

This was the question asked by one of the user in the forums. Precisely the answer is no, as you cannot restore a log or database from SQL 2005 to 2000 version due to the differences in the design. Moreover for the sake of high availability the method...

Filed under: sql server, article, disaster recovery, 2000, 2005, difference, log shipping

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: sql server, performance, restore, transaction log, multiple, log shipping, single

FIX: Error 9003 is logged in the SQL Server error log file when you use log shipping in SQL Server 2005

Published 22 August 7 4:5 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications...

Filed under: sql server, error, kba, transaction, log shipping