May 3, 2013 at 8:11 am
I just have 1.5 yrs exp as a dba. The requirement is as below:
Test environment - We have 15 user databases to be migrated from SQL server 2005 to SQL server 2008 R2 on a different machine.
The plan is basically to use the concept of mirroring and do the activity (This is cos at the later point of time same has to be implemented on production box which is having 500 Db's)
I have never configured mirroring too .. Can any one please help how to begin with..
May 3, 2013 at 8:16 am
Isn't this the same as your other thread? http://www.sqlservercentral.com/Forums/Topic1448705-391-1.aspx
If you split your threads you will also split your responses.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
May 3, 2013 at 8:18 am
I am sorry, It is the same issue. I wanted to make my intentions clear of my needs in the subject line
May 3, 2013 at 8:23 am
ranganathleo (5/3/2013)
I am sorry, It is the same issue. I wanted to make my intentions clear of my needs in the subject line
Not a problem at all. Maybe you should hop to the other one and ask people to direct replies to this one? With two threads you run the risk of getting some people in one and other people in the other. You tend to get better responses when all the people are together.
If I were more familiar with mirroring I would help you out. :ermm:
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
May 3, 2013 at 8:25 am
Thanks for your suggestions:-)
May 3, 2013 at 8:40 am
I would use transactional replication or log shipping to do this, but not mirroring.
In all three cases though, you need to get an initial copy of the database to the other side (whether by snapshot or by backup and restore).
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 3, 2013 at 8:41 am
If you must use mirroring, here is an article explaining what to do
http://blogs.lessthandot.com/index.php/DataMgmt/DBAdmin/mirroring-sql-server-2005-to-sql-server-2008
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 3, 2013 at 8:42 am
Thank you, But they need this to be done using Mirroring. So how to proceed?
May 3, 2013 at 8:48 am
A couple of websites can help you.
http://sqlserver.in/blog/index.php/archive/database-mirroring-step-by-step/
May 3, 2013 at 8:48 am
I would use transactional replication or log shipping to do this, but not mirroring.
Hi Jason,
I am curious, why don't you suggest mirroring for this?
Thanks
May 3, 2013 at 8:49 am
Check the link I provided.
They do understand that using mirroring provides no additional benefit over replication or logshipping in this scenario, right?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 3, 2013 at 8:55 am
sharky (5/3/2013)
I would use transactional replication or log shipping to do this, but not mirroring.
Hi Jason,
I am curious, why don't you suggest mirroring for this?
Thanks
Mirroring gives the misconception that they can fail back and forth between the two servers. Since they are looking to do a long term cutover (else why use this method anyway), a failover event may occur and upgrade the mirror database. In the event of this, you now have a SQL 2008 database trying to mirror to a SQL 2005 database and you should start seeing errors. If the failover was unplanned, you now have an outage. If you upgraded the database and you weren't quite ready to do it, then you have to restore from the primary again.
With replication, they can test the new server without having to do a failover of the database. The process becomes many times easier to allow the business to provide signoff on the upgrade while affording you an easy failback. It also reduces the likelihood of an unexpected outage.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 6, 2013 at 10:11 am
I've done a lot of cut overs like this using both mirroring or log shipping. Both work just fine, it's really just a matter of what you're most comfortable with. I've used mirroring for physically closely related servers and mirroring for physically separated servers.
It sounds like the poster has a requirement of mirroring. Just follow MSDN's walk through on it. Your only decision is whether to us AD or certificate based authentication.
Configuring Windows Authentication based Mirroring
http://msdn.microsoft.com/en-us/library/ms179306.aspx
Configure Certificate based Mirroring
http://msdn.microsoft.com/en-us/library/ms191140.aspx
It is important to note, once you fail over there's no going back because of the edition upgrade.
Good Luck!
May 6, 2013 at 10:32 am
Jon.Morisi (5/6/2013)
I've done a lot of cut overs like this using both mirroring or log shipping. Both work just fine, it's really just a matter of what you're most comfortable with. I've used mirroring for physically closely related servers and mirroring for physically separated servers....
It is important to note, once you fail over there's no going back because of the edition upgrade.
Good Luck!
Glad you also noted that same problem. That (bolded sentence in quote) is a big issue - and the main reason why I tend to shy away from it as an upgrade means.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply