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 |
|
Johnw230873
Starting Member
2 Posts |
 Posted - 2011-04-13 : 23:53:37
|
| We are going to be doing an upgrade of our current system from sql server 2005 SP1 to a new system running SQL 2005 SP4. What I would like to know is "Can SP1 backups be restored to SP4""Can SP4 backups be restored to SP1" in case it doesn't work.I think I know the answer but would like someone else to verify it. |
|
|
raghuveer125
Constraint Violating Yak Guru
285 Posts |
Posted - 2011-04-14 : 01:21:57
|
| Yes you can restore database vice versa On same Version of MS SQL 2005Raghu' S |
 |
|
|
Johnw230873
Starting Member
2 Posts |
Posted - 2011-04-14 : 02:02:55
|
| I didn't think you could restore down a SP |
|
|
|
raghuveer125
Constraint Violating Yak Guru
285 Posts |
Posted - 2011-04-14 : 02:18:19
|
| Hey we can restore if it is same version of MS sql ! If you have doubt you first try on test server; I faced this situation andit was worked for me.Raghu' S |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-04-14 : 04:03:55
|
| There are a couple of exceptions where you can't restore down service pack level, but in general service packs don't change the database version (exception is 2005 SP2 if you enable vardecimal storage) and it's that internal database version that controls whether a DB can be restored or not.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Want to restore user database to a lower SP