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 |
|
Mikehjun
Starting Member
24 Posts |
 Posted - 2010-10-05 : 12:44:17
|
| Hi Folks,I just took over some SQL admin task lately and noticed that there is one database has been backup everyday at 5:30 am. However I looked at the list of jobs and all backup jobs are disable on this this server and there are no backup maintenace plan set up to run.I also look at the stored procedure and there are nothing there either.Is there any other places that I look into to find out what create this backup file everyday?Thanks,Mike |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Mikehjun
Starting Member
24 Posts |
Posted - 2010-10-05 : 13:17:53
|
| I looked at the log and there are message like below;date: 10/05/2010 5:30:13Source: BackupMessage: Database backed up. Database:GIS, create date/time 2009/03/01, pages dumped:24886first LSN: 384:101:283<c/> last LSN: 384:217:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'D:\MSSQL10.MSSQLSERVER\MSSQL\Backup\GIS\GIS_backup_2010_10_05_053011_0960682.bak'}). This is an informational message only. No user action is required.Any idea where it got created from?Thanks, |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Who create backup file?