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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-11 : 09:12:47
|
| cathal writes "Hello,sorry to ask what is probably a very simple question, but I need to restore a sql 6.5 database from one server to another.There is no network access so I can't move the database using TRANSFER, and need to accomplish this via a copy off a CD. Normally I would do this with sp_detach_db and sp_attach_db, but these do not exist under sql 6.5, so I've attempted to force a database backup to restore to a new database as this works on sql7/2000 (albeit with the loss of users usually)Additionally, the new database needs to be called ARCH. I've created a new backup device and assigned it to my scripted (but empty) ARCH database and performed a backup. I then stopped the server and substituted my renamed file off disk, restarted the server and then did a restore. I've had mixed results with this technique, but suspect (hope) I am missing a very obvious solution.Any help/advice would be appreciated." |
|
|
|
|
|
I need to restore a sql 6.5 database from one machine to another