SQL database Backup every 12 hours

[Fraps]

Just need to generate a new script that WILL NOT OVERWRITE the old backup

 

[Camus_anth]

Cool silver its very safely thanks

EDIT

I found a little error on your script:

BACKUP DATABASE [ranking] TO DISK = N''C:\WINDOWS\Muonline\db_muonline.bak''

BACKUP DATABASE [ranking] TO DISK = N''C:\WINDOWS\Muonline\db_ranking.bak''

 

[Suffer]

well...bump..

tell me which database i have to open in query?
mu online or ranking?

 

[jrroger]

Does it shrink the DB or does any truncate job?