| Author |
Topic |
|
DavidChel
Constraint Violating Yak Guru
474 Posts |
 Posted - 2009-04-29 : 15:50:26
|
| My production server is on SQL 2000 Standard. My test machine is 2008 standard. Can I set up log shipping between the two of them? I'd like to use this method to automatically keep my test machine up to date as well as to learn the process of log shipping. If not, any other suggestions? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2009-04-29 : 16:01:33
|
| You don't have a valid test machine if you aren't using the same version as production, but obviously that's not answering your question.You can setup custom log shipping for this as I doubt the log shipping wizard would allow this situation. In order to apply the transaction logs though, it'll have to disconnect your sessions. Why not just use backup/restore instead rather than a log shipping scenario?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
DavidChel
Constraint Violating Yak Guru
474 Posts |
Posted - 2009-04-29 : 16:05:51
|
| The reason I haven't gone with backup and restore is because of our crappy ERP software. If I restore a database from our production server to our test server, then I will have to run a rather primitive VFP application to change the connections. It's a long story, but that VFP application cannot be automated. Therefore, any time I do a restore, I must also run that stupid program. Basically, I was using this as an excuse to learn to do log shipping. Also, I'm aware that the test server is not optimal because it is a different SQL version than production, but I am using it to teach myself SSRS and other things. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
DavidChel
Constraint Violating Yak Guru
474 Posts |
Posted - 2009-04-29 : 16:08:27
|
| Thank you Goddess. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
DavidChel
Constraint Violating Yak Guru
474 Posts |
Posted - 2009-04-29 : 16:13:07
|
| Well, the problem is I'm screwed. I want to learn how to use SQL 2008/2005 and be an admin. However, I am footing the bill for my own time and training, and I don't have the proper SQL versions at work to practice on. So, I'm trying to find creative ways to do this at work. Ugh. Sorry for the rant, I'm just very frustrated. |
|
|
|
|
Log Shipping between 2 different SQL Versions.