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 |
|
DBCowboy
Starting Member
26 Posts |
 Posted - 2005-10-11 : 13:06:40
|
| Does anyone know if it's possible to log ship from a server with sp3 to a server with sp4? (Enterprise)The reason I'm asking is to see what the options are for a possible upgrade strategy for a server cluster. I can see in the sp4 documentation that certain sytesm tables (master, model and msdb) are significantly changed in sp4, so that's why I'm concerned that it won't work.Jaysen |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-10-11 : 13:41:57
|
| You can certainly setup log shipping as a DR site in case something goes wrong. I would also suggest taking standard sql server backups as well as copying the database datafiles (while the database is offline) just in case.btw, you need to test your backups too. The only valid test is to actually restore the database and then run DBCC CHECKDB to make sure all is well.-ec |
 |
|
|
|
|
|
Log Shipping sp3 to sp4