OS: Win2K Server SP4
DB: SQL Server 2000 SP3a
I have a database that has a1.1GB LDF file and a 380MB MDF file
I have a database maintenanec plan set up to do full database backup (i.e.
not differential) of all non-system databases including this database in
question.
The backup to d:\MSSQL\BACKUP (with a sub directory for each DB) has been
working fine since the server was set up 6 months ago. Suddently, the
backup stopped working on Saturday (the Friday backup is successful and no
one was in the office on Saturday, to rule out any system changes that could
have trigger this).
Observations
*1) The error logged in the error log file is :
2004-08-21 21:25:14.07 spid60 BackupDiskFile::OpenMedia: Backup device
'd:\MSSQL\BACKUP\DBLive\DBLive_db_200408212125.BAK' failed to open.
Operating system error = 32(error not found).
2004-08-21 21:25:14.20 backup BACKUP failed to complete the command
BACKUP DATABASE [YJBLive] TO DISK = N'd:\MSSQL\BACKUP\DBLive\DBLive_db_200408212125.BAK' WITH INIT , NOUNLOAD
, NOSKIP , STATS = 10, NOFORMAT
*2) If I change the job to just do the backup without verify, then the job
completes, but
*2.1) Normally, the BAK file used to be 3xxMB large, but now the BAK file
which only succeeded in backing up without verifying is 1xxMB large
*3) The Job History indicates
Executed as user: WEBSERVER\SQLServer. sqlmaint.exe failed. [SQLSTATE 42000]
(Error 22029). The step failed.
The job failed. The Job was invoked by Schedule 2 (Schedule 1). The last
step to run was step 1 (Step 1).
*4) The backup file appear corrupted:
*4.1) If I look at the Maintenance Plan history, I found:
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201: [Microsoft][ODBC SQL
Server Driver][SQL Server]Cannot open backup device
'd:\MSSQL\BACKUP\DBLive\DBLive_db_200408231407.BAK'. Device error or device
off-line. See the SQL Server error log for more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]VERIFY DATABASE is
terminating abnormally.
*4.2) If I try to restore this (corrupted) 1xxMB BAK file to another DB, it
doesn't work. After the popup to say restore has completed, Enterprise
Manager shows the database as grey with "(Loading)" appended to the database
name (even after 5mins)
*) The user group Everyone has full permission on d:\MSSQL\BACKUP
SOS !! Why is my backup suddenly failing and how could I resolve this?
Note it is only this database whose backup are failing since Saturday (e.g.
I have a DB which has a 3.8GB LDF file which backup with no problems!)Hi Patrick,
I have noticed you make another new thread in this newsgroup. MSFT Stefan
had added a reply to you. I will continue monitor and follow up if
necessary in that thread until it is resolved.
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Stefan says it's a SQL Server issue, so replying here.
Effectively, full flat file backup (to D:\ drive using a SQL Server 2000
SP3a maintenance plan) of all application database except for the Microsoft
Content Management Server(MCMS) 2002 SP1A repository works regardless of
whether Client Network utility is set to use TCP/IP or named pipes, but for
this MCMS2002 SP1A Repository, backup only works when TCP/IP is used.
When Veritas Backup Exec 9.1 for windows server with SQL Agent is used to
backup the databases, the databases could be backed up regardless of the SQL
client settings.
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:55NG3fYiEHA.2408@.cpmsftngxa10.phx.gbl...
> Hi Patrick,
> I have noticed you make another new thread in this newsgroup. MSFT Stefan
> had added a reply to you. I will continue monitor and follow up if
> necessary in that thread until it is resolved.
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Mingqing Cheng
> Microsoft Developer Community Support
> ---
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>|||Hi Patrick,
From your descriptions, I understood that your encounter backup failure
issue. Have I understood you? If there is anything I misunderstood, please
feel free to let me know.
Based on my scope, I think the following document might help on your issue.
FIX: General network error when you try to back up or restore a SQL Server
database on a computer that is running Windows Server 2003
http://support.microsoft.com/default.aspx?scid=kb;en-us;827452
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Hi Patrick,
I would like to follow up on this issue and see if any progress has been
made. I haven't heard from you in 2 days, were you able to check my reply?
Should you have any questions, please feel free to post here.
Looking forward to your reply!
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
没有评论:
发表评论