Announcement

Collapse
No announcement yet.

One database has a different default backup folder than everything else

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • One database has a different default backup folder than everything else

    Hi all,
    Sorry if this is mis-categorized, but I didn't see a SQL Server 2014 forum.

    When I do Tasks -> Back Up on one of my SQL Server 2014 hosts, the default backup path is usually auto populated as it should be:
    E:\Program Files\Microsoft SQL Server\MSSQL12.PRODUCTION\MSSQL\Backup\db_backup_f ile_name.BAK

    But for one single database, the path that shows up instead is:
    \\hostname\backup\dbname\db_backup_file_name.BAK

    This is a co-managed server, and I'm not sure what its owner's done to it, but every time he does a manual backup of that database, he forgets to change the folder at least once and generates a ticket and false-positive monitoring event.

    I've Googled and searched the registry for that path. Does anyone know where that setting is and/or how to change it back?



    Thanks!
    Sheree
    Last edited by mesheree; 15th January 2016, 23:02.

  • #2
    We really need to update the forum title, but there is not a lot of SQL traffic, so you did post in the correct place

    Will this help?
    https://www.mssqltips.com/sqlservert...backup-folder/
    Tom Jones
    MCT, MCSE (2000:Security & 2003), MCSA:Security & Messaging, MCDBA, MCDST, MCITP(EA, EMA, SA, EDA, ES, CS), MCTS, MCP, Sec+
    PhD, MSc, FIAP, MIITT
    IT Trainer / Consultant
    Ossian Ltd
    Scotland

    ** Remember to give credit where credit is due and leave reputation points where appropriate **

    Comment

    Working...
    X