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 |
|
jbates99
Constraint Violating Yak Guru
396 Posts |
 Posted - 2010-08-20 : 15:14:48
|
| Hi everyone,2005 Standard.I am able to backup to another server like this:BACKUP DATABASE AVNAPPDB TO DISK = '\\PNCLPEDW1\C$\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\FromPNCLRMDB\AVNAPPDB.bak' WITH COPY_ONLY, INIT, SKIP;But when I attempt to restore (remotely) that database to the same server where the .bak resides... I get this error:RESTORE DATABASE AVNAPPDB2FROM DISK = '\\PNCLPEDW1\C$\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\FromPNCLRMDB\AVNAPPDB.bak'WITH RECOVERY, REPLACE, MOVE N'AVNAPPDB' TO '\\PNCLPEDW1\E$\Microsoft SQL Server\Data\AVNAPPDB2.mdf', MOVE N'AVNAPPDB_log' TO '\\PNCLPEDW1\E$\Microsoft SQL Server\Data\AVNAPPDB2_log.ldf';--- This is the error ----Msg 5110, Level 16, State 2, Line 1The file "\\PNCLPEDW1\E$\Microsoft SQL Server\Data\AVNAPPDB2.mdf" is on a network path that is not supported for database filesAny ideas? Thanks, John |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jbates99
Constraint Violating Yak Guru
396 Posts |
Posted - 2010-08-20 : 16:49:34
|
| Wow, so simple and it does make sense.That worked, Tara.You are indeed the SQL Server goddess!John |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-08-20 : 17:37:19
|
quote:
Originally posted by jbates99
Wow, so simple and it does make sense.That worked, Tara.You are indeed the AlmightySQL Server goddess!John
^^ Fixed  |
|
|
|
|
|
|
|
|
Unable to Restore to Remote Server on Same Network
Tara Kizer