How to automate my sql backup
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Bretty1 that works a treat. I supposed backing up the database that way I don't need to worry about transaction logs?
Sorry Darkhill Bretty's solution is easier to follow and he went in first.
Sorry Darkhill Bretty's solution is easier to follow and he went in first.
I then use a JScript to zip the backups and FTP them to our backup server, but I think you have this covered.