Re: Problems Backing Up

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Dooza (steve_at_whatareyoudooza.tv)
Date: 09/23/04 

Date: Thu, 23 Sep 2004 13:18:18 +0100

Hi Tibor,
I dont currently have anti-virus on this server, so it cant be that. The
problem is that the backup file isnt being genereated, and for some reason
SQL thinks it has, so when it goes to verify its not there.

Thanks for all your help, I am sure there must be a simple answer to this.

Steve

"Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote in
message news:%23EuPvVWoEHA.3792@TK2MSFTNGP11.phx.gbl...
> My guess is that the verify fail because of some other process is using
the file. Probably some
> anti-virus process. Also, the VERIFY option isn't exactly what is sounds
like. I suggest you read
> about it in Books Online...
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
>
> "Dooza" <steve@whatareyoudooza.tv> wrote in message
news:%23n29qlVoEHA.2920@TK2MSFTNGP10.phx.gbl...
> > Hi Tibor,
> > Ok that makes sense.
> >
> > This morning I did a manual backup, the filename I used is
> > \dmc_db_200409232100.BAK. I then did this in QA: RESTORE VERIFYONLY FROM
> > DISK =
> > 'C:\MSSQL7\BACKUP\dmc\dmc_db_200409232100.BAK'
> >
> > And it returned: The backup set is valid.
> >
> > Why can I manually backup and verify yet it cant?
> >
> > My daily backup backsup 3 databases, 2 fail on the verify. I also have a
> > weekly backup for other databases, some of the larger ones also fail on
the
> > verify. This really needs to be rectified, so any help to solve this
would
> > be great.
> >
> > Steve
> >
> > "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote
in
> > message news:eAz3xTVoEHA.1272@TK2MSFTNGP09.phx.gbl...
> > > > Can
> > > > anyone explain how the file is named? Whats the 2100 all about at
the
> > end?
> > >
> > > Year, date and time:
> > > YYYYMMDDhhmm
> > >
> > > --
> > > Tibor Karaszi, SQL Server MVP
> > > http://www.karaszi.com/sqlserver/default.asp
> > > http://www.solidqualitylearning.com/
> > >
> > >
> > > "Dooza" <steve@whatareyoudooza.tv> wrote in message
> > news:u9LBrCVoEHA.896@TK2MSFTNGP12.phx.gbl...
> > > > Still didnt work. This is what happened:
> > > >
> > > > [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201:
[Microsoft][ODBC
> > SQL
> > > > Server Driver][SQL Server]Cannot open backup device
> > > > 'C:\MSSQL7\BACKUP\dmc\dmc_db_200409222100.BAK'. Device error or
device
> > > > off-line. See the SQL Server error log for more details.
> > > > [Microsoft][ODBC SQL Server Driver][SQL Server]Backup or restore
> > operation
> > > > terminating abnormally.
> > > >
> > > > But then I am not surprised as the filename its expecting doesnt
exist.
> > Can
> > > > anyone explain how the file is named? Whats the 2100 all about at
the
> > end?
> > > >
> > > > Steve
> > > >
> > > > "Dooza" <steve@whatareyoudooza.tv> wrote in message
> > > > news:O9iiHFMoEHA.868@TK2MSFTNGP10.phx.gbl...
> > > > > Hi Tibor,
> > > > > After googling I found that it was because I was adding a second
file
> > to
> > > > the
> > > > > backup media set, once I had removed the first file it would let
me
> > backup
> > > > > the database. I created the file with todays date, so tonight I
will
> > see
> > > > if
> > > > > the backup set works succesfully and verifies too.
> > > > >
> > > > > Steve
> > > > >
> > > > > "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com>
> > wrote
> > > > in
> > > > > message news:eKMGLCMoEHA.708@TK2MSFTNGP09.phx.gbl...
> > > > > > The message states that you have tried to perform a striped
backup
> > > > against
> > > > > this file. Use what the
> > > > > > error say, add the FORMAT option to the backup command, this
will
> > remove
> > > > > this striping information
> > > > > > and let you use the file as a single backup file again.
> > > > > >
> > > > > > --
> > > > > > Tibor Karaszi, SQL Server MVP
> > > > > > http://www.karaszi.com/sqlserver/default.asp
> > > > > > http://www.solidqualitylearning.com/
> > > > > >
> > > > > >
> > > > > > "Dooza" <steve@whatareyoudooza.tv> wrote in message
> > > > > news:%23Bh9W7LoEHA.800@TK2MSFTNGP14.phx.gbl...
> > > > > > >I just tried to do a manual backup from Enterprise Manager, and
> > this
> > > > time
> > > > > I
> > > > > > > tried to add a new backup destination but when I ran the
backup I
> > got
> > > > > this
> > > > > > > error:
> > > > > > >
> > > > > > > The colume on decive
> > 'C:\MSSQL7\BACKUP\dmc\dmc_db_200402230200.BAK' is
> > > > > not
> > > > > > > part of a multifamily (RAID) media set. Use WITH FORMAT to
form a
> > new
> > > > > RAID
> > > > > > > set. Backup or restore operation terminating abnormally.
> > > > > > >
> > > > > > > The server does have a RAID array and the C: drive is
formatted
> > > > > correctly.
> > > > > > > What does this error mean?
> > > > > > >
> > > > > > > Steve
> > > > > > >
> > > > > > > "Dooza" <steve@whatareyoudooza.tv> wrote in message
> > > > > > > news:%23ShRMzLoEHA.2684@TK2MSFTNGP11.phx.gbl...
> > > > > > >> Hi Hari,
> > > > > > >> For some reason the database backup file isnt being created
even
> > tho
> > > > it
> > > > > > >> shows the backup as succesful. It reports that it took 33
seconds
> > to
> > > > > > > backup
> > > > > > >> the database which is over 900Mb in size! Any ideas why it
> > wouldnt
> > > > > create
> > > > > > >> the backup file and not report the error?
> > > > > > >>
> > > > > > >> Steve
> > > > > > >>
> > > > > > >> "Hari Prasad" <HariPrasad@discussions.microsoft.com> wrote in
> > message
> > > > > > >> news:F6A0B1B1-73C9-4DF5-8F1F-EBB0A984E444@microsoft.com...
> > > > > > >> > Hi,
> > > > > > >> >
> > > > > > >> > The issue normally comes incase if the backup file is not
> > available
> > > > > or
> > > > > > >> locked.
> > > > > > >> > I have faced this type of errors because of antivirus
software
> > ?
> > > > > > >> > By turning off the checks in SQL Server folders problem was
> > solved.
> > > > > > >> > Other probabily might be some scheduled jobs tring to copy
the
> > file
> > > > > to a
> > > > > > >> > different location. Check this as well.
> > > > > > >> >
> > > > > > >> > As peter sugegsted execute the Verifyonly option as well.
> > > > > > >> >
> > > > > > >> > Thanks
> > > > > > >> > Hari
> > > > > > >> > MCDBA
> > > > > > >> >
> > > > > > >> >
> > > > > > >> > "Dooza" wrote:
> > > > > > >> >
> > > > > > >> > > Hi there,
> > > > > > >> > > I have a daily backup running in SQL7 Server, and it
> > completes
> > > > the
> > > > > > >> backup,
> > > > > > >> > > but fails on the Verification. These are the error logs I
am
> > > > > getting.
> > > > > > >> Surely
> > > > > > >> > > it should create the backup file if it cant find it? Can
> > anyone
> > > > > give
> > > > > > > me
> > > > > > >> some
> > > > > > >> > > help?
> > > > > > >> > >
> > > > > > >> > > Steve
> > > > > > >> > >
> > > > > > >> > > 2004-09-20 23:00:43.67 kernel
BackupDiskFile::OpenMedia:
> > Backup
> > > > > > > device
> > > > > > >> > > 'C:\MSSQL7\BACKUP\dmc\dmc_db_200409202300.BAK' failed to
> > open.
> > > > > > > Operating
> > > > > > >> > > system error = 2(The system cannot find the file
specified.).
> > > > > > >> > > 2004-09-20 23:00:50.96 kernel
BackupDiskFile::OpenMedia:
> > Backup
> > > > > > > device
> > > > > > >> > > 'C:\MSSQL7\BACKUP\forums\forums_db_200409202300.BAK'
failed
> > to
> > > > > open.
> > > > > > >> > > Operating system error = 2(The system cannot find the
file
> > > > > > > specified.).
> > > > > > >> > > 2004-09-20 23:00:57.21 backup Database backed up with
> > following
> > > > > > >> > > information: Database: store, creation date and time:
> > > > > > >> 2001/04/12(10:59:40),
> > > > > > >> > > pages dumped: 1958, first LSN: 1374:290:10, last LSN:
> > 1374:294:1,
> > > > > sort
> > > > > > >> > > order: 52, striped: 0, number of dump devices: 1, device
> > > > > information:
> > > > > > >> > > (FILE=1, TYPE=DISK:
> > > > > > >> {'C:\MSSQL7\BACKUP\store\store_db_200409202300.BAK'}).
> > > > > > >> > > 2004-09-21 00:00:20.09 kernel
BackupDiskFile::OpenMedia:
> > Backup
> > > > > > > device
> > > > > > >> > > 'C:\MSSQL7\BACKUP\forums\forums_tlog_200409210000.TRN'
failed
> > to
> > > > > open.
> > > > > > >> > > Operating system error = 2(The system cannot find the
file
> > > > > > > specified.).
> > > > > > >> > > 2004-09-21 00:00:21.45 backup Log backed up with
following
> > > > > > >> information:
> > > > > > >> > > Database: store, creation date and time:
> > 2001/04/12(10:59:40),
> > > > > first
> > > > > > >> LSN:
> > > > > > >> > > 1373:482:1, last LSN: 1374:301:1, striped: 0, number of
dump
> > > > > devices:
> > > > > > > 1,
> > > > > > >> > > device information: (FILE=1, TYPE=DISK:
> > > > > > >> > > {'C:\MSSQL7\BACKUP\store\store_tlog_200409210000.TRN'}).
> > > > > > >> > > 2004-09-21 23:00:44.56 kernel
BackupDiskFile::OpenMedia:
> > Backup
> > > > > > > device
> > > > > > >> > > 'C:\MSSQL7\BACKUP\dmc\dmc_db_200409212300.BAK' failed to
> > open.
> > > > > > > Operating
> > > > > > >> > > system error = 2(The system cannot find the file
specified.).
> > > > > > >> > > 2004-09-21 23:00:53.51 kernel
BackupDiskFile::OpenMedia:
> > Backup
> > > > > > > device
> > > > > > >> > > 'C:\MSSQL7\BACKUP\forums\forums_db_200409212300.BAK'
failed
> > to
> > > > > open.
> > > > > > >> > > Operating system error = 2(The system cannot find the
file
> > > > > > > specified.).
> > > > > > >> > > 2004-09-21 23:00:59.92 kernel
BackupDiskFile::OpenMedia:
> > Backup
> > > > > > > device
> > > > > > >> > > 'C:\MSSQL7\BACKUP\store\store_db_200409212300.BAK' failed
to
> > > > open.
> > > > > > >> Operating
> > > > > > >> > > system error = 2(The system cannot find the file
specified.).
> > > > > > >> > > 2004-09-22 00:00:15.93 kernel
BackupDiskFile::OpenMedia:
> > Backup
> > > > > > > device
> > > > > > >> > > 'C:\MSSQL7\BACKUP\forums\forums_tlog_200409220000.TRN'
failed
> > to
> > > > > open.
> > > > > > >> > > Operating system error = 2(The system cannot find the
file
> > > > > > > specified.).
> > > > > > >> > >
> > > > > > >> > >
> > > > > > >> > >
> > > > > > >>
> > > > > > >>
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: Verify Fails in SBS 2003 NTBackup
    ... And what happens if you run either a Backup Now from within the Backup ... Wizard in Server Management ... > on the verify process. ... > Cleaned tapes, even tried new tapes. ...
    (microsoft.public.windows.server.sbs)
  • RE: SBS Server Freezes after backup completes
    ... then backup with verify option to see how everything is going. ... 830575 Backup fails on a computer that is running Small Business Server ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • Re: verifying bkf files
    ... I have a central server where all other servers backup the files to, and i would like to once and a while just test the backups there. ... does a verify pass automatically during SBS backup. ... Steve Foster [SBS MVP] ...
    (microsoft.public.windows.server.sbs)
  • Re: Exchange 2003 Backup
    ... It is because you are backing up the store then the transaction logs. ... verify won't get to the transaction logs as they have been committed. ... Active backup destination: File ... Folder CHEESE\Microsoft Information Store\First Storage Group\Mailbox ...
    (microsoft.public.exchange2000.general)
  • Re: SBS backup failing, but is it?
    ... Tell us about the backup device and media? ... won't be able to restore those tapes. ... Even if a test restore works flawlessly, turning off verify is definitely ... > device reported an error on a request to read data from media. ...
    (microsoft.public.windows.server.sbs)