General discussion


backing up sql

By avramk456 ·
hi all

i am new in sql, and i wonder what way to backup my server.
i have backupexec but need to buy the sql agent.
or i can use a script.

manuall backup show that in the databases, system databases need to backup one by one, and there is no task option there.
not like base made by the user.
also, what about security should i backup it.
are there more to be backedup?


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by 3xp3rt In reply to backing up sql

Run the enterprise manager, and run the backup wizard. (Run the wizard, select Management->Backup Wizard)at the last window check Schedule, go to change and select your option (save daily, weekly, or whatever, and the time when the backup is execute). With database backup you back up all settings regarding that database. You don't need to backup else.

Collapse -

by avramk456 In reply to backing up sql

hi 3xp3rt

thank u

i forgot to mentioned i have microsoft sql 2005
and i dont see this option u mentioned.

any way from your riply its seems very simple, never the less, i get some riplies of the thouht one sould give to his backup. so?

thanks zavik

Collapse -

by sgt_shultz In reply to backing up sql

depending on how you have sql server set up there can be a lot of processes to stop and start and some logs and intermediate transactions stuff to backup. i would buy the sql agent. and rehearse it when you get it.

Related Discussions

Related Forums