September 7, 2005 at 8:48 am
I know the chances of getting a positive answer on this are remote but here goes:
I have a db that I need to move to a new server (that isnt on the same network !)
Firstly tried, backing up the DB, copying the backup to various removable media, copied it onto the new server, then tried restoring. The restore almost completes, then comes up that backup is incomplete !
If I restore the DB on the original server from the same backup file it works fine !
Second method, detached the DB, copied the mdf file to a memory stick, copied onto the new server, attempted to attach the mdf file and get:
I/O error (bad page ID) detected during read at offset 0x00000003f80000 in file ..........mdf
Error: 823, Severity: 24, State: 2
If I re-attach the file on the original server this works !!!
My next step will be to get the two servers connected over the network, so that I can use DTS, but this is not ideal and would like to avoid this if possible.
If anybody has any suggestions, I would be eternally grateful.
p.s. I have tried restoring/attaching on other servers in case it was a problem with the new server, but get the same problems.
Regards
Tom
Tom Willetts
September 7, 2005 at 8:58 am
Do you have enough permission on the destination server to create a new database? Sometimes it require sys admin priveledge because on the source server your guid is the same as in master, on destination your guid might be difference and that's why it failed.
mom
September 7, 2005 at 11:04 am
1. Is SQL Server installed on the other server? I'm pretty sure this is obvious, but I've seen other people try to move a database to other places on a network, thinking it will still work with the SQL Server on the original computer.
2. If SQL Server is installed on the computer you are moving the database to.....is it the same version and patch level - or higher? For example, you can't always move a SQL Server 2000 SP3a to a system with 2000 and SP2.
3. Is the COLLATION the same on both systems?
-SQLBill
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply