Database Mirroring in High Safety Mode

Hello!
I'm reading about database mirroring in High Safety Mode (Synchronous with
no witness). I'm a little confused about what happens if the mirror server
disappears.
From Books Online
"If the mirror server instance goes down, the principal server instance is
unaffected and runs exposed (that is without mirroring the data)."
http://msdn2.microsoft.com/en-us/library/ms179344.aspx
I was to the course [Upgrading your Database Administration Skills to SQ
L
Server 2005] and the course material does not say the same."Scenario:
Synchronous mirroring without a witness server. If the mirror server becomes
unavailable, the principal server will take the database offline. This actio
n
attempts to maximize the protection of the database and ensure the integrity
of its contents"
I've made tests that shows that Books Online is right,
but I would like to know if this is a behaviour that has changed.
I also would like to know if it's possible to run in a more secure mode,
where exposed operations is not allowed.
Best regards
Ola Hallengren"Ola Hallengren" <OlaHallengren@.discussions.microsoft.com> wrote in message
news:C6208896-3167-4E66-B4EB-15D10BD1E1F8@.microsoft.com...
> Hello!
> I'm reading about database mirroring in High Safety Mode (Synchronous with
> no witness). I'm a little confused about what happens if the mirror server
> disappears.
> From Books Online
> "If the mirror server instance goes down, the principal server instance is
> unaffected and runs exposed (that is without mirroring the data)."
> http://msdn2.microsoft.com/en-us/library/ms179344.aspx
> I was to the course [Upgrading your Database Administration Skills to
SQL
> Server 2005] and the course material does not say the same."Scenario:
> Synchronous mirroring without a witness server. If the mirror server
> becomes
> unavailable, the principal server will take the database offline. This
> action
> attempts to maximize the protection of the database and ensure the
> integrity
> of its contents"
> I've made tests that shows that Books Online is right,
> but I would like to know if this is a behaviour that has changed.
> I also would like to know if it's possible to run in a more secure mode,
> where exposed operations is not allowed.
>
It's not built in, but if you would prefer to shut down the database rather
than run exposed, you should be able to use an event notification.
Alerting on Database Mirroring Events
http://www.microsoft.com/technet/pr...ringevents.mspx
David|||Thanks, David.
Am I right that this behavour has changed since the course material states
the following? "If the mirror server becomes unavailable, the principal
server will take the database offline."
About the event notification. I understand the approach, but would that
guarantee that not a single transaction is committed in exposed mode?
"David Browne" wrote:

>
> "Ola Hallengren" <OlaHallengren@.discussions.microsoft.com> wrote in messag
e
> news:C6208896-3167-4E66-B4EB-15D10BD1E1F8@.microsoft.com...
> It's not built in, but if you would prefer to shut down the database rathe
r
> than run exposed, you should be able to use an event notification.
> Alerting on Database Mirroring Events
> http://www.microsoft.com/technet/pr...ringevents.mspx
>
> David
>|||The course material was based on a pre-release of SQL Server, and that behav
ior explained in there
wasn't deemed practical, so it was changed to what you see in BOL.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Ola Hallengren" <OlaHallengren@.discussions.microsoft.com> wrote in message
news:C6208896-3167-4E66-B4EB-15D10BD1E1F8@.microsoft.com...
> Hello!
> I'm reading about database mirroring in High Safety Mode (Synchronous with
> no witness). I'm a little confused about what happens if the mirror server
> disappears.
> From Books Online
> "If the mirror server instance goes down, the principal server instance is
> unaffected and runs exposed (that is without mirroring the data)."
> http://msdn2.microsoft.com/en-us/library/ms179344.aspx
> I was to the course [Upgrading your Database Administration Skills to
SQL
> Server 2005] and the course material does not say the same."Scenario:
> Synchronous mirroring without a witness server. If the mirror server becom
es
> unavailable, the principal server will take the database offline. This act
ion
> attempts to maximize the protection of the database and ensure the integri
ty
> of its contents"
> I've made tests that shows that Books Online is right,
> but I would like to know if this is a behaviour that has changed.
> I also would like to know if it's possible to run in a more secure mode,
> where exposed operations is not allowed.
> Best regards
> Ola Hallengren
>|||Thanks for making clear that this is a changed behaviour.
What worries me is the following.
You have some system instabilities (network, power whatever) and suddenly
your principal server is down (dead).
The dba is called in and is thinking about bringing the mirror server online
.
Now there is two scenarios.
1. The servers were synchronized when the principal server went down.
If that's the case then there is no problem bringing the mirror server
online.
2. The servers were not synchronized (running exposed) when the principal
server went down. (That could be because of a network device was temporary
down just before.) If that's the case then there could be severe consequence
s
bringing the mirror server online.
The problem as I see it is that there is no way of knowing which scenario
that is true.
"Tibor Karaszi" wrote:

