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 |
|
cfli1688c1
Starting Member
3 Posts |
 Posted - 2011-10-14 : 09:29:25
|
| I have 2008 db. In the logs I see there is a transaction log backup job running at 12:30am. But, I do not see this job in the mgmt studio.I need to make changes to this job, where can I find it? thx |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-10-14 : 09:55:51
|
| Might not be running from the agent (or not on that server).Are you sa? Could be that you can't see the job as you don't own it.Could be patr of an ssis package.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Cindyaz
Yak Posting Veteran
73 Posts |
Posted - 2011-10-14 : 09:56:12
|
| Are you checking under sql Server Agent>Jobs? If it's not present there, check out your windows scheduler or any third party scheduler that you may have. |
|
|
|
cfli1688c1
Starting Member
3 Posts |
Posted - 2011-10-14 : 10:18:47
|
| I am login as sysadmin. I checked everywhere: windows scheduler, maintenance plan, legacy - db maintenance plan nowhere to be found... |
|
|
|
chris_cs
Posting Yak Master
223 Posts |
Posted - 2011-10-14 : 10:23:50
|
| Then you must have a 3rd party product performing the backups?----------------------------Junior DBA learning the ropes |
|
|
|
|
|
|
missing tlog backup job