Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jpotucek
Constraint Violating Yak Guru
273 Posts |
 Posted - 2008-07-21 : 09:30:20
|
| have been running backups (Full and TLOG) over the network to one Server. I use SQL Maint plans and the UNC path for the Backup destination.recently I have switched to another destination server on the same network. This new backup Server supposedly has more horsepower and it does h ave lots more storage. Problem I'm having is my backups are failing with this error: Executed as user: SUPREME\SQLKofC. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.and this in the backuplog: * spid69 BackupDiskFile::RequestDurableMedia: failure on backup device '\\kocsqllab02\SQL BACKUPS\KOCALT01\Altiris_db_200807210743.BAK'. Operating system error 64(The specified network name is no longer available.).* backup BACKUP failed to complete the command BACKUP DATABASE [Altiris] TO DISK = N'\\kocsqllab02\SQL BACKUPS\KOCALT01\Altiris_db_200807210743.BAK' WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT * backup Database backed up: Database: Altiris_Incidents, creation date(time): 2006/02/22(16:32:41), pages dumped: 4518, first LSN: 10369:224:1, last LSN: 10369:226:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'\\kocsqllab02\SQL BACKUPS\KOCALT01\Altiris_Incidents_db_200807210822.BAK'}).--Can anyone help me troubleshoot this? to me it looks like a Network problem .. maybe the switch that the new dest server is attached to or the NIC or something.. ANyone seen this before??? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-07-21 : 09:35:18
|
Is the new server named exactly as the old server (kocsqllab02)?Are the UNC paths accesible (\\kocsqllab02\SQL BACKUPS\KOCALT01\)?Do SUPREME\SQLKofC have enough permissions to write to the share?
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
jpotucek
Constraint Violating Yak Guru
273 Posts |
Posted - 2008-07-22 : 11:05:46
|
| definitely permissions where good.. the backup ran for awhile and then failed.. .turned out that the SAN was bad.. |
|
|
|
|
|
|
Backups over the network failing