Problems backing up SQL Express Database...

Hello,

I found some code below that works fine when I run it in my vb.net code in Design mode. When I publish the application, run the app and then execute the sub MyDbBackup() I get the following error: Cannot open backup device 'C:\dbBackup'. Operating system error 5(Access is denied). BACKUP DATABASE is terminating abnormally.

Here is the code that runs:

Public Sub MyDbBackup()
Dim sqlconn As New SqlClient.SqlConnection(MyConnectionStringdb)
sqlconn.Open()
Dim Backupcommand As SqlClient.SqlCommand = New SqlClient.SqlCommand("BACKUP DATABASE [" & sqlconn.Database.ToString & "] TO DISK = 'c:\myDataBaseBackup.bak'")
Backupcommand.CommandType = CommandType.Text
Backupcommand.Connection = sqlconn
Backupcommand.ExecuteNonQuery()
sqlconn.Close()
End Sub

2 Questions: Why does it backup fine in design mode, but not after it is published? Also, in design mode, my database is called TAP_Master.mdf but when I look under C:\Program Files\Microsoft\ SQL Server\MSSQL.1\MSSQL\Data, I do not see that database name... all I see is master.mdf, model, msdbdata etc... Is that database stored anywhere else?

I have set the MyConnectionStringdb variable to = "Data Source =.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\TAP_Master.mdf;Integrated Security=True;User Instance=True"

Thanks in advance.

You don't see your database in the Data directory because you embedded it in your application. The database is installed to the same location where you application is installed, which is an obfuscated path that is generated during ClickOnce installation. ClickOnce applications use a special type of instances of SQL Server called a User Instance to allow the database to be attached at runtime.

I'm not sure about the backup failure, I'll have to do a little more research. Is your published application on a different computer than the Dev box? I'm thinking it has something to do with a backup device that was created on the Dev box, but does not exist on the test box.

Mike

|||

Mike Wachal - MSFT wrote:

You don't see your database in the Data directory because you embedded it in your application. The database is installed to the same location where you application is installed, which is an obfuscated path that is generated during ClickOnce installation. ClickOnce applications use a special type of instances of SQL Server called a User Instance to allow the database to be attached at runtime.

I'm not sure about the backup failure, I'll have to do a little more research. Is your published application on a different computer than the Dev box? I'm thinking it has something to do with a backup device that was created on the Dev box, but does not exist on the test box.

Mike

Thanks for your reply. You are correct... My published application is on a different computer than my Dev box. If you can find out any additional info as to why I'm getting that error that would be great.

Also, I'll ask this question as well, Once the bak up file is created, what would be the best method to restore the .bak file to the machine that runs the published application.? I thought I could use the following code, but I receive the message, "Restore cannot process the database C"\Visual Studio\Projects\Prog\BIN\DEBUG\TAP_Master.MDF beause it is in use by this session. It is recommended that the master database be used when performing this operation":

Public Sub MyDbBackup()
Dim sqlconn As New SqlClient.SqlConnection(MyConnectionStringdb)
sqlconn.Open()
Dim Backupcommand As SqlClient.SqlCommand = New SqlClient.SqlCommand("RESTORE DATABASE [" & sqlconn.Database.ToString & "] FROM DISK = 'c:\myDataBaseBackup.bak'")
Backupcommand.CommandType = CommandType.Text
Backupcommand.Connection = sqlconn
Backupcommand.ExecuteNonQuery()
sqlconn.Close()
End Sub

Thanks in advance.

|||

Hi,

I guess that the user instance feature is not made for Backup and restore (with the emphasize on restore) because a restore will do a server attaching after the restoring which is not the sense of a user attached instance. Why don′t you take the MDF as a backup only ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Jens K. Suessmeyer wrote:

Hi,

... Why don′t you take the MDF as a backup only ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Hello, can you elaborate on that quote? How can I take only the MDF as a backup? Basically I want to be able to back up any saved data, and then be able to restore it in case of a system failure or a corrupted operating system.

