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 |
|
rrb
SQLTeam Poet Laureate
1479 Posts |
 Posted - 2003-04-09 : 02:20:54
|
| Hi chumsMy problem stems from the fact that I used to have SQL Server 7 installed on my machine, but now am reduced to MSDE 2K (someone else wanted the licence).Anyhow. Restored the first database OK. It created a .dat file in MSSQL7/Data/ directory (I don't know why it chose MSSQL7!).Anyway, when I try to restore the second database (they're both from SQL Server 2K on another machine), it fails saying that there is no MSSQL/Data directory (which is true).Any ideas why it restores one to MSSQL7/Data and then tries to restore the second one to MSSQL/Data ?If I just create the MSSQL/Data directory, will I be able to see both databases?--I hope that when I die someone will say of me "That guy sure owed me a lot of money"Edited by - rrb on 04/09/2003 02:22:24 |
|
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
Posted - 2003-04-09 : 11:13:22
|
| did you try to use the MOVE command during Restore?Creating a second folder for physical data files should not affect the first database that it did restore.... |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-04-09 : 12:53:59
|
| If you do not use the WITH MOVE command, then it just uses the location that the server had where the backup was performed. If you want to know what the location of the files is, just run RESTORE FILELISTONLY (see BOL for the exact syntax). Here is an example of the RESTORE command using WITH MOVE:RESTORE DATABASE DBName from disk = 'E:\MSSQL\Backup\DBName.BAK'WITH MOVE 'DBName_data' TO 'E:\MSSQL\Data\DBName_data.mdf', MOVE 'DBName_log' TO 'E:\MSSQL\Data\DBName_log.ldf', REPLACETara |
|
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2003-04-09 : 19:40:07
|
| thanks all - I usually try to avoid all admin activities!!Cheers--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
|
|
|
|
|
|
Restoring to MSDE 2K using osql