Can you write the backup straight to a UNC instead? Like \\servername\sharename ?? Drive mappings are just an indirection to this anyways... (I have seen some braindead apps that would not accept a UNC path, but SQL Server is not one of these...)
Best, Will -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Ski Kacoroski Sent: Wednesday, May 02, 2012 5:20 PM To: [email protected] Subject: [lopsa-discuss] Mapping drives in windows 2008 Hi, We have several applications and databases that we create data dumps from each night. Due to space limitations on the server SAN, we would like to write these to our NAS device. For unix this is not a problem as I just NFS mount the NAs device and all my processes can write to it. However, on windows it seems like this is impossible as mounted disks are done per user and disappear when the user logs off. My immediate problem is doing it with a SQL 2005 database. I have the backup job set up, but cannot figure out how to make a mounted drive available to it. Is this even possible? If so, how would I do it? cheers, ski --- "When we try to pick out anything by itself, we find it connected to the entire universe" John Muir Chris "Ski" Kacoroski, Unix Admin 206-501-9803, ski98033 on IRC and most IM services _______________________________________________ Discuss mailing list [email protected] https://lists.lopsa.org/cgi-bin/mailman/listinfo/discuss This list provided by the League of Professional System Administrators http://lopsa.org/ _______________________________________________ Discuss mailing list [email protected] https://lists.lopsa.org/cgi-bin/mailman/listinfo/discuss This list provided by the League of Professional System Administrators http://lopsa.org/