Thanks for your replies all.

|||Just do a normal file copy when the database connection is closed, then you can easily attach it to a user instance again when the data is corrupt.

HTH, Jens K. Suessmeyer.

htttp://www.sqlserver2005.de

|||

Ok. This is what I have done. I opened my published app on my laptop, and then entered in some data. I closed my app, and then attempted to copy the master.mdf file from the C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data directory. At first I couldn't copy because SQL server express was still running. So I killed the services and copied the data.

I reinstalled my app, copied back the master.mdf into the C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data directory, and then launched the app. Now I do not see the data that I previously entered.

Am I understanding the File Copy / Attach to user instance concept correctly?

Thanks again for all your help.

|||No actually not, the database which has to be backup is your own database not the SQL Server internal ones. YOu will have to backup the MDF file of the database with the reference TAP_master.mdf you mentioned above.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

The reason you're seeing the backup error is that the user context running your app on the deployed system doesn't have Windows permissions to create a file in the root of the local C: drive. That's why it's different from your dev environment: Different machine, different permissions.

So, either point the backup to a known directory that you're guaranteed to have permission to write to on machines where you're deployed, or find a way to make sure that you have appropriate permissions to the root of C:.

On the restore, it's simply a matter that you can't overwrite a database while you have an active session attached to it. Your connection is that session. By setting focus to Master (use master) you're taking focus away from the database you're trying to restore, and it should work fine.

|||

Kevin Farlee wrote:

On the restore, it's simply a matter that you can't overwrite a database while you have an active session attached to it. Your connection is that session. By setting focus to Master (use master) you're taking focus away from the database you're trying to restore, and it should work fine.

Ok thanks...First issue resolved... Now with regards to the second issue, Where am I setting focus to the master from? Is it within Visual Studio design mode, or under SQL Server 2005 Surface Area Configuration?

Thanks.

|||

Rashar wrote:

Kevin Farlee wrote:

On the restore, it's simply a matter that you can't overwrite a database while you have an active session attached to it. Your connection is that session. By setting focus to Master (use master) you're taking focus away from the database you're trying to restore, and it should work fine.

Ok thanks...First issue resolved... Now with regards to the second issue, Where am I setting focus to the master from? Is it within Visual Studio design mode, or under SQL Server 2005 Surface Area Configuration?

Thanks.

