SQL Server 2008 Mirroring Testing

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Jason Shadonix » SQL Server 2008 Mirroring Testing

20 posts, Page 2 of 2

««1 2

SQL Server 2008 Mirroring Testing

Rate Topic

Display Mode

Topic Options

Author

Message

venablc

Posted Thursday, December 11, 2008 8:56 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, October 15, 2010 9:32 AM
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

Post #618004

mikes067

Posted Friday, January 30, 2009 10:12 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, December 10, 2010 1:25 PM
Points: 5, Visits: 28

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?

Post #647136

Jason Shadonix

Posted Friday, January 30, 2009 10:23 AM

Ten Centuries

Group: General Forum Members
Last Login: Monday, May 20, 2013 4:06 PM
Points: 1,409, Visits: 2,027

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.

Jason Shadonix
MCTS, SQL 2005

Post #647153

venablc

Posted Friday, January 30, 2009 2:49 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, October 15, 2010 9:32 AM
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.

Post #647351

mikes067

Posted Friday, January 30, 2009 6:01 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, December 10, 2010 1:25 PM
Points: 5, Visits: 28

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

Post #647416

Jason Shadonix

Posted Sunday, February 01, 2009 11:04 AM

Ten Centuries

Group: General Forum Members
Last Login: Monday, May 20, 2013 4:06 PM
Points: 1,409, Visits: 2,027

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).

Jason Shadonix
MCTS, SQL 2005

Post #647731

paul.t.silvey

Posted Monday, April 20, 2009 12:08 PM

Grasshopper

Group: General Forum Members
Last Login: Saturday, May 04, 2013 8:21 PM
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

Post #700877

Jason Shadonix

Posted Monday, April 20, 2009 12:14 PM

Ten Centuries

Group: General Forum Members
Last Login: Monday, May 20, 2013 4:06 PM
Points: 1,409, Visits: 2,027

No. You won't be able to restore your 2008 principal backup on your 2005 mirror server.

Jason Shadonix
MCTS, SQL 2005

Post #700883

dave-dj

Posted Monday, April 26, 2010 3:12 AM

Old Hand

Group: General Forum Members
Last Login: Monday, May 20, 2013 11:47 AM
Points: 380, Visits: 1,014

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)

Post #910247

Jason Shadonix

Posted Monday, April 26, 2010 8:22 AM

Ten Centuries

Group: General Forum Members
Last Login: Monday, May 20, 2013 4:06 PM
Points: 1,409, Visits: 2,027

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).

Jason Shadonix
MCTS, SQL 2005

Post #910409

« Prev Topic | Next Topic »

20 posts, Page 2 of 2

««1 2

Permissions