backup strategy - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

backup strategy

Author

Topic

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-09-29 : 00:18:32

Dear Experts,
to my latest production environment, i've planned to implement like this.

Daily at midnight, a full backup
for every three hours, a differential backup
for every half-an-hour transactional backup.

now i'm at onsite to plan for this. now i'm asking your help

1)i need to go to maintenance plan wizard and set three different jobs ok i'l be doing this.

2) what about the disk size? it grows day by day. so how can i maintain the backup folder? how to set the expiry date or over write facility? please help me here and correct me where ever i'm wrong in this strategy.

Arnav
Even you learn 1%, Learn it with 100% confidence.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-09-29 : 08:50:57

You can use maintenance plan for it . In SQL 2005, you can do for differential backup as well. Use Maintenance plan (not wizard) to include Maintenance cleanup task to delete old backups. Or use Tara's Script to schedule backup and delete older bak files.

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-09-29 : 08:59:36

can i put the script as a job directly?

Arnav
Even you learn 1%, Learn it with 100% confidence.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-09-29 : 09:00:38

I have never used. You have to test and make sure you are satisfied and can schedule job in your prod server.

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-09-29 : 09:15:00

i've tested the isp_backup procedure and that worked greatly for me.

now i've several doubts. where can i create the procedures? i'd like to use isp_backup for full and log backups.
and isp_DeleteBackupHistory for deleting the history.
so please guide me where can i create the procedures?

Arnav
Even you learn 1%, Learn it with 100% confidence.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources