Diary of a Techie

3 Responses to “Free SQL2005 Training!”

1. wilson, on April 7th, 2006 at 9:24 am Said:

   Here is a great demo to find out more about Database mirroring in SQL2005!

   http://download.microsoft.com/download/9/b/7/9b7ccbb8-d48e-4227-ad8b-5a54f3701ce4/SQL-03_demo_1.exe

   In this demonstration, the demo covers how to configure a mirror of a database. We will then access the principal database in a mirror set and then attempt to access the mirror database. We will simulate the failure of the principal database and attempt to access the original mirror database to demonstrate that Automatic Failover occurred

2. wilson, on April 7th, 2006 at 12:04 pm Said:

   step 1
   Principal database in full recovery mode.

   backup database dbname to Disk= ‘\\server\folder\name.bak’
   with init

   go

   backup log dbname demo6

   step 2
   restore on mirror with no ‘recovery option’

   restore database dbname from disk=’\\server\folder\dbname.bak’
   with norecovery,

   step 3
   configure db mirroring/db properties window
   select mirroring security wizard.
   witness server? for automatic failover?

3. wilson, on April 7th, 2006 at 3:55 pm Said:

   however, for db mirroring to work, the sql2005 must be started with the -T1400 parameter.

   In sql2005, this is done under sql configuration manager. Under the sql server service, right click properties to be able to access the advance menu and add ;-T1400 into the startup parameter

Leave a Reply

Name (required)

Mail (will not be published) (required)

Website