Create Backups without Breaking the Database Backup Sequence


You could see that the Database Backup LSN has not changed when you had used the COPY_ONLY option while taking the special database backup in between your scheduled backup plan. As the LSN value was intact you were able to perform the database restore successfully. You can see from the above snippet that the value for LSN from records number 10 – 16 is same and it is highlighted within the Green Box. It is advised to use the COPY_ONLY option while performing the special database backups. In SQL Server 2005 you can only perform COPY_ONLY database backups using TSQL code. However in SQL Server 2008 you can perform COPY_ONLY database backups even using SQL Server Management Studio by selecting the Copy Only Backup option as shown in the below snippet.

 

Conclusion
The COPY_ONLY database backup option is a great option for a database administrator to use, especially in scenarios when a development or test team requires a full copy of a production database to be made available for them to work on. This option can also be used while performing periodic database refreshes in beta, test or development environments.

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 |