Activity overview
Latest activity by steffan
Thanks... I'll give that a whirl. Also just realized that I can use the "MAILTO_ONERROR" syntax on a restore job, even though the GUI doesn't offer it.
Thanks
-S / comments
Thanks... I'll give that a whirl. Also just realized that I can use the "MAILTO_ONERROR" syntax on a restore job, even though the GUI doesn't offer it.
Thanks
-S
Scheduled restore fails, SQL Agent reports success
Any thoughts on how I could get the SQLAgent job to report failure when a scheduled restore fails? Even though the SQLbackup step failed, the job continued on to the next step because it thought t...
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. / comments
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'...
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 / comments
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 formatt...
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. / comments
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.
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? / comments
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...
Backing up to an NFS share
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 t...