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 - 2005-06-29 : 08:05:14
|
| Wayne writes "I have about 182 databases (sql 7.0) that were backed up using veritas with the .bak extensions.I have to restore these databases to a new server (sql 2K) and change the drive location. I do not have the option to use the sp_detach and attach.Is there anyway that I can restore these databases without having to restore them individually?I am new to SQL and therefore am not aware of all my options if any.Thanks for any help that you can provide." |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-06-29 : 08:09:17
|
| Look up RESTORE in Books Online. It comes with SQL Server free. Pay attention to the WITH MOVE option listed there. It will give you all the information you need.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
Restoring multiple databases from backups