![]() ![]() What's the lifecycle for these drives to stay alive? Thanks, it worked, but somehow, after 2 weeks it stopped working and I had to recreate the map drives. ![]() How can i prevent the mapping from disapearing after a server or service restart? I tried this on several servers all have this problem. Its interesting but even with the /persistent:yes, it keeps losing the connection after the SQL service restarted. So whenever SQL Server restarts the drive gets remapped. One way you can do this is to create a startup stored procedure to map the drive. One thing you could do is create a SQL Agent Job to run each day to do the mapping, this should help with the issue. Not sure how long the mapped drives stay connected or what casues them to disconnect. Very useful command and very helpful in terms of using the network drive Thanks this is a very useful article and very well explained.Ĭreate and use Network Drive for your shared folder instead. xp_cmdshell is mapping a drive for a service account. Surely that first mapping (of a Z: drive) is totally unnecessary. Tuesday, Septem11:13:22 AM - Derek Broughton ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |