April 26, 2007 at 8:36 am
We had the server our SQL 2000 db were on on fail. It doesn't look like we can get that server up an running quickly. So we plan on getting a new server for it. But temporarily we have another server that currently has SQL 2005 on it and installed. So I would like to restore db from tape and move it to the 2005 server. Can I just restore it to the 2005 server from tape? Will that work? any suggestions would be appreciated.
We have not tested it yet at all on a 2005 sql server. I have heard there are some db incapabilities. What kind of things are there? Ours is a pretty simple db. It's used for datawarehousing. Basically every night we load data into it via DTS. Then we use business objects to query and create reports off of the data.
April 26, 2007 at 11:32 am
No problem.
Create your database on the new server and make sure the compatibility mode is set to 80 ( SQL Server 2000)
Then copy your backup file to the new machine and restore the database. The restore process will convert the database to SQL Server 2005, but the compatibility mode will prevent your procs from errors.
Eric
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply