How to automate my sql backup
Posted on 2008-10-03
Dear SQL experts,
I have a database that is being backup manually. Backup to a local file and the file will eventually be put onto tape. (For some reason my SQL Server is not recognising my tape drive but its ok I can live with that because I backup not only my SQL database on it)
What I am asking is a way to automate this backup process. At the moment I backup my database by going into Management Studio, right-click on the database, select Backup and choose the destination file (overwrite the existing one); then a separate backup process will backup this .bak file to tape. I would like to know what I can do to automate the backup.
Has anyone got a step by step guide for this? I know a bit of SQL so I am not too scared with SQL statements. I heard about creating a permanent device to store the backup but am not sure what is that; also I am not sure about truncating transaction logs. My hope is if there is a standard backup statement that I can schedule it to run at a chosen time. I want to perform FULL backup everyday.
THanks in advance.