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,

Jeremy
sqlbak.docx
ASKER CERTIFIED SOLUTION
lcohan
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