May 12, 2004 at 9:14 am
Hi All,
I am running SQL Server 2000 (SP3a) on Win 2003 and have created Maint. plans to backup databases and Transaction logs to a folder on the same server.
Recently 6 ( out of 35 ) database backups started failing with the error :
"Msg 18204 : dbsvolopen: Backup device ' D:\MSSQL\BACKUP\test_backup.DAT' failed to open, operating system error = 2(The system cannot find the file specified)"
Also when I setup log for those particular jobs I get the following error :
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open backup device 'E:\Microsoft SQL Server Data\MSSQL$INST1\BACKUP\DbName_db_200405120852.DBK'. Device error or device off-line. See the SQL Server error log for more details.
The transaction log backups for these same databases are going to the same folder and are running fine. It is a NAMED INSTANCE. I tried setting up a Maint plan to point the backup to a different drive and I am still getting the same error.
Any help is appreaciated.
Thanks.
May 17, 2004 at 8:00 am
This was removed by the editor as SPAM
May 18, 2004 at 3:07 am
I just had the same problems with the creation of the backups. I discovered that the problem only occured when the adsmclientservice, which is used by our network backup software, was busy to create a backup of the machine at the same time.
May 18, 2004 at 6:36 am
Thanks for your reply Jmvdam,
Finally I was able to resolve the issue. Here is the Q article in which Microsoft admits that it is a known issue and there is a hot fix available for it.
http://support.microsoft.com/default.aspx?scid=kb;en-us;827452
Also the workaround is to use TCP-IP instead of using Named Pipes on the SQL Server.
I am glad that this problem was resolved.. it is a show stopper.
Thanks.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply