Wednesday, 28 June 2017
Task Pane 
Login
username:
password:
Remember Me
|Signup
Our Sponsors
Current Poll
SQL Server 2008
Are you ready for the upcoming SQL Server 2008 release?







[show results]
Database Mirroring + Backup options and standards in SQL Server 2005
Author: Grant Paisley Date Posted: 1/06/2006 11:46:15 PM
We have two sessions this month.

1. Database Mirroring

So with the recent release of SQL Server 2005 SP1 we get the highly anticipated database mirroring functionality. Database mirroring transfers transaction log records directly from one server to another and can quickly fail over to the standby server.
[url]http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx[/url]
Mark Fitzpatrick will guide us through the configuration process and share with us a few of the catcha's.


2. Standard Backup Process

The first role of a DBA is to protect the database i.e. backup! SQL Server 2005 offers some significant opportunities in this space.

In this session Geoff will build on a standard backup process and examine how to reduce the backup window by using read only file groups and partitioned tables and how to bring part of our database online.

Geoff Orr is an MCAD with over 20 years experience in developing database systems. He has worked in all aspects of systems requirements along the full life cycle of systems. He is a specialist in object oriented programming, database analysis and training. Recently, he has been working for Microsoft, providing SQL Premier Support through PSS.

Venue: Mechanics' School of Arts, Level 1, 280 Pitt St, Sydney | Duration 5:30pm Food - Session 6pm until 8pm | On: Tuesday, 6 June 2006