i have a sql server 2005 database without around 100 tables. i need to back it up every month. is there a way to automate this process? how would i do it? i am a newbie so please explain thoroughly
if it is a stored procedure please let me know what that procedure would look like and where to call it from.