Problems Backing Up

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.BA K' 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.T RN'}).
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.BA K' 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.).
What happens if you run the verification from within Query Analyzer e.g.
RESTORE VERIFYONLY FROM DISK =
'C:\MSSQL7\BACKUP\dmc\dmc_db_200409202300.BAK'
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backups? Use MiniSQLBackup Lite, free!
"Dooza" <steve@.whatareyoudooza.tv> wrote in message
news:eARlEILoEHA.3428@.TK2MSFTNGP11.phx.gbl...
> 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.BA K' 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.T RN'}).
> 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.BA K' 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.).
>
|||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.BA K' 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.T RN'}).
> 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.BA K' 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.).
>
>
|||Hi Peter,
Thank you for your time.
As I imagined the file does not exist. I get these results:
Server: Msg 3201, Level 16, State 2, Line 1
Cannot open backup device 'C:\MSSQL7\BACKUP\dmc\dmc_db_200409202300.BAK'.
Device error or device off-line. See the SQL Server error log for more
details.
Server: Msg 3013, Level 16, State 1, Line 1
Backup or restore operation terminating abnormally.
When I look at the Maintenance Plan History there is a tick by the backup
for this database, but a cross by the verify. It appears to be working, but
actually isnt as the backup file doesnt exist. Shouldnt it create the file?
Or is something else a foot? I only recently noticed that it wasnt working,
and have been able to do backups manually. The backup file is 900Mb in size,
which to me is huge, but the database does contain a hell of a lot of data.
Any ideas what I should be looking for next?
Steve
"Peter Yeoh" <nospam@.nospam.com> wrote in message
news:%23TfVygLoEHA.708@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> What happens if you run the verification from within Query Analyzer e.g.
> RESTORE VERIFYONLY FROM DISK =
> 'C:\MSSQL7\BACKUP\dmc\dmc_db_200409202300.BAK'
> --
> Peter Yeoh
> http://www.yohz.com
> Need smaller SQL2K backups? Use MiniSQLBackup Lite, free!
> "Dooza" <steve@.whatareyoudooza.tv> wrote in message
> news:eARlEILoEHA.3428@.TK2MSFTNGP11.phx.gbl...
backup,[vbcol=seagreen]
> Surely
> some
> 2001/04/12(10:59:40),
{'C:\MSSQL7\BACKUP\store\store_db_200409202300.BAK '}).[vbcol=seagreen]
information:[vbcol=seagreen]
LSN:
> Operating
>
|||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.[vbcol=seagreen]
> 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:
backup,[vbcol=seagreen]
Surely[vbcol=seagreen]
some[vbcol=seagreen]
2001/04/12(10:59:40),[vbcol=seagreen]
{'C:\MSSQL7\BACKUP\store\store_db_200409202300.BAK '}).[vbcol=seagreen]
information:[vbcol=seagreen]
LSN:[vbcol=seagreen]
Operating[vbcol=seagreen]
|||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[vbcol=seagreen]
> 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...
> locked.
> backup,
> Surely
me[vbcol=seagreen]
> some
device[vbcol=seagreen]
Operating[vbcol=seagreen]
device[vbcol=seagreen]
specified.).[vbcol=seagreen]
> 2001/04/12(10:59:40),
> {'C:\MSSQL7\BACKUP\store\store_db_200409202300.BAK '}).
device[vbcol=seagreen]
specified.).[vbcol=seagreen]
> information:
> LSN:
1,[vbcol=seagreen]
device[vbcol=seagreen]
Operating[vbcol=seagreen]
device[vbcol=seagreen]
specified.).[vbcol=seagreen]
device[vbcol=seagreen]
> Operating
device[vbcol=seagreen]
specified.).
>
|||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...
> backup
> me
> device
> Operating
> device
> specified.).
> device
> specified.).
> 1,
> device
> Operating
> device
> specified.).
> device
> device
> specified.).
>
|||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...[vbcol=seagreen]
I[vbcol=seagreen]
this[vbcol=seagreen]
not[vbcol=seagreen]
RAID[vbcol=seagreen]
correctly.[vbcol=seagreen]
create[vbcol=seagreen]
or[vbcol=seagreen]
to a[vbcol=seagreen]
getting.[vbcol=seagreen]
give[vbcol=seagreen]
open.[vbcol=seagreen]
sort[vbcol=seagreen]
information:[vbcol=seagreen]
open.[vbcol=seagreen]
first[vbcol=seagreen]
devices:[vbcol=seagreen]
open.[vbcol=seagreen]
open.
>
|||Hi,
Could you please execute the below comand from query analyzer:-
Backup database <dbname> to disk
='C:\MSSQL7\BACKUP\dmc\dmc_db_200402230200.BAK' with init,stats=10
and see what happends.
Thanks
Hari
MCDBA
"Dooza" wrote:

> 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...
> backup
> me
> device
> Operating
> device
> specified.).
> device
> specified.).
> 1,
> device
> Operating
> device
> specified.).
> device
> device
> specified.).
>
>
|||Hi Hari,
This is the results:
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionRead
(WrapperRead()).
[Microsoft][ODBC SQL Server Driver][Shared Memory]General network error.
Check your network documentation.
10 percent backed up.
Connection Broken
Steve
"Hari Prasad" <HariPrasad@.discussions.microsoft.com> wrote in message
news:1CC249AC-788F-490F-9D42-74CFFAD95C9B@.microsoft.com...[vbcol=seagreen]
> Hi,
> Could you please execute the below comand from query analyzer:-
> Backup database <dbname> to disk
> ='C:\MSSQL7\BACKUP\dmc\dmc_db_200402230200.BAK' with init,stats=10
> and see what happends.
> Thanks
> Hari
> MCDBA
>
> "Dooza" wrote:
time I[vbcol=seagreen]
this[vbcol=seagreen]
not[vbcol=seagreen]
RAID[vbcol=seagreen]
correctly.[vbcol=seagreen]
it[vbcol=seagreen]
create[vbcol=seagreen]
or[vbcol=seagreen]
to a[vbcol=seagreen]
getting.[vbcol=seagreen]
give[vbcol=seagreen]
open.[vbcol=seagreen]
sort[vbcol=seagreen]
information:[vbcol=seagreen]
open.[vbcol=seagreen]
first[vbcol=seagreen]
devices:[vbcol=seagreen]
open.[vbcol=seagreen]
open.[vbcol=seagreen]