Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

SQL Server 2008 Mirroring Testing Expand / Collapse
Author
Message
Posted Thursday, December 11, 2008 8:56 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Friday, January 30, 2009 10:12 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 11, 2014 11:46 AM
Points: 5, Visits: 34
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
Posted Friday, January 30, 2009 10:23 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, October 22, 2014 10:26 AM
Points: 1,531, Visits: 2,249
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
Post #647153
Posted Friday, January 30, 2009 2:49 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Friday, January 30, 2009 6:01 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 11, 2014 11:46 AM
Points: 5, Visits: 34
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
Posted Sunday, February 1, 2009 11:04 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, October 22, 2014 10:26 AM
Points: 1,531, Visits: 2,249
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
Post #647731
Posted Monday, April 20, 2009 12:08 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Saturday, May 4, 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
Posted Monday, April 20, 2009 12:14 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, October 22, 2014 10:26 AM
Points: 1,531, Visits: 2,249
No. You won't be able to restore your 2008 principal backup on your 2005 mirror server.

The Redneck DBA
Post #700883
Posted Monday, April 26, 2010 3:12 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 2:57 AM
Points: 405, Visits: 1,137
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
Posted Monday, April 26, 2010 8:22 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, October 22, 2014 10:26 AM
Points: 1,531, Visits: 2,249
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
Post #910409
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse