ADO & SQL Server.

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

From: Sam Davis <SamDavis@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Tue, 31 May 2005 16:16:33 -0700

I was wondering if anyone can help me figure out an issue that we encounter
between ADO & SQL Server. We have a process that kicks off in the evening
that processes the days events, during this process a back up occurs. For
some reason we aren't sure but if someone is using or posting information to
the system an open transaction is left which in turns keeps the backup from
happening. These transactions that are left open are a problem due to a page
has to go out to one of us :).. The code is utilized during the day without
issue, just during this timeframe that backups are occuring .. Any ideas on
what I should be doing to address the issue? We have tried everything we know
of.
.

Follow-Ups:
- Re: ADO & SQL Server.
  - From: Uwa Agbonile [MSFT]

Prev by Date: ADO & Sql Server, Error 80040e21
Next by Date: ADO and Jet creates error on XP Home Edition SP2
Previous by thread: ADO & Sql Server, Error 80040e21
Next by thread: Re: ADO & SQL Server.
Index(es):
- Date
- Thread

Relevant Pages

Re: ADO & SQL Server.
... Are you using the SQL Server BACKUP command? ... shouldn't block on a transaction. ... > the system an open transaction is left which in turns keeps the backup ...
(microsoft.public.data.ado)
Re: ADO & SQL Server.
... It is a backup intiated through a stored procedure to a file. ... > Are you using the SQL Server BACKUP command? ... > shouldn't block on a transaction. ... >> the system an open transaction is left which in turns keeps the backup ...
(microsoft.public.data.ado)
Re: SBS2003, NTBackup-Fehler
... Falls das Problem noch verhandeln ist,werde ich vorschalgen nächste Schritte durchzuführen. ... Backup fails on a computer that is running Small Business Server 2003 ... Die Sicherung kann nicht fortgesetzt werden. ... Microsoft OLE DB Provider for SQL Server ...
(microsoft.public.de.german.backoffice.smallbiz)
RE: SBS Backup problems
... search for *SQL* there a Microsoft SQL Server folder located under C:\Program ... > From the backup log, I find the following error message. ... > - You back up data from a volume that contains a Microsoft SQL Server ... > This newsgroup only focuses on SBS technical issues. ...
(microsoft.public.windows.server.sbs)
RE: Backups have Shadow Copy Problems
... with volume Shadow Copy error 800423f4. ... You back up data from a volume that contains a Microsoft SQL Server ... The recovery model of the SQL Server database is configured to use an ... It just ensures backup will continue without reporting the error. ...
(microsoft.public.windows.server.sbs)