MS SQL Server - SQL Database Backup on Network drive gives error

Author

SQL Database Backup on Network drive gives error

Shailender

2006-03-28, 3:23 am

I am facing some typical error while taking the
Portal Backup from the front end servers. It was working fine for many
days 2 days back it started throwing error.
This is medium Server Farm Setup, with data getting stored on SAN .
My data size is approx 20 GB
Below are the error message captured in event viewer while taking the
Portal backup using spsbackup.exe.

Error captured in SharePoint Front end server

SQL Server backup failed. Error: There is not enough disk space on
server SPDB to complete the database sps_site operation. Increase the
space available and try again. , Server: SPDB, Database: sps_site,
Backup location: \\spfen1\temp1234\sp
s-SPDB-sps_site.SPB

Errors captured in SharePoint Back end server

18210 :
BackupMedium::Report
IoError: write failure on backup device
'\\spfen1\temp1234\s
ps-SPDB-sps_site.SPB'. Operating system error
64(The specified network name is no longer available.).

3041 :
BACKUP failed to complete the command BACKUP DATABASE [sps_site] TO
DISK = N'\\spfen1\temp1234\
sps-SPDB-sps_site.SPB' WITH INIT ,
NOUNLOAD , NOSKIP , STATS = 5, NOFORMAT

18210 :
BackupDiskFile::Requ
estDurableMedia: failure on backup device
'\\spfen1\temp1234\s
ps-SPDB-sps_site.SPB'. Operating system error
64(The specified network name is no longer available.).

We have tested our disk controllers and disks, every thing is seems to
be fine.

Moreover we are not able to copy huge files on some of the drives on
the setup.
The errors while copping are like "cannot copy files, Path Too
Deep"

Any help will be highly appreciated.

David Lundell

2006-03-28, 3:23 am

How are the destination drives formatted?
FAT or NTFS?

File size limit on FAT is 4 GB.

Your symptoms certainly seem to describe this
1) Everything else works
2) "not able to copy huge files"

--
David Lundell
Principal Consultant and Trainer
www.MutuallyBeneficial.com
David@MutuallyBenefi
cial.com

"Shailender" <shailenderrai@gmail.com> wrote in message
news:1143522281.340046.88720@z34g2000cwc.googlegroups.com...
> I am facing some typical error while taking the
> Portal Backup from the front end servers. It was working fine for many
> days 2 days back it started throwing error.
> This is medium Server Farm Setup, with data getting stored on SAN .
> My data size is approx 20 GB
> Below are the error message captured in event viewer while taking the
> Portal backup using spsbackup.exe.
>
> Error captured in SharePoint Front end server
>
> SQL Server backup failed. Error: There is not enough disk space on
> server SPDB to complete the database sps_site operation. Increase the
> space available and try again. , Server: SPDB, Database: sps_site,
> Backup location: \\spfen1\temp1234\sp
s-SPDB-sps_site.SPB
>
> Errors captured in SharePoint Back end server
>
> 18210 :
> BackupMedium::Report
IoError: write failure on backup device
> '\\spfen1\temp1234\s
ps-SPDB-sps_site.SPB'. Operating system error
> 64(The specified network name is no longer available.).
>
> 3041 :
> BACKUP failed to complete the command BACKUP DATABASE [sps_site] TO
> DISK = N'\\spfen1\temp1234\
sps-SPDB-sps_site.SPB' WITH INIT ,
> NOUNLOAD , NOSKIP , STATS = 5, NOFORMAT
>
> 18210 :
> BackupDiskFile::Requ
estDurableMedia: failure on backup device
> '\\spfen1\temp1234\s
ps-SPDB-sps_site.SPB'. Operating system error
> 64(The specified network name is no longer available.).
>
>
> We have tested our disk controllers and disks, every thing is seems to
> be fine.
>
> Moreover we are not able to copy huge files on some of the drives on
> the setup.
> The errors while copping are like "cannot copy files, Path Too
> Deep"
>
> Any help will be highly appreciated.
>

Shailender

2006-03-31, 3:23 am

Thanks David,
The drives are formatted with NTFS and size of data is 20 GB.

My symptoms certainly seem to describe this
1) Everything else works
2) "not able to copy huge files"

Sponsored Links