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

Compresses Backup Expand / Collapse
Author
Message
Posted Thursday, September 27, 2012 1:56 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 12, 2014 12:13 AM
Points: 258, Visits: 690
As the volume of data is less and Database is around 10 GB, here they prefer taking Full Backup on daily basis & then whne restoration is required they restore from that backup as required
My question is if we take a Compress backup on daily basis, can we restore it in similar way??

as the backup & restoration is done by Wizard...








************************************
Every Dog has a Tail !!!!!
Post #1365077
Posted Thursday, September 27, 2012 2:00 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, August 5, 2014 2:55 AM
Points: 1,101, Visits: 5,280
Yes. There is no change in restore.
Restore is same for compressed or normal backup.
Post #1365080
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse