Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

how to protect the data loss with database snapshot Expand / Collapse
Author
Message
Posted Monday, November 18, 2013 10:35 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 5:15 AM
Points: 126, Visits: 234
I have database where continuous changes are happening I do take backups on regular interval bases and also take snapshot manually in between .but how to recover the data loss that can happen in between snapshots and regular backups.what is the best way to protect data then......
Post #1515425
Posted Monday, November 18, 2013 10:43 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 1:25 PM
Points: 23,396, Visits: 32,225
Start with a solid backup plan that you test regularly. Sounds like your database should be using the full recovery model and that your backup plan should use a combination of full and transaction log backups.

Then when and how these are run will depend on your RPO and RTO (Recovery Point Objective and Recovery Time Objective). These need to be established based on the needs of your business.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1515426
Posted Monday, November 18, 2013 10:43 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 5, 2014 6:19 AM
Points: 147, Visits: 591
there are many ways to handle this..

1. take regular log backups.
2. log shipping.
3. mirroring

hope this helps.




Praveen D'sa
MCITP - Database Administrator 2008
http://sqlerrors.wordpress.com
Post #1515427
Posted Monday, November 18, 2013 11:41 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 1:06 PM
Points: 43,007, Visits: 36,161
Snapshots are not primarily there to prevent data loss. Start with a good solid backup strategy, full and log backups.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1515433
Posted Friday, March 14, 2014 12:04 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, March 14, 2014 12:03 PM
Points: 1, Visits: 0
Hello, i have a suggestion for all of you who are looking to data protection services. I recommend everyone two-factor authentication ,
I have been using it and I am very satisfied with it. I also have some friends who've been using and they are very satisfied too. Cheers
Post #1551275
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse