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 |
|
rogerwithnell
Starting Member
5 Posts |
 Posted - 2005-08-26 : 13:50:03
|
| To backup my database, I first use DTS to import it to my test server running SQL Server 2000. (This is on a laptop, which I use to sell my websites, so it is useful to have the latest information.On my test server, I then backup the database to file and copy that file to CD, of which I keep the three back copies. (I keep them in the car in case the house burns down!).There is no problem restoring the database unless I delete the database in SQL Server. Then the restore function says there isn't a backup file. I deleted the database on SQL Server to simulate what would happen if the hard disk crashed and I had to replace it. Even if I re-create the database with the same name, the restore function says there isn't a backup file.Any help very much appreciated. |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-08-26 : 14:26:15
|
| you need to use the WITH MOVE arguement of the restore command I think.====================================================Regards,Sean Roussy"pimpin ain't easy, but someone has to do it" -- Pimpin Whitefolks(?) |
 |
|
|
|
|
|
Can't restore the backup file