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.
| Author |
Topic |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2008-09-29 : 02:35:12
|
| Dear all,as i'm scheduling for a full backup daily, what about the old backups? it grows day by day. is it need ot maintain manually? every three hours differential backup, and every halfanhour log backup.after the fullbackup, the previous backup sets will no more usable.so how can i maintain these?please help me hereArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
hitesh6221
Starting Member
28 Posts |
Posted - 2008-09-29 : 04:37:23
|
| if you are taking backup with plane you have to delete old file,if you want to have new file you have to delete old files and for that you have to create one batch file which delete old backup every.Backup Database DB to Disk = '<Path>\OSDB.bak'and save following files in Bat filecd "<Path>"del *.bak /Qor from backup task select Backup DBs across one or more files:Add Name and select "If Backup files exist: "OverwriteRegards,Hitesh Soni |
 |
|
|
lepeniotis
Yak Posting Veteran
75 Posts |
Posted - 2008-09-29 : 05:13:35
|
| You can Also use the clean up task if you have download the hotfix! You can schedule a job before the backup plan to check for older backups and according to how many days you want to keep select to delete the others.But you have to dowload the specific hotfix. If you don't you may schedule it to delete and if you check they will be there! Without notifications and warnings.Regards LepeniotisMSc Advanced Computing Science MSc Database ProfessionalSheffield Hallam UniversityMCP (70-229, 70-228)Industrial IT Engineer |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-29 : 08:29:25
|
| You can do through Maintenance plan with cleanup task or you can use Tara's script to do it efficiently. |
|
|
|
|
|
|
backup set