troubleshooting Question

Help a novice DBA with unc path

Avatar of WvrLthr
WvrLthrFlag for United States of America asked on
Microsoft SQL Server 2008
6 Comments1 Solution599 ViewsLast Modified:
Hello All,

I understand SQL Server architecture and we are currently running on SQL Server 2005.  The trick is that there is very little DBA work here,  so the knowledge/skills get very rusty.  We are moving to SQL Server 2008 R2 on VMWare and want to have a common set of disk on the vcenter server for our servers to use for backup, so I need a unc path.

In researching, it seemed like unc is not an option.  However, when I play with a maintenance plan, it seems to work fine.

My question to you is what am I missing?  Am I going to hit a brick wall down the road during a process?  
-restore or restoring to another server
-keeping a couple full backups and their associated diffs and trans logs
-scheduling backups on SQL Server Agent
-something I am not thinking of

I have attached a screen shot of how I had the maintenance plan set up and it works fine when I run it from SQL Server Agent.

I appreciate your advice and time,

Database Analyst

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros