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 |
|
rohitmathur11
Yak Posting Veteran
77 Posts |
 Posted - 2010-04-08 : 01:33:57
|
| Hi,I scheduled transaction log backup every 15 min . Now i want to delete 1 day old files because i am taking bk currentt files in to tape also.How can i schedule job to delete OS files older then one day ..like in linux we can use crontab ...my database is SQL Server 2008 and OS is Windows 2005 .any idea.. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
rohitmathur11
Yak Posting Veteran
77 Posts |
Posted - 2010-04-09 : 01:49:39
|
| Hi,Thanks for reply..I create a maintaince plan ..for taking transaction log backup every after 15 min. , then i schedule this in job scheduler in sql server management studio..Now this job is creating files in specified locaton ...i want to delete files older then one day because from this location we are taking tape backup .So,how can i create a job to delete files older then one day ..like in Oracle we can use crontab .. to schedule any script and find,mtime command on linux to find files .. . .Any idea.. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
franco
Constraint Violating Yak Guru
255 Posts |
Posted - 2010-04-13 : 08:33:20
|
| I don't know if there are differences but on the 180-day evaluation SQL Server 2008 version,there isn't this options like it was present in SQL Server 2000.For what I have understood you have to automate a SSIS Package by using SQL Server Agent in order to perform the Maintenance Cleanup Tasks.You can find additional information and a video that explain all that stuff at the following link:http://msdn.microsoft.com/en-us/library/dd440761.aspxFranco |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
franco
Constraint Violating Yak Guru
255 Posts |
Posted - 2010-04-14 : 02:16:22
|
| You are welcome.Franco |
|
|
|
|
|
|
Transaction Log files