Re: Backup error on Microsoft CMS 2002 SP1A Database

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Baisong Wei[MSFT] (v-baiwei_at_online.microsoft.com)
Date: 03/10/04 

Date: Wed, 10 Mar 2004 06:02:28 GMT

Hi Patrick,

Thank your for using the newsgroup. It is my pleasure to help you with your
issue.

>From you information, you job to maintenance the database 'Website' ran
fine in the past, however, just recently, it persistently failed.

There must be some change that different with before, so I want to confirm
that when you disable the Anti-Virus Software on your computer, do you
still meet the problem? The following link would take you to the download
of the Utility called ProcessExplorer that you can use to monitor access of
files by different processes.

To find what processes are accessing a particular file, you would need to
Search and enter the File Name for obtaining a list of the processes.
http://www.sysinternals.com/ntw2k/freeware/procexp.shtml

If it is not caused by the Anti-Virus software, you could try the following
steps to narrow down the problem. First, stop the antivirus software and:

1) In the Enterprise Manager, using the Backup Wizard to backup the
database, any problems?
2) Run in you Query Analyzer the following code (Suppose you are using sa
and you login into the Query Analyzer by the account starting the SQL Agent
Service):

Exec xp_cmdshell 'md d:\MSSQL\BACKUP\Website\aaa'
Go
Exec xp_cmdshell 'rd d:\MSSQL\BACKUP\Website\aaa'
go
BACKUP DATABASE [Website] TO DISK
=N'd:\MSSQL\BACKUP\Website\Website_db_200403091753.BAK' WITH INIT ,
NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT

Is there any Problems and messages?

Looking forward to you reply.

Thanks

Best regards

Baisong Wei
Microsoft Online Support
----------------------------------------------------
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.

Relevant Pages

  • Re: why does my autorecover not work?
    ... This could be a problem with something like anti-virus software or a file ... management system. ... Norton AV Plug-in is notorious, ... This reply is posted in the Newsgroup; please post any follow question or reply ...
    (microsoft.public.word.docmanagement)
  • Re: zonealarm
    ... I always do in this newsgroup. ... >>> from the internet? ... > would require a live connection to the computer through some sort of ...
    (comp.security.firewalls)
  • RE: How do I get permission to access files on my hard drive from ano.
    ... question in this newsgroup. ... described is most likely related to the operating system, the external hard ... vendor of your anti-virus software. ... It says that I need permission to open the files. ...
    (microsoft.public.word.vba.general)
  • Re: Setting a breakpoint in sql server 2000 stored procedure from VS2005
    ... Microsoft MVP ... Please reply only to the newsgroup so that others can benefit. ... This posting is provided "AS IS" with no warranties, ... EXEC sp_procoption 'usp_force_legacy', 'startup', 'true' ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Question re quality of firewall - zonealarm
    ... But I wanted to upgrade to a ... > superior firewall. ... The same goes for anti-virus software. ... Did you read the newsgroup before asking the question? ...
    (comp.security.firewalls)