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 |
|
lw1990
Yak Posting Veteran
85 Posts |
 Posted - 2009-12-14 : 17:16:24
|
| I have a strange maintenance plans for SQL Server 2005. After the plan setup, the job was running successfully on schedule, (The Log File viewer shows: …The package executed successfully. The step succeeded.) But, I can NOT find the backup .trn at the directory that I set in the package. The directory I set was the default directory: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup, and I checked the “Create a sub-directory for each database”.After it runs many times, I still can’t find the .trn backup files.Does anybody know what the problem is in my setting or where the .trn file is?Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
lw1990
Yak Posting Veteran
85 Posts |
Posted - 2009-12-14 : 18:30:40
|
| Thanks Tara,You’re right, the backup jobs were not found in the Error Logs (Current – 12/14/2009 5:00PM). Even I right click on the job and select “Start Job at Step…” to manually run the job and it showed “Success 2 Total 0Error / 2 Success 0 Warning”, I still can’t see the job in the Error Logs.Why this one was not running at all? I’ve setup the maintenance plans for many times and all of them were setup same way. Even in the same database, the full database backup was running ok and the .bak files were created in the same directory. Should I delete the maintenance plan and create again or something you know that I didn’t setup correctly? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Where is the .trn backup files?