14,498 questions
I had a look at https://ola.hallengren.com/sql-server-backup.html and it seems to me that the @DirectoryStructure parameter does what you need. (I don't use Ola's scripts myself, since I am not in a DBA role.)
How to use Ola Hallengren's scripts?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 3%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
CharlieLor
566
Reputation points
I'm exploring the Ola Hallengren's scripts.
For transaction log backup, it puts the .trn file inside of serverName$InstanceName/DatabaseName/Log folder. I just need it to put inside of "DatabaseName" folder and that's it. Is this possible?
Thank you.
SQL Server | Other
{count} votes
-
LiHongMSFT-4306 31,566 Reputation points2024-02-06T02:25:44.4866667+00:00 Hi @CharlieLor Is this issue solved now? If you have any questions, please feel free to share with us. And don't forget to accept the answers if they helped. Your action would be helpful to other users who encounter the same issue and read this thread. Thanks for your understanding!
Sign in to comment
Accepted answer
-
Erland Sommarskog 121.7K Reputation points MVP Volunteer Moderator2024-02-05T22:44:36.1833333+00:00 -
CharlieLor 566 Reputation points
2024-02-06T13:22:26.3666667+00:00 Thank you for pointing that parameter out. I was looking at that documentation but couldn't find that specific parameter. It's not doing exactly what I was looking for but at least it's getting closer. I tried:
@DirectoryStructure = '{DatabaseName},
and it's giving me error. So it seems that I have to use the whole parameter like:
@DirectoryStructure = '{DatabaseName}{DirectorySeparator}{BackupType}{Partial}{CopyOnly}',
I already setup my Directory to 'C:\Log' so I don't need "Log" folder inside of {DatabaseName}
@Directory = 'C:\Log',
However, it seemed that I may not have a choice here. Many thanks for the help though, much appreciated!
Sign in to comment -