|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Wednesday, November 18, 2009 6:11 AM
Points: 6,
Visits: 20
|
|
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
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Tuesday, December 01, 2009 8:24 AM
Points: 5,
Visits: 25
|
|
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?
|
|
|
|
|
SSC Eights!
Group: General Forum Members
Last Login: 2 days ago @ 1:01 PM
Points: 925,
Visits: 1,273
|
|
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
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Wednesday, November 18, 2009 6:11 AM
Points: 6,
Visits: 20
|
|
| 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.
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Tuesday, December 01, 2009 8:24 AM
Points: 5,
Visits: 25
|
|
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
|
|
|
|
|
SSC Eights!
Group: General Forum Members
Last Login: 2 days ago @ 1:01 PM
Points: 925,
Visits: 1,273
|
|
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
|
|
|
|
|
Grasshopper
Group: General Forum Members
Last Login: Friday, January 15, 2010 4:07 PM
Points: 10,
Visits: 27
|
|
Can I set up a SQL Server 2008 principal to a 2005 mirror? Maybe run the 2008 in backwards compatibility?
Thoughts anyone?
SQL Silvey
|
|
|
|
|
SSC Eights!
Group: General Forum Members
Last Login: 2 days ago @ 1:01 PM
Points: 925,
Visits: 1,273
|
|
No. You won't be able to restore your 2008 principal backup on your 2005 mirror server.
Jason Shadonix
MCTS, SQL 2005
|
|
|
|
