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 |
|
alaska8
Starting Member
4 Posts |
 Posted - 2002-02-25 : 09:47:14
|
| I am in the process of transferring a web site to a new host and am having a problem with the transfer of the SQL database. I have FTPed the .bak file to my root directory for my new host to move it to the SQL server and restore the file but they are getting this error:The file 'd:\mssql\DATA\sharp.mdf" cannot be used by RESTORE. Consider using the WITH HOME option to identify a valid location for the file. Backup or restore operation terminating abnormally.Is it possible for my new host to set up the SQL database from a .bak file or would they have to have direct access to my old host's SQL Server? Is there perhaps a problem with the .bak file? Thank you for any help. Edited by - alaska8 on 02/25/2002 10:09:51Edited by - alaska8 on 02/25/2002 10:19:50 |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-02-25 : 10:24:56
|
| Yes, You can restore this backup (Givin it is a valid backup that is). I would do as the message says and use the 'WITH MOVE' option.ex.RESTORE DATABASE sharpFROM DISK='c:\mssql\backup\sharp.bak'WITH MOVE sharp to 'c:\mssql\data\sharp.mdf',MOVE sharp_log to 'c:\mssql\data\sharp_log.ldf'If this is not exactly what you want, you can change it to fit your needs.-ChadEdited by - chadmat on 02/25/2002 10:25:24 |
 |
|
|
|
|
|
SQL database transfer to new host