This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](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(44.800000000000004, 9%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGD%3C/text%3E%3C/svg%3E)
I want to schedule back-up (Every Day) my databases via ssms-18 with back-up file name format "databasename_back-up date_back-up time.bak". Can you help me to solve this?
![](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(163.2, 84%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYM%3C/text%3E%3C/svg%3E)
Please do not forget to mark as accepted answer wherever information provided to you were helpful.
Regards
Best and easiest way to do this (and other important jobs) is to solve it with the well known SQL Server Maintenance Scripts from Ola Hallengren.
It automatically creates all agent jobs and you just have to configure schedules!
I want to take back-up using file name dbname_date_time.bak format. But can't take it.
On the Ola Hallengren Script, you have the parameter Filename, which allows you to configure your optimal filename:
So you should change your backup job to something like
EXECUTE dbo.DatabaseBackup
@Databases = 'USER_DATABASES',
@Directory = 'C:\Backup',
@BackupType = 'FULL',
@Verify = 'Y',
@Compress = 'Y',
@CheckSum = 'Y',
@CleanupTime = 24,
@Filename = {DatabaseName}_{Year}{Month}{Day}.{FileExtension}
Msg 2812, Level 16, State 62, Line 30
Could not find stored procedure 'dbo.DatabaseBackup'.
it will be really helpful if you can kindly write the full query. Thanks in advance for all of your help.
read the instructions ;-)
1.) download the script from ola.hallengren.com
https://ola.hallengren.com/scripts/MaintenanceSolution.sql
2.) Execute that script on your SQL Server into master-db, it will create some SQL Agent Jobs for you and create all the necessary procedures
3.) Look at the SQL Agent Jobs for "Backup - User Databases FULL/DIFF/LOG", add the @Filename Parameter to the steps
4.) Start at least the FULL Backup Job... it should finish successfully.
Hi @Gowrab Das Dip ,
There is an example of creating a backup of the database in this doc
Create and run SQL Server Agent jobs on Linux
Create a backup job
select Steps>New to configure the job, use the sql code to create the backup in Command box
To schedule a job, select Schedule>New, select a recurring frequency and a start date
Right click the job and select Start Job at Step option
-------------
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
If the reply above was helpful please mark as accepted answer so it can be helpful for other community members with same questions.
Regards