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 |
|
xlancealotx
Starting Member
4 Posts |
 Posted - 2009-08-13 : 07:45:30
|
| Not a SQL admin, but since he left it's now mine! So we have an old w2k server running mssql7. That box is reporting hard drive errors all over, so we have a new w2008 server, sql 2008 installed.I tried restoring last nights backup to which was told it's not compatible. So the high level basic question, is there a simple way to import a mssql 7 database into a 2008 server? If not, what tools/steps can be taken to get the data over as I am not sure how long I have with this old server.Thanks. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-08-13 : 08:51:55
|
| you have 2 choices basically.1. script out all the objects, apply scripts on 2k8 instance and bcp the data over to new instance.2. upgrade to 2005. make sure comptibility mode is at least 80 after upgrade, then migrate THAT to 2008 |
 |
|
|
xlancealotx
Starting Member
4 Posts |
Posted - 2009-08-13 : 09:01:54
|
| Cool, I do have a sql 2005. Now are you saying upgrade the sql7 server to 2005, or remove 2008 on the new box and install 2005?Thanks |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-08-13 : 09:08:43
|
| i'll restore the sql 07 backup to 2k5, flip compatibility level to sql 2000 (on the 2k5 box) then back that up (from the 2k5 box) and restore this backup to 20081. backup from 072. restore to 2k53. flip compatibility to 20004. backup from 20055. restore to 2008[edit]-- ahhhh, a 3rd box would be handy. I wouldn't touch the 07 box except to make backups. you don't want to risk losing the data. |
|
|
|
xlancealotx
Starting Member
4 Posts |
Posted - 2009-08-13 : 09:48:36
|
| Since the 2008/2008sql is a VM box, I have no problem firing up another VM server, with sql 2005. Will take some time to stage that box, etc. but will report back. Thanks so much for the simple step by step's. |
|
|
|
|
|
|
|
|
sql 7 backup -> sql 2008 server