<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2008
»
SQL Server 2008 Administration
»
mirroing - Restoring
mirroing - Restoring
Rate Topic
Display Mode
Topic Options
Author
Message
arkiboys
arkiboys
Posted Thursday, October 25, 2012 5:10 AM
SSC Journeyman
Group: General Forum Members
Last Login: Tuesday, May 07, 2013 4:41 AM
Points: 99,
Visits: 129
Hi,
We have mirroing setup for DR purposes.
i.e.
server mdr is mirroing server m
Question:
1-
When I go to the mdr machine in sql server, I see the word restoring for all the databases and so when I try to do a select query from one of the databases, it says that the database is in the middle of a restore and therefore does not return data.
How can I then chek to see if the data inside mdr is indeed correct ?
2-
in machine m, there are sql server agent jobs.
in mdr machine, I do not see the sql server agents. How do I see them.
Thanks
Post #1376925
GilaMonster
GilaMonster
Posted Thursday, October 25, 2012 5:22 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 8:25 AM
Points: 37,683,
Visits: 29,938
If the mirroring is working, the data in the mirror DB will be correct. You could take a snapshot off the mirror and query that if you want.
SQL Agent jobs are not included in mirroring, mirroring is just the DB you configure, jobs are in MSDB. If you want them, you have to transfer them.
Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #1376928
arkiboys
arkiboys
Posted Thursday, October 25, 2012 5:34 AM
SSC Journeyman
Group: General Forum Members
Last Login: Tuesday, May 07, 2013 4:41 AM
Points: 99,
Visits: 129
GilaMonster (10/25/2012)
If the mirroring is working, the data in the mirror DB will be correct. You could take a snapshot off the mirror and query that if you want.
SQL Agent jobs are not included in mirroring, mirroring is just the DB you configure, jobs are in MSDB. If you want them, you have to transfer them.
The applications (User screens) are pointing to the machine m (Prod server).
how do I know that if the machine m goes down, then automatically the applications are redirected to the mdr (DR database machine)?
Post #1376932
arkiboys
arkiboys
Posted Thursday, October 25, 2012 5:43 AM
SSC Journeyman
Group: General Forum Members
Last Login: Tuesday, May 07, 2013 4:41 AM
Points: 99,
Visits: 129
GilaMonster (10/25/2012)
SQL Agent jobs are not included in mirroring, mirroring is just the DB you configure, jobs are in MSDB. If you want them, you have to transfer them.
How can the sql server jobs appear in the mdr machine?
I mean how can they be copied so that I see them as I do in the prod management studio in sql server?
Thanks
Post #1376935
Perry Whittle
Perry Whittle
Posted Thursday, October 25, 2012 5:59 AM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 7:36 AM
Points: 5,201,
Visits: 11,153
arkiboys (10/25/2012)
GilaMonster (10/25/2012)
If the mirroring is working, the data in the mirror DB will be correct. You could take a snapshot off the mirror and query that if you want.
SQL Agent jobs are not included in mirroring, mirroring is just the DB you configure, jobs are in MSDB. If you want them, you have to transfer them.
The applications (User screens) are pointing to the machine m (Prod server).
how do I know that if the machine m goes down, then automatically the applications are redirected to the mdr (DR database machine)?
Depending on your applications connectivity (only through ADO.NET or SQL Native client IIRC) there is a "Failover Partner =" option for the connection string which will automatically redirect to a mirror partner.
What mode is your mirroring session using, do you have a witness server?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs"
Post #1376941
Perry Whittle
Perry Whittle
Posted Thursday, October 25, 2012 6:00 AM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 7:36 AM
Points: 5,201,
Visits: 11,153
arkiboys (10/25/2012)
GilaMonster (10/25/2012)
SQL Agent jobs are not included in mirroring, mirroring is just the DB you configure, jobs are in MSDB. If you want them, you have to transfer them.
How can the sql server jobs appear in the mdr machine?
I mean how can they be copied so that I see them as I do in the prod management studio in sql server?
Thanks
script the jobs out and copy them same as the logins too.
Either that or use an SSIS package task to transfer the objects for you
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs"
Post #1376943
GilaMonster
GilaMonster
Posted Thursday, October 25, 2012 6:07 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 8:25 AM
Points: 37,683,
Visits: 29,938
arkiboys (10/25/2012)
how do I know that if the machine m goes down, then automatically the applications are redirected to the mdr (DR database machine)?
Run a DR test. Fail the mirroring over and check that the apps reconnect properly. You can fail back afterwards. If you have the connection string set correctly it should work. Actually, should work even without that, read up on transparent client redirect.
Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #1376945
arkiboys
arkiboys
Posted Thursday, October 25, 2012 8:38 AM
SSC Journeyman
Group: General Forum Members
Last Login: Tuesday, May 07, 2013 4:41 AM
Points: 99,
Visits: 129
Perry Whittle (10/25/2012)
arkiboys (10/25/2012)
GilaMonster (10/25/2012)
SQL Agent jobs are not included in mirroring, mirroring is just the DB you configure, jobs are in MSDB. If you want them, you have to transfer them.
How can the sql server jobs appear in the mdr machine?
I mean how can they be copied so that I see them as I do in the prod management studio in sql server?
Thanks
script the jobs out and copy them same as the logins too.
Either that or use an SSIS package task to transfer the objects for you
I can script the job in production.
In the script, I see the name for the production server.
On running this script in the mdr (mirrored server), do I change the production server name to the mirrored server name?
Post #1377041
Perry Whittle
Perry Whittle
Posted Thursday, October 25, 2012 8:46 AM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 7:36 AM
Points: 5,201,
Visits: 11,153
arkiboys (10/25/2012)
I can script the job in production.
In the script, I see the name for the production server.
On running this script in the mdr (mirrored server), do I change the production server name to the mirrored server name?
Hmm, for a local server job you generally won't see the server name, is this a mutli server job?
Can you post the section of the script in question?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs"
Post #1377045
arkiboys
arkiboys
Posted Friday, October 26, 2012 4:41 AM
SSC Journeyman
Group: General Forum Members
Last Login: Tuesday, May 07, 2013 4:41 AM
Points: 99,
Visits: 129
Some of these jobs are executing ssis packages with parameters, etc...
That is fine, I just change the name of the server in the sql jobs.
Thanks
Post #1377465
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
