backup exec fails (though having the sql addon)

Hi group

Working with backup exec 10, sql agent and advanced open file options
included to backup our databases. We have 11 SQL databases varying in size
from 200 to 5000mb. There is one new dbase which is the database for a
website that is now not being backed up (size, approx 1.5 GB), this has
never worked since it was created last week.

(for now we are doing a full backup dump in non production hours to a
location that is backed up)

Additional info:
-Backupexec runs under a domain admin account
-SQL Server runs under another account
-owner for databases is domain admin
-2003 server for SQL (2000/sp3a) and the webserver (IIS6.0)
-backupexec shows fileskipped messages without specifying the file
-no usable info in eventvwr
-there are jobs running on this database (although not when the backup is
run)
-no locks/active connections are shown in the enterprise manager

Are there any issues with sql databases that are used by websites?
Has anybody have experienced similar problems and have a sollution available
that might work for me?

thx.
Perry

Perry,

When you view the history for the backup job with BackupExec what error
message is recorded, if any?

> (for now we are doing a full backup dump in non production hours to a
> location that is backed up)

Using?  Are you using Enterprise Manager?  If not, does that work?  Any
errors in the SQL errorlog for the backup failing?

HTH

Jerry
"Perry" <reply@to.ng> wrote in message
news:ejIiKnUxFHA.1032@TK2MSFTNGP12.phx.gbl...
> Hi group
>
> Working with backup exec 10, sql agent and advanced open file options
> included to backup our databases. We have 11 SQL databases varying in size
> from 200 to 5000mb. There is one new dbase which is the database for a
> website that is now not being backed up (size, approx 1.5 GB), this has
> never worked since it was created last week.
>
> (for now we are doing a full backup dump in non production hours to a
> location that is backed up)
>
> Additional info:
> -Backupexec runs under a domain admin account
> -SQL Server runs under another account
> -owner for databases is domain admin
> -2003 server for SQL (2000/sp3a) and the webserver (IIS6.0)
> -backupexec shows fileskipped messages without specifying the file
> -no usable info in eventvwr
> -there are jobs running on this database (although not when the backup is
> run)
> -no locks/active connections are shown in the enterprise manager
>
> Are there any issues with sql databases that are used by websites?
> Has anybody have experienced similar problems and have a sollution
> available that might work for me?
>
> thx.
> Perry
>
>
>
>

Hi

Never use open file options against a SQL Server database as the DB and
Transaction log will never be restorable as they will not be in sync at a
point in time.

Backup the database to disk from within SQL Server (see BACKUP command in
BOL), or use the SQL Server maintenance wizard.

Backup the backup file files that SQL Server generated.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"Perry" <reply@to.ng> wrote in message
news:ejIiKnUxFHA.1032@TK2MSFTNGP12.phx.gbl...
> Hi group
>
> Working with backup exec 10, sql agent and advanced open file options
> included to backup our databases. We have 11 SQL databases varying in size
> from 200 to 5000mb. There is one new dbase which is the database for a
> website that is now not being backed up (size, approx 1.5 GB), this has
> never worked since it was created last week.
>
> (for now we are doing a full backup dump in non production hours to a
> location that is backed up)
>
> Additional info:
> -Backupexec runs under a domain admin account
> -SQL Server runs under another account
> -owner for databases is domain admin
> -2003 server for SQL (2000/sp3a) and the webserver (IIS6.0)
> -backupexec shows fileskipped messages without specifying the file
> -no usable info in eventvwr
> -there are jobs running on this database (although not when the backup is
> run)
> -no locks/active connections are shown in the enterprise manager
>
> Are there any issues with sql databases that are used by websites?
> Has anybody have experienced similar problems and have a sollution
> available that might work for me?
>
> thx.
> Perry
>
>
>
>

Mike,

I have this same argument with my IT director.  It's been one of those he
won't budge...I won't budge thing so...Veritas does have an agent for SQL
backups.  We have the license but I've chosen not to use it (yet) not
because it doesn't work but because it is a bit more challenging and
involved.  I do backup the databases using EM (jobs) then I use Veritas
BackupExec to backup the backup files to tape for off-site storage.

HTH

Jerry
"Mike Epprecht (SQL MVP)" <mike@epprecht.net> wrote in message
news:ObMOEeVxFHA.3756@tk2msftngp13.phx.gbl...
> Hi
>
> Never use open file options against a SQL Server database as the DB and
> Transaction log will never be restorable as they will not be in sync at a
> point in time.
>
> Backup the database to disk from within SQL Server (see BACKUP command in
> BOL), or use the SQL Server maintenance wizard.
>
> Backup the backup file files that SQL Server generated.
>
> Regards
> --------------------------------
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
>
> IM: mike@epprecht.net
>
> MVP Program: http://www.microsoft.com/mvp
>
> Blog: http://www.msmvps.com/epprecht/
>
> "Perry" <reply@to.ng> wrote in message
> news:ejIiKnUxFHA.1032@TK2MSFTNGP12.phx.gbl... 
>
>

Jerry,

Below is what the log says, the servername is DC4, the databasename is
SYNERGY:

Job Completion Status
Job ended: Wednesday, September 28, 2005 at 8:36:41 PM
Completed status: Completed with exceptions


Errors
Click an error below to locate it in the job log
Backup- DC4 Database ?SYNERGY was not found, or could not be accessed.


Exceptions
Click an exception below to locate it in the job log
Backup- DC4 The item DC4\SYNERGY in use - skipped.Perry



"Jerry Spivey" <jspivey@vestas-awt.com> wrote in message
news:u4j16tUxFHA.3740@tk2msftngp13.phx.gbl...
> Perry,
>
> When you view the history for the backup job with BackupExec what error
> message is recorded, if any?
> 
>
> Using?  Are you using Enterprise Manager?  If not, does that work?  Any
> errors in the SQL errorlog for the backup failing?
>
> HTH
>
> Jerry
> "Perry" <reply@to.ng> wrote in message
> news:ejIiKnUxFHA.1032@TK2MSFTNGP12.phx.gbl... 
>
>