The context information is session based, you can change the context from within your script (if you are using one, I am not sure from your explnation using the USE <DatabaseName> command. If you are in any GUI of SQL Management Studio, make sure that you are not residing on a database node in the treeview that you want to restore.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Problems backing up SQL DB.

Every time i try to back up a specific DB i get an error saying it can
not backup because the full text catalog is not permitted because it
is not online. It does not matter if i try to backup the db through
SQL of my Backup software. here is the sql log.

LogJob History (DB File level Backup.Subplan_1)

Step ID1
ServerServer Name
Job NameDB File level Backup.Subplan_1
Step NameSubplan_1
Duration00:00:01
Sql Severity0
Sql Message ID0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0

Message
Executed as user: Domain\USer. ...ecute Package Utility Version
9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All
rights reserved. Started: 7:07:43 AM Progress: 2007-06-01
07:07:44.14 Source: {B6285A6A-0066-416F-AD9F-F31ED5A68F14}
Executing query "DECLARE @.Guid UNIQUEIDENTIFIER EXECUTE
msdb..sp".: 100% complete End Progress Error: 2007-06-01
07:07:44.49 Code: 0xC002F210 Source: Back Up Database (Full)
Execute SQL Task Description: Executing the query "BACKUP DATABASE
[DBName] FILEGROUP = N'PRIMARY' TO DISK = N'E:\Program Files
\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\DBName_200706010707.ba k'
WITH NOFORMAT, NOINIT, NAME = N'DBName_backup_20070601070744', SKIP,
REWIND, NOUNLOAD, STATS = 10 " failed with the following error: "The
backup of full-text catalog 'ftcat_documentindex' is not permitted
because it is not online. Check errorlog file for the reason that full-
text catalog became offline and . The step failed.Bryan (bsockel@.gmail.com) writes:

Quote:

Originally Posted by

Every time i try to back up a specific DB i get an error saying it can
not backup because the full text catalog is not permitted because it
is not online. It does not matter if i try to backup the db through
SQL of my Backup software. here is the sql log.

Searching Books Online on "fulltext offline", I found this link:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqlerrm9/html/592bd03e-7f46-4b88-9bd0-
7a0b32cbfd58.htm

It seems that there is a chance that you find the answer there.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Problems Backing up database to a PC with 200GB drive

SQL Server 2000 on Windows 2000.
Is this possible. I try to create a new backup device and the only thing I
can locate is the local partitioned drives. I try to put in a UNC and it
does not work.
Is this not possible to put in a UNC to a shared drive on a PC. The backup
is needed to get off of the server because of space. We don't have a server
big enough to handle the size of the database.
Is it possible this is a a rights issue and I can't get off the server due
to rights. I have shared the heck out of the share on the PC.
Thanks for any help.
Gordon
I assume you tried mapping a drive letter to the share? I have a network
share mapped as a local drive letter "L:". I just did a backup from SQL2K to
"L:\backup\mydb.bak" using Enterprise Mgr. I added that path to the backup
device window in the backup dialog. What happens when you do this?
"Gordon" wrote:

> SQL Server 2000 on Windows 2000.
> Is this possible. I try to create a new backup device and the only thing I
> can locate is the local partitioned drives. I try to put in a UNC and it
> does not work.
> Is this not possible to put in a UNC to a shared drive on a PC. The backup
> is needed to get off of the server because of space. We don't have a server
> big enough to handle the size of the database.
> Is it possible this is a a rights issue and I can't get off the server due
> to rights. I have shared the heck out of the share on the PC.
> Thanks for any help.
> Gordon
|||I cannot see the share when I mapped it. When I go into the backup device
dialog, I can only see the partitioned drives. When I use a UNC to get to
anything else I get a message saying, "The backup device cannot see the
drive. Do you want to continue using this backup device."
Funny thing is, I tried this on another SQL server and I can get to the
shared drive on the PC. It is only on this server. Some setting somewhere.
All the rights are the same for the logged in account on both servers.
UGGGGHHHHH.
Thanks for any help you can give.
"kaborka" wrote:
[vbcol=seagreen]
> I assume you tried mapping a drive letter to the share? I have a network
> share mapped as a local drive letter "L:". I just did a backup from SQL2K to
> "L:\backup\mydb.bak" using Enterprise Mgr. I added that path to the backup
> device window in the backup dialog. What happens when you do this?
> "Gordon" wrote:
|||When a backup occurs, regardless of who is doing it the account that gets
used is the one that SQL Server is running under. THat account must be a
domain account with permissions to read and write to that share. UNC's are
the preferred way to backup to a remote share but you need the rght account
to access it.
Andrew J. Kelly SQL MVP
"Gordon" <Gordon@.discussions.microsoft.com> wrote in message
news:42BB3F1A-DCDC-471D-A221-2221304FE4F0@.microsoft.com...[vbcol=seagreen]
>I cannot see the share when I mapped it. When I go into the backup device
> dialog, I can only see the partitioned drives. When I use a UNC to get to
> anything else I get a message saying, "The backup device cannot see the
> drive. Do you want to continue using this backup device."
> Funny thing is, I tried this on another SQL server and I can get to the
> shared drive on the PC. It is only on this server. Some setting
> somewhere.
> All the rights are the same for the logged in account on both servers.
> UGGGGHHHHH.
> Thanks for any help you can give.
> "kaborka" wrote:

Problems Backing up database to a PC with 200GB drive

SQL Server 2000 on Windows 2000.
Is this possible. I try to create a new backup device and the only thing I
can locate is the local partitioned drives. I try to put in a UNC and it
does not work.
Is this not possible to put in a UNC to a shared drive on a PC. The backup
is needed to get off of the server because of space. We don't have a server
big enough to handle the size of the database.
Is it possible this is a a rights issue and I can't get off the server due
to rights. I have shared the heck out of the share on the PC.
Thanks for any help.
GordonI assume you tried mapping a drive letter to the share? I have a network
share mapped as a local drive letter "L:". I just did a backup from SQL2K t
o
"L:\backup\mydb.bak" using Enterprise Mgr. I added that path to the backup
device window in the backup dialog. What happens when you do this?
"Gordon" wrote:

> SQL Server 2000 on Windows 2000.
> Is this possible. I try to create a new backup device and the only thing
I
> can locate is the local partitioned drives. I try to put in a UNC and it
> does not work.
> Is this not possible to put in a UNC to a shared drive on a PC. The backu
p
> is needed to get off of the server because of space. We don't have a serv
er
> big enough to handle the size of the database.
> Is it possible this is a a rights issue and I can't get off the server due
> to rights. I have shared the heck out of the share on the PC.
> Thanks for any help.
> Gordon|||I cannot see the share when I mapped it. When I go into the backup device
dialog, I can only see the partitioned drives. When I use a UNC to get to
anything else I get a message saying, "The backup device cannot see the
drive. Do you want to continue using this backup device."
Funny thing is, I tried this on another SQL server and I can get to the
shared drive on the PC. It is only on this server. Some setting somewhere.
All the rights are the same for the logged in account on both servers.
UGGGGHHHHH.
Thanks for any help you can give.
"kaborka" wrote:
[vbcol=seagreen]
> I assume you tried mapping a drive letter to the share? I have a network
> share mapped as a local drive letter "L:". I just did a backup from SQL2K
to
> "L:\backup\mydb.bak" using Enterprise Mgr. I added that path to the backu
p
> device window in the backup dialog. What happens when you do this?
> "Gordon" wrote:
>|||When a backup occurs, regardless of who is doing it the account that gets
used is the one that SQL Server is running under. THat account must be a
domain account with permissions to read and write to that share. UNC's are
the preferred way to backup to a remote share but you need the rght account
to access it.
Andrew J. Kelly SQL MVP
"Gordon" <Gordon@.discussions.microsoft.com> wrote in message
news:42BB3F1A-DCDC-471D-A221-2221304FE4F0@.microsoft.com...[vbcol=seagreen]
>I cannot see the share when I mapped it. When I go into the backup device
> dialog, I can only see the partitioned drives. When I use a UNC to get to
> anything else I get a message saying, "The backup device cannot see the
> drive. Do you want to continue using this backup device."
> Funny thing is, I tried this on another SQL server and I can get to the
> shared drive on the PC. It is only on this server. Some setting
> somewhere.
> All the rights are the same for the logged in account on both servers.
> UGGGGHHHHH.
> Thanks for any help you can give.
> "kaborka" wrote:
>

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]

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.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.).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.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.).
>|||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...
> 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.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.).
> >
> >
>|||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.).
> >
> >
> >|||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.).
> > >
> > >
> > >
>|||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.).
>> > >
>> > >
>> > >
>>
>|||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.).
> >> > >
> >> > >
> >> > >
> >>
> >>
> >
> >
>|||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...
> 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...
> > > 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.).
> > > > >
> > > > >
> > > > >
> > >
> > >
> >
> >
> >|||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.).
> > >> > >
> > >> > >
> > >> > >
> > >>
> > >>
> > >
> > >
> >
> >
>|||> 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.).
> > > >> > >
> > > >> > >
> > > >> > >
> > > >>
> > > >>
> > > >
> > > >
> > >
> > >
> >
> >
>|||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.).
> > > > >> > >
> > > > >> > >
> > > > >> > >
> > > > >>
> > > > >>
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||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.).
>
>|||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...
> > 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.).
> > > >
> > > >
> > > >
> >
> >
>
>|||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.).
> > > > > >> > >
> > > > > >> > >
> > > > > >> > >
> > > > > >>
> > > > > >>
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||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.).
> > > > > > >> > >
> > > > > > >> > >
> > > > > > >> > >
> > > > > > >>
> > > > > > >>
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||Can you reproduce this by executing all the BACKUP (and possibly RESTORE) commands from QA? If so,
can you post those commands here?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Dooza" <steve@.whatareyoudooza.tv> wrote in message news:e3%23LzbWoEHA.1308@.TK2MSFTNGP14.phx.gbl...
> 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.).
> > > > > > > >> > >
> > > > > > > >> > >
> > > > > > > >> > >
> > > > > > > >>
> > > > > > > >>
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||Thats just it Tibor, when I do a manual backup in Enterprise Manager it
always works. I cant get it to fail, and I cant see a failure message, the
only way I know it has failed is because the file it tries to verify isnt
there.
What is the SQL for backing up in QA?
Steve
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eKcoEgWoEHA.2068@.TK2MSFTNGP09.phx.gbl...
> Can you reproduce this by executing all the BACKUP (and possibly RESTORE)
commands from QA? If so,
> can you post those commands here?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Dooza" <steve@.whatareyoudooza.tv> wrote in message
news:e3%23LzbWoEHA.1308@.TK2MSFTNGP14.phx.gbl...
> > 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.).
> > > > > > > > >> > >
> > > > > > > > >> > >
> > > > > > > > >> > >
> > > > > > > > >>
> > > > > > > > >>
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||Check out the BACKUP command.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Dooza" <steve@.whatareyoudooza.tv> wrote in message news:%23XVAY7WoEHA.3460@.tk2msftngp13.phx.gbl...
> Thats just it Tibor, when I do a manual backup in Enterprise Manager it
> always works. I cant get it to fail, and I cant see a failure message, the
> only way I know it has failed is because the file it tries to verify isnt
> there.
> What is the SQL for backing up in QA?
> Steve
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:eKcoEgWoEHA.2068@.TK2MSFTNGP09.phx.gbl...
> > Can you reproduce this by executing all the BACKUP (and possibly RESTORE)
> commands from QA? If so,
> > can you post those commands here?
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >
> >
> > "Dooza" <steve@.whatareyoudooza.tv> wrote in message
> news:e3%23LzbWoEHA.1308@.TK2MSFTNGP14.phx.gbl...
> > > 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.).
> > > > > > > > > >> > >
> > > > > > > > > >> > >
> > > > > > > > > >> > >
> > > > > > > > > >>
> > > > > > > > > >>
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||Hi Tibor,
I didnt have time last night to continue my exploration of the BACKUP
command, but I do have some odd news about the maintenance plan. Last night
the backup gave me this message:
The file C:\MSSQL7\BACKUP\dmc\dmc_db_200409232100.BAK already exists. This
backup command is ignored
It exists because I created a manual backup yesterday thinking that it would
make it work, seems I was wrong. So if the file isnt there it wont for some
reason create it, but it wont report that it hasnt either, but when the
verify runs it cant because the file isnt there, and thats when it reports
it missing.
Anyone have any ideas on this?
Cheers,
Steve
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eILB%23UXoEHA.1800@.TK2MSFTNGP15.phx.gbl...
> Check out the BACKUP command.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Dooza" <steve@.whatareyoudooza.tv> wrote in message
news:%23XVAY7WoEHA.3460@.tk2msftngp13.phx.gbl...
> > Thats just it Tibor, when I do a manual backup in Enterprise Manager it
> > always works. I cant get it to fail, and I cant see a failure message,
the
> > only way I know it has failed is because the file it tries to verify
isnt
> > there.
> >
> > What is the SQL for backing up in QA?
> >
> > Steve
> >
> > "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> > message news:eKcoEgWoEHA.2068@.TK2MSFTNGP09.phx.gbl...
> > > Can you reproduce this by executing all the BACKUP (and possibly
RESTORE)
> > commands from QA? If so,
> > > can you post those commands here?
> > >
> > > --
> > > Tibor Karaszi, SQL Server MVP
> > > http://www.karaszi.com/sqlserver/default.asp
> > > http://www.solidqualitylearning.com/
> > >
> > >
> > > "Dooza" <steve@.whatareyoudooza.tv> wrote in message
> > news:e3%23LzbWoEHA.1308@.TK2MSFTNGP14.phx.gbl...
> > > > 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.).
> > > > > > > > > > >> > >
> > > > > > > > > > >> > >
> > > > > > > > > > >> > >
> > > > > > > > > > >>
> > > > > > > > > > >>
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||> Anyone have any ideas on this?
I'm afraid not. Many of us don't use the maintenance wizard because it is a layer on top of the SQL
commands, and when something goes wrong, you find it more difficult to hunt down the problem. As
this case seems, I find it difficult to provide more recommendation on the newsgroup. Consider
opening a case with MS Support and have them hunt down the problem...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Dooza" <steve@.whatareyoudooza.tv> wrote in message news:OtoBL6koEHA.2684@.TK2MSFTNGP11.phx.gbl...
> Hi Tibor,
> I didnt have time last night to continue my exploration of the BACKUP
> command, but I do have some odd news about the maintenance plan. Last night
> the backup gave me this message:
> The file C:\MSSQL7\BACKUP\dmc\dmc_db_200409232100.BAK already exists. This
> backup command is ignored
> It exists because I created a manual backup yesterday thinking that it would
> make it work, seems I was wrong. So if the file isnt there it wont for some
> reason create it, but it wont report that it hasnt either, but when the
> verify runs it cant because the file isnt there, and thats when it reports
> it missing.
> Anyone have any ideas on this?
> Cheers,
> Steve
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:eILB%23UXoEHA.1800@.TK2MSFTNGP15.phx.gbl...
>> Check out the BACKUP command.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Dooza" <steve@.whatareyoudooza.tv> wrote in message
> news:%23XVAY7WoEHA.3460@.tk2msftngp13.phx.gbl...
>> > Thats just it Tibor, when I do a manual backup in Enterprise Manager it
>> > always works. I cant get it to fail, and I cant see a failure message,
> the
>> > only way I know it has failed is because the file it tries to verify
> isnt
>> > there.
>> >
>> > What is the SQL for backing up in QA?
>> >
>> > Steve
>> >
>> > "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in
>> > message news:eKcoEgWoEHA.2068@.TK2MSFTNGP09.phx.gbl...
>> > > Can you reproduce this by executing all the BACKUP (and possibly
> RESTORE)
>> > commands from QA? If so,
>> > > can you post those commands here?
>> > >
>> > > --
>> > > Tibor Karaszi, SQL Server MVP
>> > > http://www.karaszi.com/sqlserver/default.asp
>> > > http://www.solidqualitylearning.com/
>> > >
>> > >
>> > > "Dooza" <steve@.whatareyoudooza.tv> wrote in message
>> > news:e3%23LzbWoEHA.1308@.TK2MSFTNGP14.phx.gbl...
>> > > > 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.).
>> > > > > > > > > > >> > >
>> > > > > > > > > > >> > >
>> > > > > > > > > > >> > >
>> > > > > > > > > > >>
>> > > > > > > > > > >>
>> > > > > > > > > > >
>> > > > > > > > > > >
>> > > > > > > > > >
>> > > > > > > > > >
>> > > > > > > > >
>> > > > > > > > >
>> > > > > > > >
>> > > > > > > >
>> > > > > > >
>> > > > > > >
>> > > > > >
>> > > > > >
>> > > > >
>> > > > >
>> > > >
>> > > >
>> > >
>> > >
>> >
>> >
>>
>