Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rolandsantos
Starting Member
24 Posts |
 Posted - 2008-03-03 : 04:20:12
|
| Will log shipping works in Standard or Developer Edition of SQL 2K or will only works in Enterprise Edition? I tried in SE/DE Edition and it created a database and initial data in the destination server as expected, but data changes in the source does not copied into the destination. The monitor server however lists that the copy and load job is successful. But still data in the destination server were not updated. Any suggestions?Thanks in advance |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-03 : 13:33:18
|
| Log shipping is an Enterprise Edition feature and also available in Developer Edition since DE mimics EE.You mention you tried in SE/DE Edition, but those are two different editions. What does SELECT @@VERSION show?Check the log shipping monitor to determine what files have been applied. Post the 3 values here.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
rolandsantos
Starting Member
24 Posts |
Posted - 2008-03-03 : 20:51:56
|
| ThanksNow I see, so Log shipping will not definitely work in SE? If this is the case then no wonder why it fails because on my test, i used the ff: source and destination : DE on Windows XP SP2 monitor server : SE on WIndows 2K Server.Now, my questioin is, will it work if my 1) source,destination and monitor all runs DE on XP SP2 or 2) mix EE/DE?3) what is the best practice?Thanks again.. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-03 : 21:47:39
|
| If this is for a production system, then you can't use Developer Edition anyway so best practice will be what is allowed by the licensing scheme.It should have worked with DE for source and destination and SE for monitor server. I'm pretty sure that the monitoring server can be SE. But check BOL for details. Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
log shipping in Standard Edition