> The course material was based on a pre-release of SQL Server, and that beh
avior explained in there
> wasn't deemed practical, so it was changed to what you see in BOL.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Ola Hallengren" <OlaHallengren@.discussions.microsoft.com> wrote in messag
e
> news:C6208896-3167-4E66-B4EB-15D10BD1E1F8@.microsoft.com...
>|||"Ola Hallengren" <OlaHallengren@.discussions.microsoft.com> wrote in message
news:14AEFB8F-82EA-4220-9CE9-AD0F10BF702F@.microsoft.com...
> Thanks, David.
> Am I right that this behavour has changed since the course material states
> the following? "If the mirror server becomes unavailable, the principal
> server will take the database offline."
> About the event notification. I understand the approach, but would that
> guarantee that not a single transaction is committed in exposed mode?
>
Events are delivered asynchronously, so I don't think there's a guarantee.
You would just be able to limit your exposure.
David|||I understand the situation, and there's probably not simple solution for tha
t except using a
witness.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Ola Hallengren" <OlaHallengren@.discussions.microsoft.com> wrote in message
news:72E953E4-D749-4DDA-890A-3532D0E8BFFE@.microsoft.com...[vbcol=seagreen]
> Thanks for making clear that this is a changed behaviour.
> What worries me is the following.
> You have some system instabilities (network, power whatever) and suddenly
> your principal server is down (dead).
> The dba is called in and is thinking about bringing the mirror server onli
ne.
> Now there is two scenarios.
> 1. The servers were synchronized when the principal server went down.
> If that's the case then there is no problem bringing the mirror server
> online.
> 2. The servers were not synchronized (running exposed) when the principal
> server went down. (That could be because of a network device was temporary
> down just before.) If that's the case then there could be severe consequen
ces
> bringing the mirror server online.
> The problem as I see it is that there is no way of knowing which scenario
> that is true.
> "Tibor Karaszi" wrote:
>

Database Mirroring - High Safety Mode

Hello!

I'm reading about database mirroring in High Safety Mode (Synchronous with no witness). I'm a little confused about what happens if the mirror server disappears.

From Books Online
"If the mirror server instance goes down, the principal server instance is unaffected and runs exposed (that is without mirroring the data)."
http://msdn2.microsoft.com/en-us/library/ms179344.aspx

I was to the course [Upgrading your Database Administration Skills to SQL Server 2005] and the course material does not say the same."Scenario: Synchronous mirroring without a witness server. If the mirror server becomes unavailable, the principal server will take the database offline. This action attempts to maximize the protection of the database and ensure the integrity of its contents"
I've made tests that shows that Books Online is right,
but I would like to know if this is a behaviour that has changed.

I also would like to know if it's possible to run in a more secure mode,
where exposed operations is not allowed.

Best regards

Ola Hallengren

Ola,

Thank you for finding this issue in our training materials. The principal is not taken offline when the mirror or witness is unavailable since this would decrease the availability of the principal database otherwise. There is no formal option to take the principal offline if the mirroring state is not synchronized, however you can customize the installation and use an event to take this action if the state changes from synchroned. Keep in mind that intermittent network outages could cause the principal to be taken offline if you make this alteration. Also you will need to decide how you want to handle bringing the database back online.

Regards,

Matt Hollingsworth

Sr. Program Manager

Microsoft SQL Server

Database Mirroring - High Safety Mode

Hello!

I'm reading about database mirroring in High Safety Mode (Synchronous with no witness). I'm a little confused about what happens if the mirror server disappears.

