Back Up

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

#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

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.

[Only registered and activated users can see links. Click Here To Register...]

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