Back Up

[benoli105]

hey guys sorry for making alot of threads but i've got another question , is it possible to backup the DB w/o restarting the server / Database ?

thanks

[JohnHeatz]

#Moved to the right section

Regarding your question itself, the best way to do a backup is while on maintenance so that you can stop your services and create the backup, yet there are scripts for the backups to be done automatically every certain time, which might help you out

[DeviL125]

Heres a t-sql script you can run at any time, or if you have SQL agent can run as an automatic job periodically. If you open the script you can edit the save locations yourself in case you want to specify your own location. Caution, these backup files can get pretty big if run very often, so I'd suggest deleting them and running a fresh copy every so often.



To restore from the backups, right click said database, Tasks>Restore>Database... window will open, Check Device, another pops open... click add, navigate to .bak of said DB, click ok... window will close, check next to the restore point you wish to restore, click ok... restoration will run.

Regards,

DeviL