From Books Online
"If the mirror server instance goes down, the principal server instance is unaffected and runs exposed (that is without mirroring the data)."
http://msdn2.microsoft.com/en-us/library/ms179344.aspx

I was to the course [Upgrading your Database Administration Skills to SQL Server 2005] and the course material does not say the same."Scenario: Synchronous mirroring without a witness server. If the mirror server becomes unavailable, the principal server will take the database offline. This action attempts to maximize the protection of the database and ensure the integrity of its contents"
I've made tests that shows that Books Online is right,
but I would like to know if this is a behaviour that has changed.

I also would like to know if it's possible to run in a more secure mode,
where exposed operations is not allowed.

Best regards

Ola Hallengren

Ola,

Thank you for finding this issue in our training materials. The principal is not taken offline when the mirror or witness is unavailable since this would decrease the availability of the principal database otherwise. There is no formal option to take the principal offline if the mirroring state is not synchronized, however you can customize the installation and use an event to take this action if the state changes from synchroned. Keep in mind that intermittent network outages could cause the principal to be taken offline if you make this alteration. Also you will need to decide how you want to handle bringing the database back online.

Regards,

Matt Hollingsworth

Sr. Program Manager

Microsoft SQL Server

database maintenance plans for 2005 Express

Hello:
I know how to create database maintenance plans (automated backups) in SQL
Server 2000 and 2005.
But, I have never done so in SQL Server 2005 Express Edition.
I tried right-clicking on maintenance plans in 2005 Express so that I could
choose to create new plans, but no such selection is available to choose.
So, how do you create maintenance plans in SQL Server 2005 Express Edition?
Thanks!
childofthe1980s
Express doesn't come with SQL Agent. Have a look at these:
http://blogs.msdn.com/rogerwolterblog/archive/2006/04/13/575974.aspx
Backing up Express
Automating Database maintenance in SQL 2005 Express Edition Part I
http://www.sqldbatips.com/showarticle.asp?ID=27
Automating Database maintenance in SQL 2005 Express Edition Part II
http://www.sqldbatips.com/showarticle.asp?ID=29
Andrew J. Kelly SQL MVP
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
message news:2FC46958-D2C0-4120-B6C1-583FCE607044@.microsoft.com...
> Hello:
> I know how to create database maintenance plans (automated backups) in SQL
> Server 2000 and 2005.
> But, I have never done so in SQL Server 2005 Express Edition.
> I tried right-clicking on maintenance plans in 2005 Express so that I
> could
> choose to create new plans, but no such selection is available to choose.
> So, how do you create maintenance plans in SQL Server 2005 Express
> Edition?
> Thanks!
> childofthe1980s

database maintenance plans for 2005 Express

Hello:
I know how to create database maintenance plans (automated backups) in SQL
Server 2000 and 2005.
But, I have never done so in SQL Server 2005 Express Edition.
I tried right-clicking on maintenance plans in 2005 Express so that I could
choose to create new plans, but no such selection is available to choose.
So, how do you create maintenance plans in SQL Server 2005 Express Edition?
Thanks!
childofthe1980sExpress doesn't come with SQL Agent. Have a look at these:
http://blogs.msdn.com/rogerwolterbl.../13/575974.aspx
Backing up Express
Automating Database maintenance in SQL 2005 Express Edition Part I
http://www.sqldbatips.com/showarticle.asp?ID=27
Automating Database maintenance in SQL 2005 Express Edition Part II
http://www.sqldbatips.com/showarticle.asp?ID=29
Andrew J. Kelly SQL MVP
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
message news:2FC46958-D2C0-4120-B6C1-583FCE607044@.microsoft.com...
> Hello:
> I know how to create database maintenance plans (automated backups) in SQL
> Server 2000 and 2005.
> But, I have never done so in SQL Server 2005 Express Edition.
> I tried right-clicking on maintenance plans in 2005 Express so that I
> could
> choose to create new plans, but no such selection is available to choose.
> So, how do you create maintenance plans in SQL Server 2005 Express
> Edition?
> Thanks!
> childofthe1980s

database mail XPs

