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 |
|
Metcalf
Yak Posting Veteran
52 Posts |
 Posted - 2009-09-01 : 09:58:30
|
| I have production data on Server 2005, I need to copy that and restore it to Server 2008 on a separate machine on the same network. Is that possible? Is it possible to restore a backup of a DB made in 2005 to an instance of 2008 that has nothing on it? |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-09-01 : 10:02:25
|
| Yes, it is possible and probably one of the easiest ways to do an upgrade. The only thing to check once restored is the compatibility level, you may want to leave it, but you will probably want to change it to 2008. |
 |
|
|
Metcalf
Yak Posting Veteran
52 Posts |
Posted - 2009-09-01 : 10:07:19
|
quote:
Originally posted by RickD
Yes, it is possible and probably one of the easiest ways to do an upgrade. The only thing to check once restored is the compatibility level, you may want to leave it, but you will probably want to change it to 2008.
Ah, thanks for that info, it is much appreciated! |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2009-09-01 : 11:30:17
|
| You should be aware that once you have restored the database on 2008, you cannot use a 2008 backup to restore to 2005.CODO ERGO SUM |
|
|
|
|
|
|
Need to Copy DB from Server 2005 to 2008