How do I backup the transaction log for a mirrored database in SQL Server?

Posted by Middletone on Server Fault See other posts from Server Fault or by Middletone
Published on 2010-04-28T16:22:46Z Indexed on 2010/04/28 22:57 UTC
Read the original article Hit count: 217

Filed under:

sql-backup

|

transaction-log

|

sql-server

I have a mirrored database and am trying to perform a backup of the transaction log, but after it gets to 90% it just hangs and won't go any further.

What is the correct method for backing up a DB that is in the mirroring state?

© Server Fault or respective owner

Related posts about sql-backup

Advantages of SQL Backup Pro

as seen on Simple Talk - Search for 'Simple Talk'
Getting backups of your databases in place is a fundamental issue for protection of the business. Yes, I said business, not data, not databases, but business. Because of a lack of good, tested, backups, companies have gone completely out of business or suffered traumatic financial loss. That’s… >>> More
Copy files from sub directories into one directory.

as seen on Server Fault - Search for 'Server Fault'
Ok I have a bunch of files in this file structure format. /backup/daily/database1/database1-2011-01-01.sql /backup/daily/database1/database1-2011-01-02.sql /backup/daily/database1/database1-2011-01-03.sql /backup/daily/database1/database1-2011-01-04.sql /backup/daily/database1/database1-2011-01-05… >>> More
DPM 2007 clashing with existing SQL backup job

as seen on Server Fault - Search for 'Server Fault'
I've recently installed a DPM2007 server on Server 2003 and have set up a protection group against a server 2003 server running SQL 2005 SP3. The SQL server in question has a full backup (as a sql agent job) once a day and transaction log backups hourly. These are zipped up and FTP'd to a server… >>> More
Windows Server 2008 CMD Task Schedule not running

as seen on Server Fault - Search for 'Server Fault'
I have a BAT/CMD file that when run from the command prompt runs completely. When I run it through the Task Scheduler it partially runs. Here is a copy of the file cd\sqlbackup ren Apps_Backup*.* Apps.Bak ren Apps_Was_Backup*.* Apps_Was.Bak xcopy /Y c:\sqlbackup\*.bak c:\sqlbackup\11\*.bak xcopy… >>> More
SqlBackup from my client app

as seen on Stack Overflow - Search for 'Stack Overflow'
I have an client app that runs on several machines, and connects to a single SQL database. On the client app, the user has the possiblity to use a local SQL (CE) database or connect to a remote SQL database. There is also a box where a backup location can be set. For the backup of the remote SQL… >>> More

Related posts about transaction-log

SQL SERVER – Transaction Log Full – Transaction Log Larger than Data File – Notes from Fields #001

as seen on SQL Authority - Search for 'SQL Authority'
I am very excited to announce a new series on this blog – Notes from Fields. I have been blogging for almost 7 years on this blog and it has been a wonderful experience. Though, I have extensive experience with SQL and Databases, it is always a good idea that we consult experts for their advice… >>> More
Stairway to Transaction Log Management in SQL Server, Level 1: Transaction Log Overview

as seen on SQL Server Central - Search for 'SQL Server Central'
The transaction log is used by SQL Server to maintain data consistency and integrity. If the database is not in Simple-recovery mode, it can also be used in an appropriate backup regime to restore the database to a point in time. The Future of SQL Server Monitoring "Being… >>> More
SQL SERVER – Repair a SQL Server Database Using a Transaction Log Explorer

as seen on SQL Authority - Search for 'SQL Authority'
In this blog, I’ll show how to use ApexSQL Log, a SQL Server transaction log viewer. You can download it for free, install, and play along. But first, let’s describe some disaster recovery scenarios where it’s useful. About SQL Server disaster recovery Along with database development and administration… >>> More
SQL Server transaction log backups,

as seen on Server Fault - Search for 'Server Fault'
Hi there, I have a question regarding the transaction log backups in sql server 2008. I am currently taking full backups once a week (Sunday) and transaction log backups daily. I put full backup in folder1 on Sunday and then on Monday I also put the 1st transaction log backup in the same folder. On… >>> More
SQL Server transaction log backups,

as seen on Server Fault - Search for 'Server Fault'
Hi there, I have a question regarding the transaction log backups in sql server 2008. I am currently taking full backups once a week (Sunday) and transaction log backups daily. I put full backup in folder1 on Sunday and then on Monday I also put the 1st transaction log backup in the same folder. On… >>> More