FALCONSEYE
Programmer
Is it possible to restore a dB from a linked server? The dB is on sQL 2000 and I want to backup/restore it to SQL 2005.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Restore a DB
- Thread starter FALCONSEYE
- Start date
- Status
NoCoolHandle
Programmer
I think the simple answer to this is NO.
If you could log directly onto that server however you could always back it up to disk, then bring the backup file over the network to somehting accessable to your local server. Then you could do a restore into your local server.
If you cant do that, with some understanding of how to rebuild your db, and work wiht the system tables, you could script the creation of all the objects and transfer the data with an insert statement or 3.
Rob
If you could log directly onto that server however you could always back it up to disk, then bring the backup file over the network to somehting accessable to your local server. Then you could do a restore into your local server.
If you cant do that, with some understanding of how to rebuild your db, and work wiht the system tables, you could script the creation of all the objects and transfer the data with an insert statement or 3.
Rob
- Thread starter
- #3
FALCONSEYE
Programmer
thanks Rob. I ended up moving the backup via ftp and restoring it on the target server.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question