Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

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

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.

Comments

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.