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 |
|
GS1
Starting Member
27 Posts |
 Posted - 2004-04-07 : 07:25:19
|
| HiI am having a weird problem with a phantom backup running on several dbs on my sql server - the backup runs just after 4am each morning and does not appear in my list of jobs - here is an excerpt from the logs:Database backed up with following information: Database: master, creation date and time: 2004/04/01(10:18:15), pages dumped: 1243, first LSN: 102:23:1, last LSN: 102:25:1, sort order: 54, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\master.16'}).this also happens for model and msdb etc. the directory 'E:\master.16' doesn't exist though?Can anyone tell me where else I can check? The problem is that these phantom backups appear to be corrupt and mess with my scheduled backups...ThanksG |
|
|
GS1
Starting Member
27 Posts |
Posted - 2004-04-07 : 07:55:24
|
| Well it looks like another case of lack of communication - apparently someone here installed some remote backup software that backs up some databases remotely, and it looks like enterprise manager is picking these up... |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-04-07 : 09:00:25
|
| :) The backups exec sql server agents actually use the SQL Server agent to do their backup. DOH.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
Phantom Db backup