Creating Backup Jobs in SQL Server 2005

Useful Tip

If you need to run an ad-hoc backup of your database without impacting the backup sequence, you can do it using the COPY_ONLY option:

BACKUP DATABASE AdventureWorks
TO DISK = ‘\server02dbbackupsql2005AdvWorksData.bak’
WITH COPY_ONLY;

Conclusion

Even though your existing SQL Server 2000 scripts can be helpful in jump-starting your database backup development in Server 2005, I would still recommend gradually moving to the 2005 methodology. Nevertheless, both methods currently work, and if this article helped you simplify database backup implementation, then it has done its job.