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.
Best Answer
you could create a maintenance plan to do the backups and then you would schedule it to run once a month. See here: http://www.databasedesign-resource.com/sql-server-maintenance-plan.html