Backup to another server

Posted on 2009-12-21
Last Modified: 2012-05-08
It so happens that another server on the domain has plenty of hard drive space. Is it possible to backup a database to a different server's LUN?

What kind of permissions are required for this to be set up?

Question by:anushahanna
    LVL 60

    Accepted Solution


    backup database dbname
    to disk = '\\servername\c$\backup.bak'

    the accounts that run the sql server service and sql agent will need access to the server and perms to put files there.
    LVL 5

    Expert Comment

    Create a specifc Domain User Account dedicated for this task. this user should be in the local admin group of both machines;
    Backup your databases into a directory located on the same server using SQL Server.
    Then share this location with full permissions (Share and Network) ONLY to the Domain user created above. Schedule a Windows task using the robocopy.exe utility (provided by windows) to copy your backup.
    SQL server is network failure intolerent, meaning that if during the backup,there any can of network failure or disconnection, your backup will fail for sure.Robocopy allow you to restart you copy in any kind of failure, there command switches that allow you to configure at which frequency to restart your backup if there any issue.
    I would suggest you to process this way; I do such backups everyday on multiples servers,and it has always worked like that for me. I first tried using the SQL server itself, but too much failure...

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Join & Write a Comment

    A quick step-by-step overview of installing and configuring Carbonite Server Backup.
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…
    This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…

    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.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now