1. We have a mixture of servers 2008 & 2005 on site A , about 15 of 25 Databases is mirroring
all of the databases is in Principal modus (on this site A)
2. As a test we are going to shutdown all the servers on Site A, and thus on site B which is (mirroring)
will automatically be Principal. ( High safety with automatic failover (synchronous) is implemented.
so far so good.
ON site B we will run a live test for about 2-5 hours. ( site A is still down and will be down during the test)
what will happen when we fire up SITE A..?
will site A automatically be a mirror site?
will all the data be sync?
How do I make site A (the principal) manually one and one or ...any other way.
Must I backup and restore on all the Databases?
Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder. The folder can be on the local hard drive or on a network share. This batch file will query the SQL server to get the current date & time and wi…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.