Weird Backup DB Problems in SQL Server 7

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • jwbeaty
    #1

    Weird Backup DB Problems in SQL Server 7

    Here's a weird one.

    I'm running SQL Server 7 and when I run a backup something weird
    happens. When I perform the backup via Enterprise Manager by right
    clicking on the database I want to backup, I click on OK but no
    progress blocks show up in the window showing you the status of the
    backup. The completion window pops up saying that the DB has been
    backed up. OK--Fine, maybe the backup is really quick. Then, through
    Explorer, I look at the directory where the database backup is placed.
    It reads 0 KB - but - about a minute later the the size of the backup
    changes to the correct size. Seems strange, wouldn't the "completed"
    window show up after the backup is out there??

    Well, to make matters a little more interesting, when I define this
    one database in a maintenance plan, the plan will complete but no
    backup is present! The log file shows it runs OK - and - when I run
    the plan through query analyser it says OK, too. But, no backup is
    present.

    What gives?
    Tags: None
    • Greg D. Moore \(Strider\)
      #2
      Re: Weird Backup DB Problems in SQL Server 7


      "jwbeaty" <jwbeaty@swbell .net> wrote in message
      news:3f7bb8c0.0 311252038.73185 686@posting.goo gle.com...[color=blue]
      > Here's a weird one.
      >
      > I'm running SQL Server 7 and when I run a backup something weird
      > happens. When I perform the backup via Enterprise Manager by right
      > clicking on the database I want to backup, I click on OK but no
      > progress blocks show up in the window showing you the status of the
      > backup. The completion window pops up saying that the DB has been
      > backed up. OK--Fine, maybe the backup is really quick. Then, through
      > Explorer, I look at the directory where the database backup is placed.
      > It reads 0 KB - but - about a minute later the the size of the backup
      > changes to the correct size. Seems strange, wouldn't the "completed"
      > window show up after the backup is out there??
      >
      > Well, to make matters a little more interesting, when I define this
      > one database in a maintenance plan, the plan will complete but no
      > backup is present! The log file shows it runs OK - and - when I run
      > the plan through query analyser it says OK, too. But, no backup is
      > present.[/color]

      Can you script out what you are doing and show where your backups are going
      (or at least where you think they are going. :-)

      [color=blue]
      >
      > What gives?[/color]


        Comment

        • jwbeaty
          #3
          Re: Weird Backup DB Problems in SQL Server 7

          "Greg D. Moore \(Strider\)" <mooregr@greenm s.com> wrote in message news:<KjWwb.144 039$ji3.64826@t wister.nyroc.rr .com>...[color=blue]
          > "jwbeaty" <jwbeaty@swbell .net> wrote in message
          > news:3f7bb8c0.0 311252038.73185 686@posting.goo gle.com...[color=green]
          > > Here's a weird one.
          > >
          > > I'm running SQL Server 7 and when I run a backup something weird
          > > happens. When I perform the backup via Enterprise Manager by right
          > > clicking on the database I want to backup, I click on OK but no
          > > progress blocks show up in the window showing you the status of the
          > > backup. The completion window pops up saying that the DB has been
          > > backed up. OK--Fine, maybe the backup is really quick. Then, through
          > > Explorer, I look at the directory where the database backup is placed.
          > > It reads 0 KB - but - about a minute later the the size of the backup
          > > changes to the correct size. Seems strange, wouldn't the "completed"
          > > window show up after the backup is out there??
          > >
          > > Well, to make matters a little more interesting, when I define this
          > > one database in a maintenance plan, the plan will complete but no
          > > backup is present! The log file shows it runs OK - and - when I run
          > > the plan through query analyser it says OK, too. But, no backup is
          > > present.[/color]
          >
          > Can you script out what you are doing and show where your backups are going
          > (or at least where you think they are going. :-)
          >
          >[color=green]
          > >
          > > What gives?[/color][/color]

          Sure. Here's the generated backup maintenance plan:

          EXECUTE master.dbo.xp_s qlmaint N'-PlanID
          3096F3E1-111C-47AE-A34B-265DA966360C -Rpt "D:\MSSQL7\LOG\ Backup FOO_DB
          Database4.txt" -WriteHistory -VrfyBackup -BkUpMedia DISK -BkUpDB
          "D:\MSSQL7\BACK UP" -DelBkUps 3DAYS -BkExt "BAK"'

          I ran it manually under Query Analyzer and it generates a 0 KB file in
          the directory D:\MSSQL7\BACKU P then the 0 KB file vanishes--BUT, the
          logfile says the job ran without error. It only does this on one
          database. All other database maintenance plans run fine. If I run a
          BACKUP DATABASE command from analyzer, it runs OK.

          I just worked around this by creating a BACKUP sql statement in a job.
          DBCC CHECKDB on the database shows nothing out of the ordinary (no
          errors, etc.)

          Anyway, I will be doing some more research on this. If I find out
          anything I will post it here. If anyone has ever seen this scenario
          before, let me know.

          Thanks all.

            Comment

            Previous template Next
            Working...