hello
i want to know the meaning of XPs?
thank you
Extended Stored Procedure. Something writem in a compiled language that
creates a .dll file that you must register in SQL Server before you can use
it.
"test windows" <testwindows@.discussions.microsoft.com> wrote in message
news:48A67541-5B92-4207-A1A8-9C89E499F4E8@.microsoft.com...
> hello
> i want to know the meaning of XPs?
> thank you

database mail XPs

hello
i want to know the meaning of XPs'
thank youExtended Stored Procedure. Something writem in a compiled language that
creates a .dll file that you must register in SQL Server before you can use
it.
"test windows" <testwindows@.discussions.microsoft.com> wrote in message
news:48A67541-5B92-4207-A1A8-9C89E499F4E8@.microsoft.com...
> hello
> i want to know the meaning of XPs'
> thank you

Database location in crystal report

Hello
i am totally new to crystal reports
Do we need to change database location of crystal report after installation at client side
If this is case then if there are 1000 reports, database location has to be changed for each report?
any there some shortcut to do this programmatically or any other wayHi,

use a DataSethttp://support.businessobjects.com/communityCS/TechnicalPapers/rtm_reportingoffadonetdatasets.pdf

or a ReportIni like this:
Private Sub ReportInit(ByVal blRefreshLocation As Boolean)

Dim crSections As Sections
Dim crSection As Section
Dim crReportObjects As ReportObjects
Dim crReportObject As ReportObject
Dim crSubreportObject As SubreportObject

Dim crReportDocument As ReportDocument
Dim crSubreportDocument As ReportDocument

Dim crDatabase As Database
Dim crTables As Tables
Dim crTable As Table
Dim crTableLogOnInfo As TableLogOnInfo
Dim crConnectioninfo As ConnectionInfo

Dim myArrayList As ArrayList = New ArrayList

'declare an instance of the report and the connectionInfo object

crReportDocument = New ReportDocument
crConnectioninfo = New ConnectionInfo

crReportDocument.Load(mstrReportName)

'pass the necessary parameters to the connectionInfo object
With crConnectioninfo
.ServerName = mstrDBServerName
.DatabaseName = mstrDataBaseName
End With

'set up the database and tables objects to refer to the current report
crDatabase = crReportDocument.Database
crTables = crDatabase.Tables

'loop through all the tables and pass in the connection info
For Each crTable In crTables
crTableLogOnInfo = crTable.LogOnInfo
crTableLogOnInfo.ConnectionInfo = crConnectioninfo
If blRefreshLocation Then
crTable.Location = mstrDataBaseName & ".dbo." &
crTable.Location.Substring(crTable.Location.LastIndexOf(".") + 1)
End If
crTable.ApplyLogOnInfo(crTableLogOnInfo)
Next

'set the crSections object to the current report's sections
crSections = crReportDocument.ReportDefinition.Sections

'loop through all the sections to find all the report objects
For Each crSection In crSections
crReportObjects = crSection.ReportObjects
'loop through all the report objects to find all the subreports
For Each crReportObject In crReportObjects
If crReportObject.Kind = ReportObjectKind.SubreportObject Then
'you will need to typecast the reportobject to a
subreport
'object once you find it
crSubreportObject = CType(crReportObject, SubreportObject)

'open the subreport object
crSubreportDocument =
crSubreportObject.OpenSubreport(crSubreportObject.SubreportName)

'set the database and tables objects to work with the
subreport
crDatabase = crSubreportDocument.Database
crTables = crDatabase.Tables

'loop through all the tables in the subreport and
'set up the connection info and apply it to the tables
For Each crTable In crTables
With crConnectioninfo
.ServerName = mstrDBServerName
End With
crTableLogOnInfo = crTable.LogOnInfo
crTableLogOnInfo.ConnectionInfo = crConnectioninfo
If blRefreshLocation Then
crTable.Location = mstrDataBaseName & ".dbo." &
crTable.Location.Substring(crTable.Location.LastIndexOf(".") + 1)
End If
crTable.ApplyLogOnInfo(crTableLogOnInfo)
Next
End If
Next
Next

crystalReportViewer.ReportSource = crReportDocument

End Sub|||You need to make database connection suggested above or Try to use DSN name