NOT able to backup database

  • Hello All,

    Facing a problem backing up a database. When i click on backup database in the select backup destination i do not see the Drive Z that has been setup where it has to backup. It shows only the C & D drive but when i try to locate then on the server it says path cannot be found. Not sure where these C & D drive are and its not showing the C drive on the server. Please help me on how can i find the Z drive & backup to this location. Thank you

    NJPA

  • Those backup destinations are local (to the server) drives only, and I'm not sure whether that can be changed.

    But you should be able to perform the backup to your network using T-SQL commands. Check this page for details and examples.

    If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.
    See https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help/ for details of how to post T-SQL code-related questions.

  • The problem im facing is that I cant locate the C drive & D drive it says path cannot be found & im unable to back up the file to the local C drive & O drive that are on the devices & drives

    Attachments:
    You must be logged in to view attached files.
  • What is the goal here?  To backup the database to the O drive?  If so you cannot.  SQL can only backup to drives which are local to the SQL server not remote drives unless you use UNC paths etc to provide backups to network locations.

    The local drives to SQL are the local C drive and the local D drive.  NOT your devices C or O drive.

    You will need to backup to D, then use UNC to move the backup where it needs to be.

    Just remember GDPR/HIPPA/SOX etc as moving databases around can have significant headaches for data breaches especially when moving data to end user devices and data breaches etc.

  • anthony.green wrote:

    SQL can only backup to drives which are local to the SQL server not remote drives unless you use UNC paths etc to provide backups to network locations.

    IIRC, you can cheat.  If you want something mostly brainless, you can add an xp_CmdShell call in the SQL Server Startup to do a NET USE and Bob's your uncle.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    "Dear Lord... I'm a DBA so please give me patience because, if you give me strength, I'm going to need bail money too!"

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply