What are the challenges you face when working across database platforms? Take the survey
Options

Backing up to an NFS share

steffansteffan Posts: 9
edited November 10, 2006 3:22AM in SQL Backup Previous Versions
I have an NFS share off a Snap Server NAS that I am using Server2003 NFS services to mount as a local drive. I'd like to send a Mirrored copy of the nightly backup to that drive.

I can't browse to any mapped drives and looking through the forums, it seems it's not supported unless you use UNC. Problem is that NFS does not use standard UNC paths. The syntax looks more like this:

10.100.1.55:/BackupShare/

How can I get this to work?
Thanks
-steffan

Comments

  • Options
    peteypetey Posts: 2,358 New member
    What would the syntax be like if you were to create a regular backup to the NFS share? E.g.

    BACKUP DATABASE model TO DISK = ' ? '

    Thanks.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    As far as I can tell, you can't do it natively. That's why I hoped this product would be able to send to a mapped drive and let the local OS deal with how the mapping is handled. Or perhaps find a work around via this forum.

    Know of any plans for SQLbackup to support mapped drives?
  • Options
    peteypetey Posts: 2,358 New member
    So if using regular SQL Server backups, something like this would work?

    BACKUP DATABASE model TO DISK = '10.100.1.55:\BackupShare\model.bak'
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    No, it does not. Guess that's what I meant when I said you "can't do it natively". I meant within SQL2000, not SQLbackup. I was looking for a way around this limitation of MS-SQL.
  • Options
    peteypetey Posts: 2,358 New member
    Could it be because the SQL Server service account does not have access to the NAS (e.g. LocalSystem) ?

    If the SQL Backup service is running using a service account that has rights to the NAS, could you run the following from Query Analyzer/SSMS and report the results:

    sqlbackup '-sql "BACKUP DATABASE model TO DISK = [10.100.1.55:\BackupShare\model.bak] " '

    or should that be

    sqlbackup '-sql "BACKUP DATABASE model TO DISK = [\\10.100.1.55\BackupShare\model.bak] " '

    Thanks.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    No it's not that. I tested the NFS share with wide open permissions (full open access) and got the same results. It's a syntax thing within MSSQL. I think it just doesn't understand the formatting of the path. That's why future support for mapped drives within SQLbackup is so needed. If you could work around the limitation within MSSql, it would be HUGE!

    No other workarounds that I'm missing within the product?

    thanks
    -S
  • Options
    peteypetey Posts: 2,358 New member
    My understanding of NAS devices is that they appear like regular network shares, so you either refer to them by name e.g. \\NAS1\share or by IP address like in your case e.g. \\10.100.1.55\BackupShare. In this way, any application can support writing to the devices without requiring special drivers or customised code etc. Or is there something else?
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    This particular machine is exposed to the net so we try to keep it as locked down as possible. So, even though the NAS supports many file serving protcols, inculding native MS file shares, we don't have any of those protocols loaded on this server. It's been a topic of debate for a while. The Unix guys think we're crazy even having this MS box exposed, the newer MS guys think we're over protective. They are probably both a bit correct. But as it stands now, it's NFS only.
Sign In or Register to comment.