December 28, 2009 at 11:25 pm
Hey
newly am entered to dba filed .I want to know to the How to Schedule the backups of all databases in the server by writing Stored Procedure Or Writing Individual Queries .Can U any one tell brifely step by step...?
If we shedulke by sp ...i want the sp..!
December 29, 2009 at 6:38 am
Do you have a restriction of doing this using SP's only not any other way.
If SP's only you have 2 choices, search online for SQL scripts to backup all Databases and you should find one by yourself or wait until someone searches and posts the link here.
If you are ok with any means of achieving, then I can suggest the easiest way to set this up using Maintenance Plans. Look out for then in your SSMS, under Management -> Right click -> New Maintenance Plan to start with.
Again search for the same and sure you will get plenty of useful links.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 29, 2009 at 6:42 am
I agree, I'd start with Maintenance plans since you're just starting out.
The mechanism for scheduling operations within SQL Server is a service called SQL Server Agent. By default it's installed with the server and you can use that to schedule all sorts of things, including running particular stored procedures.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply