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


Back up Schedulling


Back up Schedulling

Author
Message
saidapur_satish
saidapur_satish
SSC Veteran
SSC Veteran (218 reputation)SSC Veteran (218 reputation)SSC Veteran (218 reputation)SSC Veteran (218 reputation)SSC Veteran (218 reputation)SSC Veteran (218 reputation)SSC Veteran (218 reputation)SSC Veteran (218 reputation)

Group: General Forum Members
Points: 218 Visits: 66
Hi Ali,
1+TB data means not a jock..........
If you give the full backup means take too much time & also that time your server is down, so i suggest you...

1. Give the full backup on 1st saturday night....
2. Give difrencial backup on every night (in peak hour)
3. If your dava is very very importent then give transaction backup at every 4 hours becouse you telling your data is in TB.......

This is the best way to save & secure the data.....

Regards
Satish
grahamc
grahamc
SSCertifiable
SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)

Group: General Forum Members
Points: 6046 Visits: 1039
saidapur_satish (11/11/2010)
Hi Ali,
1+TB data means not a jock..........
If you give the full backup means take too much time & also that time your server is down, so i suggest you...

1. Give the full backup on 1st saturday night....
2. Give difrencial backup on every night (in peak hour)
3. If your dava is very very importent then give transaction backup at every 4 hours becouse you telling your data is in TB.......

This is the best way to save & secure the data.....

Regards
Satish


Whats a "jock"?

Why would the server be down during a backup??

As stated before, it all depends... many questions would need to be asked, including what the current storage looks like. You may have better options at a SAN level if you are running a SAN.

But generally, I would go for:

-Full backup when system is doing least amount of work (I stay away from weekends as that is when you should be doing other maintenance tasks)
-Diff backup every evening
-Log backups (frequency would be anywhere from 15 minutes to 60 depending on accept data loss)

Considering that you are only taking 1 full backup a week, I would want to be restoring this somewhere (applying diffs and logs as well) just to make sure.

As suggested earlier, splitting the DB up into separate filegroups would make your life a lot easier.
muthukkumaran Kaliyamoorthy
muthukkumaran Kaliyamoorthy
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16796 Visits: 5186
saidapur_satish (11/11/2010)
Hi Ali,
1+TB data means not a jock..........
If you give the full backup means take too much time & also that time your server is down, so i suggest you...

1. Give the full backup on 1st saturday night....
2. Give difrencial backup on every night (in peak hour)
3. If your dava is very very importent then give transaction backup at every 4 hours becouse you telling your data is in TB.......

This is the best way to save & secure the data.....

Regards
Satish


Satish the thing is its interview question ...

Edited :Spelling

Muthukkumaran Kaliyamoorthy

Helping SQL DBAs and Developers >>>SqlserverBlogForum

Ali Tailor
Ali Tailor
Hall of Fame
Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)

Group: General Forum Members
Points: 3285 Visits: 885
Thanks All,

I got the point , that I should keep the schedule as

On in weekend night Full backup
daily At night deff. backup
And depending on data loss Accepted, log backup(In minuts).

Ali
MCTS SQL Server2k8
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum









































































































































































SQLServerCentral


Search