The KN8164V features HD resolution of 1920 x 1200, FIPS 140-2 with level 1 security standards and virtual media transmissions at twice the speed. Built for reliability, the KN series provides local console and remote over IP access, ensuring 24/7 availability to all servers.
Course Of The Month
7 days, 23 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
How would I backup an SQL 2008 DB on a remote computer using Maintenance Plan Wizard?
Posted on 2011-03-08
I would like to schedule backups of our SQL 2008 DBs onto a remote computer using the
Maintenance Plan Wizard. I see how to do this on a local computer. However, the option to
use a shared drive is not offered. How would I do this?
Maintenance Plan Wizard. I see how to do this on a local computer. However, the option to
use a shared drive is not offered. How would I do this?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
4
2
2- +1
9 Comments
Active today
You won't see the share when you create the maintenance plan but you can write full path (something like
Good luck
\\ComputerName\ShareName). Will work fine.
Good luck
Active 3 days ago
Make sure the startup account for the SQL Server and SQL Server Agent services have the appropriate permissions (they are not Local System accounts)
If you're talking about using a mapped drive, that's not available because the SQL Server doesn't see the mapped drives the user sees, since they run in different sessions. If you just want to back up to a remote location though, you can just provide the UNC path to your remote folder in your backup location - something like "\\REMOTESERVER\SomeBackup
Also, you have the option of setting up your maintenance plan on another server and then taking backups from your main server and storing them locally (on the remote server). To do this, you'd create the maintenance plan on your remote server, and at the top of the page, where it asks you what connection you'll be backing up, point it to your SQL Server.
Also, you have the option of setting up your maintenance plan on another server and then taking backups from your main server and storing them locally (on the remote server). To do this, you'd create the maintenance plan on your remote server, and at the top of the page, where it asks you what connection you'll be backing up, point it to your SQL Server.
I get the attached error when I enter \\server\shared$ even though the server is not mapped to this drive.
What is causing this? Thanks
Picture-3.png
What is causing this? Thanks
Picture-3.png
Active 3 days ago
>>Thanks. That solved it. <<
Excellent! Now please close the question. Here is how:
http://www.experts-exchange.com/help.jsp#hs=29&hi=407
Excellent! Now please close the question. Here is how:
http://www.experts-exchange.com/help.jsp#hs=29&hi=407
Featured Post
WordPress is the web's most popular CMS, but its dominance also makes it a target for attackers. Our eBook will show you how to:
Prevent costly exploits of core and plugin vulnerabilities
Repel automated attacks
Lock down your dashboard, secure your code, and protect your users
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Most of the applications these days are on Cloud. Cloud is ubiquitous with many service providers in the market. Since it has many benefits such as cost reduction, software updates, remote access, disaster recovery and much more.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Suggested Courses
Course of the Month7 days, 23 hours left to enroll
729 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.