dumping to a network drive
Posted on 1998-05-12
how can one dump database to a network drive?
when i try
dump database qbtest to DISK = '\\atg251a1\share\sajal\qbtest.dat'
i get the following message
Msg 3201, Level 16, State 1
Can't open dump device '\\atg251a1\share\sajal\qbtest.dat', device error or device off line. Please consult the SQL Server error log for more details.
i understand why it is not dumping as the network drive is not being recognized by SQL Server as a dump device.
this is what i read somewhere which i do not understand as to how to implement:
If SQL Server is running as LocalSystem (which it will be if you haven't changed it), you'll need to modify the registry and add the share of the remote dump device to the NullSessionShares registry key.
i appreciate the help.