Restoring a large database to a mapped drive
Posted on 2010-08-30
I need a restore a database of 270GB. The .BAK is about 1GB (there is still alot of open space in the databse). I have mapped the network drive. I have started the SQL server with a account that does have read and write access on the LAN.
I changed the destination of the restored files (DB + LOG) to the Y drive (mapped LAN drive) in SQL management studio.
I get the error "The file "Y:\temp\abraham\db" db is on a network path that is not supported for database files.
Can you help me to fix this ?