Discussion Locked

Restore SQL Server 2000

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
When I restore from SQL Server 2000 from a development server to another new server running Windows Server 2003, I received and error message that said "Device offline or Device not available".

1 reply

by ronfarzan

Dear Sir,

my firs questin is with which software you back up and restore your Data Base.
It is very important, I had the same problem when I back up and restore with Microsoft Back up that is a part of SQL 2000.
The problem is the path of Data Base and Transaction Log, I think you have to change the path of transaction log and Data Base to suitable folder in second Server.
good luck
Ron

This discussion is closed to new replies.