on 09-23-2008 6:42 AM
sir,
we are using sql 2005 standard edition.
i want make daily backup schedule so what is the procedure please help me
regards,
sandip
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sandip,
You can either use SQL Maintenance Plans to schedule a backup or you can use the SBO Backup service that is part of the server tools.
For SQL Maintenance Plans, have a look here:
http://www.sql-server-performance.com/articles/dba/creating_backup_jobs_p1.aspx
For the SBO Backup service, open the SBO Service Manager, select the backup service and set the properties.
Personally, I prefer the SQL Maintenance Plan as its easy to set it up to delete older backup files and to email if the backup fails.
Kind Regards,
Owen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.