Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Server 2008 Mirroring Testing


SQL Server 2008 Mirroring Testing

Author
Message
venablc
venablc
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 21
You correct, i never realised...

Snapshots aren't standalone copies of the database, they appear much more complicated and still require the use of the original MDF file. For this reason they cannot be used on any other physical server than the one they were created on.

As long as physical resources such as processor power are not a problem you can however attach the snashot to a new database on the same server which may yield performance improvements in regards to locking.

I haven't had time to read them properly myself but here are a few links which look like they explain how it works and what they can be used for quite well...

http://msdn.microsoft.com/en-us/library/ms187054(SQL.90).aspx
http://www.simple-talk.com/sql/database-administration/sql-server-2005-snapshots/
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1176142,00.html
mikes067
mikes067
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 37
How did you implement 2005(principle) to 2008(Mirror)...

It won't let me configure the security?

I have to manually create the endpoint on 2008? Then use that?
TheRedneckDBA
TheRedneckDBA
SSCommitted
SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)

Group: General Forum Members
Points: 1872 Visits: 2592
If by manually you mean by scripting it instead of using the GUI setup in SSMS, then yes, I did it manually.

I haven't ever played with the GUI, so I can't give you much advice there if it's giving you trouble. Other than I would suggest not mirroring from 2005 to 2008 unless you have plans to upgrade your 2005 box in the near future.

The Redneck DBA
venablc
venablc
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 21
I haven't experiencince mirroring between 2005 and 2008 (just 2005 to 2005) however i did find the GUI pretty buggy and would recoomend doing it "manually" where possible.
mikes067
mikes067
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 37
it worked fine using 2008. I connected to both and setup the mirror(2005 to 2008).

I am fully patched on 2008 so maybe thats your problem. Worked flawless. Monitor in 2005 obviously doesnt like it though but it see's it.

You have to truly monitor from 2008
TheRedneckDBA
TheRedneckDBA
SSCommitted
SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)

Group: General Forum Members
Points: 1872 Visits: 2592
Glad you got it working. Just keep in mind two things about mirroring from a 2005 principal to a 2008 mirror:

1) You can't do snapshots
2) If for some reason your principal dies and you fail over to the 2008 mirror instance and make that the principal, you've just upgraded your database to SQL 2008 and can't restore it to SQL 2005 ever again. (OK, I suppose if you really wanted to you could manually extract all the data, or use one of the data transfer wizards, but it probably wouldn't be fun if your DB is very big).

The Redneck DBA
paul.t.silvey
paul.t.silvey
Grasshopper
Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)

Group: General Forum Members
Points: 13 Visits: 58
Can I set up a SQL Server 2008 principal to a 2005 mirror? Maybe run the 2008 in backwards compatibility?

Thoughts anyone?

SQL Silvey
TheRedneckDBA
TheRedneckDBA
SSCommitted
SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)

Group: General Forum Members
Points: 1872 Visits: 2592
No. You won't be able to restore your 2008 principal backup on your 2005 mirror server.

The Redneck DBA
dave-dj
dave-dj
SSC-Addicted
SSC-Addicted (438 reputation)SSC-Addicted (438 reputation)SSC-Addicted (438 reputation)SSC-Addicted (438 reputation)SSC-Addicted (438 reputation)SSC-Addicted (438 reputation)SSC-Addicted (438 reputation)SSC-Addicted (438 reputation)

Group: General Forum Members
Points: 438 Visits: 1149
Hi Jason,

The last post dissappointingly answered a question I had. My other question though, is what process would you recommend for upgrading SQL 2005 servers that are taking part in mirroring.

_____________________________________________________________________________
MCITP: Business Intelligence Developer (2005)
TheRedneckDBA
TheRedneckDBA
SSCommitted
SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)

Group: General Forum Members
Points: 1872 Visits: 2592
dave-dj (4/26/2010)
Hi Jason,

The last post dissappointingly answered a question I had. My other question though, is what process would you recommend for upgrading SQL 2005 servers that are taking part in mirroring.


I haven't had to do that yet (all of our SQL 2K8 servers are supporting new apps, and we don't have plans to upgrade our existing 2K5 servers any time soon). I would think you would want to upgrade the mirror server first if you want to have a minimal impact on mirroring. (You can mirror from 2005-2008 for awhile if you need to).

The Redneck DBA
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search