My team is creating a maintenance plan for our SQL Server 2005. Our backup needs to be written to another server so we're using a UNC path. One member of the team (who's running the SQL Agent jobs) has full access to the other server. But we've run into a problem: The statement keeps failing.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!