October 23, 2014 at 5:44 am
I have figured out how to do a manual backup. How would I setup an automatic proceedure?
TY
mary
October 23, 2014 at 6:07 am
You could setup a "maintenance plan" using SSMS for database maintenance. This is an easy wizard to setup basic maintenance (including backup). Don't just check all the options, but read about it first. You need to know the implications about the choices you make.
On the internet you can find many custom scripts and solutions for database maintenance including database backup. Ola Hallengren https://ola.hallengren.com/ has a highly recommendedd solution, but you can find many others.
If you want to create your own backup script, the easiest way to do so is to walk through the manual GUI backup procedure. But instead of starting the backup, create the script that would be executed. Analyse this script and replace hard coded values with variables. That will give you a good start...
October 23, 2014 at 7:38 am
You could setup a "maintenance plan" using SSMS for database maintenance
How do I do this? I am a newbie to SQL so please forgive my ignorance.
October 23, 2014 at 2:21 pm
The official Microsoft manual for the maintenance plan (using the wizard) is here: http://msdn.microsoft.com/en-us/library/ms191002.aspx. If you google a bit you can find many other step-by-step descriptions and also find about the pitfalls you need to keep an eye on.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply