SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Feedback from Connect : Allow Snapshot Backups

I posted a note to allow snapshots to be backed up in SQL Server. The inability to do so, and the lack of a transition of a snapshot in a DR scenario means they have limited usefulness in my mind. So I added a suggestion to Connect: Allow backup/restore Snapshot databases

It’s gotten a few votes (2) over the last few weeks, and recently I got a notification that MS had responded. Kevin Farlee gave two scenarios, both of which I find interesting. The first, to allow snapshots to be backed up as snapshots with the source database, is interesting, but ultimately I think it might be too confusing for users. It’s what I’d prefer in terms of disk space, though I’d hope I could back up a single snapshot and not all 6 of them I have on a server.

The second is that snapshot backups would be regular database backups. So they’d be the size of the original database at the time the snapshot was made. I think that’s reasonable and it’s logical, and it means the backup works like every other backup.

We’ll see if it gets implemented, but it’s definitely one that I would like to see in future versions.

The Voice of the DBA

Steve Jones is the editor of SQLServerCentral.com and visits a wide variety of data related topics in his daily editorial. Steve has spent years working as a DBA and general purpose Windows administrator, primarily working with SQL Server since it was ported from Sybase in 1990. You can follow Steve on Twitter at twitter.com/way0utwest


Posted by Anonymous on 3 March 2010

Pingback from  Energy & Electricity In Science : How Does Optical Fiber Work … | Optics Science Applied

Leave a Comment

Please register or log in to leave a comment.