| DBA Dean 2006-10-24, 6:31 pm |
| I ran into an issue creating/updating maintenance plans in SQL Server 2005
SP1. We backup the databases to a TeraStation on the network. When I first
created the backup, then destination information appeared correctly in the
GUI (Server Management Studio). The resulting location was not correct:
Failed Version:
Date 9/22/2006 9:03:47 PM
Log Windows NT (Application)
Source MSSQLSERVER
Category Server
Event 3221243676
User HTPPORTAL\SQLADMIN
Computer PORTALDB1
Message
BackupDiskFile::Crea
teMedia: Backup device 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Backup\
\\backup2\dbbackups\
portaldb1\HTPEDB_OSU
_backup_200609222103
.trn' failed to
create. Operating system error 3(The system cannot find the path specified.).
This actual information for the destination only appeared in the Windows NT
log file.
I re-entered and saved the maintenance plans and it appears to corrected the
issue:
Corrected version:
Date 9/23/2006 4:05:27 AM
Log Windows NT (Application)
Source MSSQLSERVER
Category Backup
Event 1073760088
User HTPPORTAL\SQLADMIN
Computer PORTALDB1
Message
Database backed up. Database: HTPEDB_OSU, creation date(time):
2006/08/23(23:12:33), pages dumped: 4589811, first LSN: 52221:120718:15, last
LSN: 52224:157297:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK:
& #123;'\\backup2\dbba
ckups\PortalDB1\HTPE
DB_OSU_backup_200609
222200.bak'}). This
is an informational message only. No user action is required.
Is it just me, or has anyone else seen this?
|