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-03-11 : 10:56:52
|
| Eric writes "I can backup and resore SQL 2000 with sp2 Data base on Win 2000 with sp2. In XP pro with all patches loaded, however the same process fails. Observations: In win 2000 I can see the Subst drive in the restore database screen. In XP when I go to restore a database,the subst drives are not visible even though they do show up in "my computer" Any ideas as to the real problem? Subst drives works great in Win 2000 and SQL 2000.Thank you Eric" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-03-11 : 11:29:48
|
| My guess is that they changed the internal process for the subst command, and since SQL 2000 was written before WinXP it doesn't recognize it.It's always better to use a UNC path with SQL Server. If you need to change the location you can wrap up your BACKUP and RESTORE commands in some dynamic SQL, and pass the UNC as a parameter. Check out these articles:http://www.sqlteam.com/item.asp?ItemID=4599http://www.sqlteam.com/item.asp?ItemID=4619 |
 |
|
|
|
|
|
subst drives in SQL 2000 on win 2000 ver XP