473,320 Members | 1,862 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Help with SQL Backup Problem

Hopefully someone can help me with an issue i am having. First off
let me say that i have little to no experience with MS SQL or SQL in
general. We have a Windows 2003 server running MSSQL (i believe it is
SQL 2000). The person who took care of this has left the company so
it has fallen into my lap. In an effort to clear up disk space I
looked into the folder where our backups are supposed to be backing up
to and noticed that backups have not been running since February 23 of
this year (i did not get the warm fuzzy feelings when i saw this).

I tried to run a backup but got a failure almost instaneously:
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL
Server 'AXDB' as 'COPANSYS\sqlagent' (trusted)
Starting maintenance plan 'DB Maintenance for Invent DB' on 5/21/2008
11:26:00 AM
Could not create a sub directory for database CPN_AX30_SP3_INVENT. The
parent directory will be used instead.[1] Database
CPN_AX30_SP3_INVENT: Database Backup...
Destination: [\\titan\axapta
\CPN_AX30_SP3_INVENT_db_200805211126.BAK]
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201: [Microsoft]
[ODBC SQL Server Driver][SQL Server]Cannot open backup device '\\titan
\axapta\CPN_AX30_SP3_INVENT_db_200805211126.BAK'. Device error or
device off-line. See the SQL Server error log for more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is
terminating abnormally.
End of maintenance plan 'DB Maintenance for Invent DB' on 5/21/2008
11:26:01 AM
SQLMAINT.EXE Process Exit Code: 1 (Failed)

The backup desination is another server that the sqlagent account has
full control of so i'm not really sure what else to look at. I did
try to run a backup to a local location and the backup worked. Any
help is greatly appreciated.

Jun 27 '08 #1
4 6949
(ph********@gmail.com) writes:
I tried to run a backup but got a failure almost instaneously:
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL
Server 'AXDB' as 'COPANSYS\sqlagent' (trusted)
Starting maintenance plan 'DB Maintenance for Invent DB' on 5/21/2008
11:26:00 AM
Could not create a sub directory for database CPN_AX30_SP3_INVENT. The
parent directory will be used instead.[1] Database
CPN_AX30_SP3_INVENT: Database Backup...
Destination: [\\titan\axapta
\CPN_AX30_SP3_INVENT_db_200805211126.BAK]
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201: [Microsoft]
[ODBC SQL Server Driver][SQL Server]Cannot open backup device '\\titan
\axapta\CPN_AX30_SP3_INVENT_db_200805211126.BAK'. Device error or
device off-line. See the SQL Server error log for more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is
terminating abnormally.
End of maintenance plan 'DB Maintenance for Invent DB' on 5/21/2008
11:26:01 AM
SQLMAINT.EXE Process Exit Code: 1 (Failed)

The backup desination is another server that the sqlagent account has
full control of so i'm not really sure what else to look at. I did
try to run a backup to a local location and the backup worked. Any
help is greatly appreciated.
But does the service account for SQL Server have access to this
destination?

And that fact that the maintenance job was not able to create
subdirectory that there may be issues with the service account for
SQL Agent as well.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Jun 27 '08 #2
On May 21, 3:28*pm, Erland Sommarskog <esq...@sommarskog.sewrote:
*(phirest...@gmail.com) writes:
I tried to run a backup but got a failure almost instaneously:
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL
Server 'AXDB' as 'COPANSYS\sqlagent' (trusted)
Starting maintenance plan 'DB Maintenance for Invent DB' on 5/21/2008
11:26:00 AM
Could not create a sub directory for database CPN_AX30_SP3_INVENT. The
parent directory will be used instead.[1] Database
CPN_AX30_SP3_INVENT: Database Backup...
* * Destination: [\\titan\axapta
\CPN_AX30_SP3_INVENT_db_200805211126.BAK]
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201: [Microsoft]
[ODBC SQL Server Driver][SQL Server]Cannot open backup device '\\titan
\axapta\CPN_AX30_SP3_INVENT_db_200805211126.BAK'. Device error or
device off-line. See the SQL Server error log for more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is
terminating abnormally.
End of maintenance plan 'DB Maintenance for Invent DB' on 5/21/2008
11:26:01 AM
SQLMAINT.EXE Process Exit Code: 1 (Failed)
The backup desination is another server that the sqlagent account has
full control of so i'm not really sure what else to look at. *I did
try to run a backup to a local location and the backup worked. *Any
help is greatly appreciated.

