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\sqlag ent' (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_IN VENT. The
parent directory will be used instead.[1] Database
CPN_AX30_SP3_IN VENT: Database Backup...
Destination: [\\titan\axapta
\CPN_AX30_SP3_I NVENT_db_200805 211126.BAK]
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201: [Microsoft]
[ODBC SQL Server Driver][SQL Server]Cannot open backup device '\\titan
\axapta\CPN_AX3 0_SP3_INVENT_db _200805211126.B AK'. 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.
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\sqlag ent' (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_IN VENT. The
parent directory will be used instead.[1] Database
CPN_AX30_SP3_IN VENT: Database Backup...
Destination: [\\titan\axapta
\CPN_AX30_SP3_I NVENT_db_200805 211126.BAK]
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201: [Microsoft]
[ODBC SQL Server Driver][SQL Server]Cannot open backup device '\\titan
\axapta\CPN_AX3 0_SP3_INVENT_db _200805211126.B AK'. 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.
Comment