How to make two time daily backup of SQL Server database? [closed]

Question

I use SQL Server and try to make daily backups of my database. Of course I need to backup twice, at 9am and 5pm. I use Maintenance Plans.

Can maintenance plan create two backup for each database without ecrease the first backup ?

MBuschi · Accepted Answer · 2021-04-05 14:10:02Z

0

Are you using the same backup file? In that case you have to append backups and have two schedules of the same maintenance plan.

If you want to have two files, create a second backup plan at the second time.

But if you really want to create good backup plans use the Ola hallengren solution:

and stop using integrated sql maintenance plans.

answered Apr 5 at 14:10

MBuschi

1,8751 gold badge1 silver badge10 bronze badges

Thanks for the ansewer, but , why i would stop use sql maintenance plan ? – Quentin Merlin Apr 5 at 14:11
because the Ola solution is more reliable and versatile; it is widely recognised as one of the best solutions. – MBuschi Apr 5 at 14:50
dba.stackexchange.com/questions/206975/… – MBuschi Apr 5 at 14:51
Msg 102, Level 15, State 1, Line 1 , in the backup script – Quentin Merlin Apr 5 at 15:02
? syntax error ? – MBuschi Apr 5 at 15:27

| Show 2 more comments

1 Answer 1