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,