About Schedule Backups | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

About Schedule Backups

Hi everyone, I need help please. My question is: Is it posible to have schedule backups in sql server 2005 enterprise? I mean automaticaly backup my database e.g every sunday at 12:00am and if its posible how can i do it?. Thank you for replies.
In Management Studio, there should be an option under "Management" -> "Maintenance Plans". Create a new maintenance plan first and then schedule it by clicking on the 3 dots "…" next to the Red "X". Add the necessary timeframe there and then go to "Back up Database Task" on the middle left hand corner of the screen. Alternatively, you can also use the "AT" command, and here is a link to read more up on it: http://support.microsoft.com/kb/162294/en-us Let me know if it works, Tahsin.
Hi Tahsin, i did what you said and it worked perfectly, thank you very much for the help. Ravs