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.

Pages: 1 2 3 4




Related Articles :

  • No Related Articles Found

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |