Hello, my question is if is it possible to create and use a device in a
network drive. (a drive in another computer without SQL-Server mapped as X:,
Y: or something like this - even \\computername\device).
Thanks in advance
Hello, my question is if is it possible to create and use a device in a
network drive. (a drive in another computer without SQL-Server mapped as X:,
Y: or something like this - even \\computername\device).
Thanks in advance
Nacho,
In theory yes (from TSQL) but don't - it's not supported, and I can't
think of any good reason to do it. (Except maybe for dump devices)
Neil Pike MVP/MCSE
Protech Computing Ltd
Nacho,
Only for dump devices, never for data devices. Database devices MUSTQuote:>Hello, my question is if is it possible to create and use a device in a
>network drive. (a drive in another computer without SQL-Server mapped as X:,
>Y: or something like this - even \\computername\device).
Roy
Can you explain how?
Med venlig hilsen / Best regards
Morten Voigt Ingvordsen
http://www.veryComputer.com/
Why stand on a silent platform
Fight the war
* the norm
- Rage against the machine
Morten,
To set up a dump device on a network drive there are only two specialQuote:>Can you explain how?
The second thing is to make sure that the account under which the
MSSQLServer service runs has the appropriate rights on the target
server.
Other than that it is just like any other dump device.
Roy
1. SQL 7 - Dumping Devices or creating backup device on a Network Drive
Is there any way to dump/create backup device on a network drive?
3. Create/Use a device in a network drive
4. How do I write an SQL query to do this?
5. Missing network drive options when creating backup device
6. On the fly: preventing huge temporary tables?
7. Cannot Backup to a Networked Drive /Device
8. Add Backup device to a Network Drive on SQL2K SP3
9. Database Devices on network drives?
10. Can not create devices on drive D
11. Creating Device on Mapped Drive...