Drop Table

Support Forum for database administrators and web based access to important newsgroups related to databases
Register on Database Support Forum Edit your profileCalendarFind other Database Support forum membersFrequently Asked QuestionsSearch this forum -> 
For Database admins: Free Database-related Magazines Now Free shipping to Texas


Post New Thread










Thread
Author

SQL Database Backup on Network drive gives error
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.


Report this thread to moderator Post Follow-up to this message
Old Post
Shailender
03-28-06 08:23 AM


Re: SQL Database Backup on Network drive gives error
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.
>



Report this thread to moderator Post Follow-up to this message
Old Post
David Lundell
03-28-06 08:23 AM


Re: SQL Database Backup on Network drive gives error
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"


Report this thread to moderator Post Follow-up to this message
Old Post
Shailender
03-31-06 08:23 AM


Sponsored Links





Last Thread Next Thread
Post New Thread

MS SQL Server archive

Show a Printable Version Email This Page to Someone! Receive updates to this thread
Microsoft SQL Server
Access database support
PostgreSQL Replication
SQL Server ODBC
FoxPro Support
PostgreSQL pgAdmin
SQL Server Clustering
MySQL ODBC
Web Applications with dBASE
SQL Server CE
MySQL++
Sybase Database Support
MS SQL Full Text Search
PostgreSQL Administration
SQL Anywhere support
DB2 UDB Database
Paradox Database Support
Filemaker Database
Berkley DB
SQL 2000/2000i database
ASE Database
Forum Jump:
All times are GMT. The time now is 10:14 AM.

 
Mobile devices forum | Database support forum archive




Copyrights DropTable.com Database Support Forum 2004 - 2006