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 |
|
2revup
Posting Yak Master
112 Posts |
 Posted - 2007-03-05 : 17:37:52
|
| Ok in SQL 2000 this is within the maintaince plan, where as i have to create a seprate one for sql 2005 being i assume the 'clean up history' I choose the backup andrestore option choose 2 weeks and then run the job once created it runs sucssessfully but yet it dosnt delete a thing. I have backups going back almost 2 months now.What on earth am i not doing?Thanks in advanced |
|
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
Posted - 2007-03-05 : 20:41:21
|
| I ran into a similar problem. remember, at the bottom of the screen, it gives you the option to specify the extension. make sure, you do not put a DOT "." before the extension, which is usually bak or trn. example in that box, mention bak not .bak or trn not .trnHope I confused you completely....If you do not get it, let us know I can post a picture. |
 |
|
|
2revup
Posting Yak Master
112 Posts |
Posted - 2007-03-05 : 21:36:25
|
| I understand what you are saying but i still cant find anywhere, where i can eneter the .bak to trn ext. i have tried modifying the maintaince task and also the job. Both i cant find anything.I also looked when recreating a new maintaince task wizrd.a picture might be very helpful if you could please |
|
|
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
|
|
2revup
Posting Yak Master
112 Posts |
Posted - 2007-03-05 : 23:12:00
|
| downloaded thanks a million |
|
|
|
2revup
Posting Yak Master
112 Posts |
Posted - 2007-03-05 : 23:20:08
|
| aslo found the screen, i did everything but the double click when desgining the task without the wizard. Also it says 'search folder and del files on an extension' great i put the bak in and then i have to browse the location problem is i have about 60 subfolders under the backup folder (where all the other bak files are stored) can use a wildcard entry if so what is it none of the obvious are working.Thanks |
|
|
|
2revup
Posting Yak Master
112 Posts |
Posted - 2007-03-05 : 23:43:10
|
| found out i need sp1 for the subfolders...Very stupid on MS's part Thanks |
|
|
|
|
|
|
delete backup files older then...