Hi,
I need to delete all backups that are more than a day old . When I set-up a new maintenance plan using "Maintenance Plan Wizard", I don't get an option to retain backups only for "1" day... can you tell me where I should be setting this up? In a SQL 2000, this option was available... Thanks!
Which edition and version are you using?Hi,
I need to delete all backups that are more than a day old . When I set-up a new maintenance plan using "Maintenance Plan Wizard", I don't get an option to retain backups only for "1" day... can you tell me where I should be setting this up? In a SQL 2000, this option was available... Thanks!
Which edition and version are you using?Hi,
I need to delete all backups that are more than a day old . When I set-up a new maintenance plan using "Maintenance Plan Wizard", I don't get an option to retain backups only for "1" day... can you tell me where I should be setting this up? In a SQL 2000, this option was available... Thanks!
Which edition and version are you using?you have two options one is Database mirroring and other is log shipping in sql 2005..........but i advise you to go with db mirroring as the downtime is less in high availability mode as you have a witness server and hence the failover will be automatic and within few seconds............but in log shipping only manual failover is possible........refer,
http://dumthata.com/sqlchn/articles/dbmrr.htm
http://dumthata.com/sqlchn/articles/lship.htm
Going forward pls post in the appropriate forum as it would be easier to read through and answer....
Our database is more than 20,000,000 bytes and increase largely everyday
who can give me some advise about stable backup?
My database is sqlserver2005 and now i use files to backup including full backup and diff backup,whether is better to use device?
any ideas? thanks in advance
Your backup plan will depend on your recovery point objective (RPO) and recovery time objective (RTO). How long should it take for you to restore your databases should a disaster strikes? How critical is your data and from when do you need to have your data restore? You should also look at your database recovery model as this will affect your RPO and RTO.|||
thanks in advance,however RPO and RTO seem a little different for me,can u give me some details about that? and any ideas about what i did now
1.I first set up maintenace plan ,backup full and diff database to files and specify schedule
2.set up a job,type is ssis and package is from "maintencace plan/***" and specify schedule same with backup plan
two issues:
1.whether i need to backup transaction log in maintenace plan?
2.what's the difference backup to files and backup devices? which is better?
I think if i write T-SQL script in job and backup database to device, looks simple,is it right?
any ideas about thisT-SQL script?
much appreciate
|||
Hi Andrew,
RTO is the maximum amount of time that the service can be unavailable whereas RPO is the maximum amound of data that can be lost following a disaster. So, your requirements may be to have the service back up and serving clients within 2 hours following a hardware disaster (RTO), but you could afford to lose 1 full day's worth of data because, for instance, it's easily reproduced (RPO).
Define your RPO and RTO requirements first, then a stable, suitable backup plan can be created to meet the RPO requirement. Although your chosen backup strategy will contribute to meeting your RTO objective, RTO is usually fulfilled via high-availability options such as clustering, mirroring, offsite dr etc. (assuming, of course, that your RTO dictates a high-availability solution!)
For an example, you could define a daily full backup job at 00:00, followed by a tran log backup job every 15 minutes. This would give you an RPO of 15 minutes.
Cheers,
Rob
|||much appreciate for all
I want to set a full and differential backup to one database in sql server 2000.
Is there a way to set both full and differential to just one database.
i want the full backup weekly once and differential every day to set up.
Please let me know
Yes it is possible to set as you said........you can schedule it as a 2 seperate jobs.......one job will take diferential backups from mon-sat and other will take full backup on sunday........you can schedule as per your desire on any day........
i just gave a sample........refer the below link,
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx#ELYAG
|||
Hi,
It *depends* upon the requirement, but in general its good to have
Weekly Full backup
Daily Differential Backup
Half Hourly/ Hourly (depends upto size of your db) t-log backup , so that you can recover your database point-in-time
Here are some good article for your referrence
http://www.dbazine.com/sql/sql-articles/larsen12
http://support.microsoft.com/kb/329833
http://search.techrepublic.com.com/search/Backup+and+Microsoft+SQL+Server+and+strategy.html
I want to set a full and differential backup to one database in sql server 2000.
Is there a way to set both full and differential to just one database.
i want the full backup weekly once and differential every day to set up.
Please let me know
Yes it is possible to set as you said........you can schedule it as a 2 seperate jobs.......one job will take diferential backups from mon-sat and other will take full backup on sunday........you can schedule as per your desire on any day........ i just gave a sample........refer the below link,
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx#ELYAG
|||
Hi,
It *depends* upon the requirement, but in general its good to have
Weekly Full backup
Daily Differential Backup
Half Hourly/ Hourly (depends upto size of your db) t-log backup , so that you can recover your database point-in-time
Here are some good article for your referrence
http://www.dbazine.com/sql/sql-articles/larsen12
http://support.microsoft.com/kb/329833
http://search.techrepublic.com.com/search/Backup+and+Microsoft+SQL+Server+and+strategy.html
