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

BACKUP Expand / Collapse
Author
Message
Posted Thursday, August 7, 2014 1:16 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, August 8, 2014 4:36 PM
Points: 10, Visits: 18
i'm taking a full DB backup it is very huge and it is takes around 24 hrs. after taking the 23 hrs suddenly my system shut down. so in that case again i have to take backup and wait for 24 hrs or Is there any alternative ???
Post #1600844
Posted Thursday, August 7, 2014 1:22 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 10:17 PM
Points: 17,817, Visits: 15,744
How big is the backup?

Are you backing up locally or across the network?

Are you compressing the backup?

Are you striping the backup?

All of these things can affect the speed of the backup.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1600849
Posted Thursday, August 7, 2014 1:26 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, August 8, 2014 4:36 PM
Points: 10, Visits: 18
hi
i am not taking this in real time, just i raised a question in this situation what we will do, will u plzz suggest me
Post #1600851
Posted Thursday, August 7, 2014 1:41 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 10:17 PM
Points: 17,817, Visits: 15,744
Take the backup and let it complete.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1600861
Posted Thursday, August 7, 2014 2:13 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 2:36 PM
Points: 457, Visits: 1,471
24 hours? Your database must be well over 1 TB or your hardware is very outdated.

If you compress backup, try to estimate its size + 20%, make sure that you have enough space to hold backup file. This is most likely the reason why your backup failed at the end.

Monitor backup progress from sys.dm_exec_requests view.

For future: partition your database, set old partitions to read-only, make one full backup, and then do partial backups on read-write filegroups. This will drastically reduce your backup space, time, resources.
Post #1600873
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse