To prepare a database for mirroring, you need to perform the following steps: Script the restore of the latest full database backup, script the restore of every transaction log backup that has been made after that full database backup, copy the full database backup and transaction log backups to the mirror server, and run the restore scripts on the mirror server.
In this tip I will walk through these steps and provide sample scripts to prepare a database for mirroring.

The Cult of Mediocrity

by Michael Coles

SQLServerCentral.com

Editorial

This guest editorial from Michael Coles was originally published on Aug 1, 2007. It is being re-run as Steve is on vacation. Today Michael talks about the potential for reward for taking risk.

PASS Data Architecture VC presents Neil Hambly on Improve Data Quality & Integrity using Constraints

by Additional Articles

PASS

PASS Virtual Chapters

On Tuesday June 19th 12PM noon Central, Neil Hambly will discuss "Leveraging the power of constraints to improve both data quality and performance of your databases."

The Strategic Value of Monitoring SQL Servers

by Additional Articles

SimpleTalk

Monitoring

Why would you ever need to automatically monitor the SQL Servers in your care? What is the business value of doing so? What are the important features that a DBA should look for in a performance-monitoring tool? Rodney Landrum gives answers based on long experience.

Change Tracking - 2008

by Nitesh R Dedhia

SQLServerCentral.com

Change Tracking

Change tracking in SQL Server 2008 enables applications to obtain only changes that have been made to the user tables, along with the information about those changes.

The Certification Debate

by Steve Jones

SQLServerCentral.com

Editorial

Today's editorial was originally published on Aug 7, 2007. It is being re-run as Steve is on holiday. Is it worth getting certificated? Steve raises the question today.

The Redmond Agenda

by Steve Jones

SQLServerCentral.com

Editorial

Is there an agenda in Redmond that looks to the cloud first for new versions of the platforms? Steve Jones thinks if there is, it might be a good thing.

Using ASCMD to run command line scripts for SQL Server Analysis Services

by Additional Articles

MSSQLTips.com

ASCMD

Sometimes it would be helpful to run scripts from a command line for Analysis Services. This would be useful for things like creating backups, processing data or running other tasks. Is there a command line tool like sqlcmd for multidimensional databases and Data Mining?

Creating Indicator and Gauge Report in SSRS - SQL Server 2008 R2

by Additional Articles

Database Journal

Reporting Services (SSRS)

SQL Server Reporting Services allows you to embed indicators and Gauges in your report to analyze the data and its state. Indicators are minimal gauges that convey the state of a single data value at a glance and are mostly used to represent state value of Key Performance Indicator (KPI).

After X Years

by Steve Jones

SQLServerCentral.com

Editorial

Dave Winer has been programming for a long time, and he plans on continuing for some time to come. Steve Jones talks about the important things Dave realizes and how we should also be considering them.

Simple Steps to Prepare Mirror Database for Mirroring in SQL Server

The Cult of Mediocrity

PASS Data Architecture VC presents Neil Hambly on Improve Data Quality & Integrity using Constraints

The Strategic Value of Monitoring SQL Servers

Change Tracking - 2008

The Certification Debate

The Redmond Agenda

Using ASCMD to run command line scripts for SQL Server Analysis Services

Creating Indicator and Gauge Report in SSRS - SQL Server 2008 R2

After X Years

Blogs

Databases and AI Agents

Creating a Pulsing Conducting Baton - Part 1

ISACA AI Material/Exam Prep Discount (May 18 – June 30, 2026)

Forums

Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit

Distance Metric Algorithms

What Can AI Really Do?

Question of the Day

Distance Metric Algorithms