But does the service account for SQL Server have access to this
destination?

And that fact that the maintenance job was not able to create
subdirectory that there may be issues with the service account for
SQL Agent as well.

--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se

Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx- Hide quoted text -

- Show quoted text -
You'll have to bear with my ignorance on this, but, how can add a
service account to a folders security permisions?
Jun 27 '08 #3
(ph********@gmail.com) writes:
You'll have to bear with my ignorance on this, but, how can add a
service account to a folders security permisions?
Like you would add any other account. Right-click the folder, select
Properties, go to the security tab. Use the Add button.

To determine the Service accont, right-click My Computer select Manage,
find the Services entry. There find the service for SQL Server and SQL
Agent. Right-click these, Properties. You find the service account on
the second tab.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Jun 27 '08 #4
On May 22, 3:44*pm, Erland Sommarskog <esq...@sommarskog.sewrote:
*(phirest...@gmail.com) writes:
You'll have to bear with my ignorance on this, but, how can add a
service account to a folders security permisions?

Like you would add any other account. Right-click the folder, select
Properties, go to the security tab. Use the Add button.

To determine the Service accont, right-click My Computer select Manage,
find the Services entry. There find the service for SQL Server and SQL
Agent. Right-click these, Properties. You find the service account on
the second tab.
--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se

Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Thanks for the help. It seems as if someone had removed the share
permisions. Once i added the accound back into the share permisions
we were successful on the backup. Thanks for helping point me in the
right direction.
Jun 27 '08 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: H M Kunzmann | last post by:
--=-BvUTDNS3Oo695JSBxY/x Content-Type: text/plain Content-Transfer-Encoding: quoted-printable I use mysqldump to dump my databases to file. I then write these files to tape. I was doing a...
0
by: ^CrAsH^ | last post by:
Hi to all, i've a "problem" with log shipping in sql server 2000 sp3. My log shipping works fine, but the task does not update log_shipping_primaries table on secondary server, and so log shipping...
2
by: Spieg | last post by:
I've a program with VB6 working with SQLServer 2000. I have a Central Station with the program runnin with full prvileges and that can perform all the actions on the DB. There are also some...
3
by: butatista | last post by:
Please help SQL Server 2000 Standard I am trying to restore databases on my server and am unable to get them to restore using the database option. For example, the location of my backup...
1
by: John Rajendran | last post by:
Hi there, I need to take a backup with the following scanerio in mind: At T1 I take the FULL BACK UP of the database called BACK_1_FULL.BACK in c:\ Then at T2 I would like to take only the...
1
by: debian mojo | last post by:
Hello Faculties, Currently i'm working on a local machine that houses SQL Server databases. All the development work is done on this local machine. The data is finally imported to a remote server...
1
by: Mondongo | last post by:
Hi, group. I am currently trying to backup a db into a smbfs via the command: db2 backup db <mydb> to /mnt/smb_disk compress but I have the following error: SQL2025N An I/O error "4"...
0
by: vhernz | last post by:
Hi, I am new in MSSQL and recently encountered a problem in backing up the database. Here is the scenario 1. There is an schedule backup everyweek which overwrite the backup file everytime...
2
by: modeler | last post by:
Hello, I am trying to restore a DB2 9.1 fp2 backup to another DB2 9.1 fp2 machine, both are on Windows. C:\Program Files\IBM\SQLLIB\BIN>db2 -tvf C:\db2_data\test.db2 UPDATE COMMAND OPTIONS...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.