Choumphol Bounthinh
SSC Enthusiast
Points: 168
More actions
July 14, 2005 at 4:01 pm
#164353
Can I restore a backup file in sql server 2000 sp3/kb815495 patch into sql server 2000 running sp4?
Philip Kelley
SSCertifiable
Points: 6351
July 14, 2005 at 4:39 pm
#574616
You should have no problems doing this. If you're worried, try to restore it with a testing name (like "MyDb_temp" -- and watch those file names), on a testing server if you've got one.
Philip
Rudyx - the Doctor
SSC-Forever
Points: 43695
July 25, 2005 at 12:54 pm
#576923
One additional note ... this is for 'user' databases only. master, model and msdb cannot be restored to different versions.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply