January 14, 2009 at 2:33 pm
I have a .sql script that I created to backup all my databses to a folder on the server. How can I schedule that to run as daily backup job? Is there a way to schedule a .sql script? or you have to make it into a stored procedure first? Thanks.
January 14, 2009 at 4:54 pm
If it is just the t-sql saved in a file you can use BCP to run the contents of the file.
OR
you can Create a Sql Agent job, and for your job step select T-Sql and paste your Script in there.
This is link to 2005 but it is very similar to 2000 http://msdn.microsoft.com/en-us/library/ms187910.aspx
Or you can like you mentioned save the t-sql into a stored procedure and execute that.
OR
you can create a maintenance plan and the wizzy will let you pick where to backup stuff. and then at the end of the wizard you can schedule it.
January 16, 2009 at 7:38 am
Ray - I went with your third option - created a Maintanance backup Plan, so far so good. Thanks for the quick response.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply