- Community Home
- >
- Storage
- >
- Midrange and Enterprise Storage
- >
- StoreVirtual Storage
- >
- SQL Server backups - differentials, copy_only, and...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-21-2012 01:43 PM
11-21-2012 01:43 PM
SQL Server backups - differentials, copy_only, and the restore chain
We currently are able to use the VSS with SAN/iQ to do shadow-copy-based backups of SQL Server databases.
We know that the databases are quiesced properly, because we can restore the databases from the copies just fine - we could not do that when we were copying the relevant drives without using the VSS.
But the copy is seen as a full backup by SQL Server, therefore the restore chain for our differential backups is broken (we prefer to retain a non-shadow-copy-based full weekend backup with daily differential backups against that).
I understand that Microsoft´s VSS framework does support the ¨copy_only¨ option of SQL Server backup, meaning that the restore chain for other backups is not affected - but how to get the SAN/iQ VSS provider to utilize it?
Has anyone else faced this issue, and how did you solve it?
Or, if you have not, what alternative backup strategies have you used that allow you to sidestep the issue?
Thanks.
- Tags:
- SQL