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-02-21 : 09:40:11
|
| Ron writes "Is there anyway possible to restore/copy a SQL7 database from a server to say my desktop/environment size is not an issue.ThanksRon" |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-02-21 : 10:10:48
|
| As long as you have Desktop Edition of SQL7 installed on your desktop you should not have any problems. |
 |
|
|
rgaudreau
Starting Member
2 Posts |
Posted - 2002-02-22 : 06:39:57
|
| [quote]As long as you have Desktop Edition of SQL7 installed on your desktop you should not have any problems. I do but I am getting a error that it cannot find the raid drives |
|
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-02-22 : 08:15:11
|
| Backup "remembers" the file names/paths of the original database files. Since you are restoring on a different machine, with a different drive configuration, you should add WITH MOVE option to your RESTORE DATABASE command.Edited by - izaltsman on 02/22/2002 08:16:16 |
|
|
|
|
|
|
Restore