osql to unc path

[systemtek]

Hi,

If i try to backup to a UNC path it fails but if i try local it works,
any idea ?

for example, this works ok :

backup database model to disk = 'C:\Backup\DailyDatabaseBackups
\live.bak'
go

this fails :

backup database model to disk = '\\myserver\DailyDatabaseBackups
\live.bak'
go


Thanks
Duncan

[Andrea Montanari]

hi Duncan,
systemtek wrote:
> Hi,
>
> If i try to backup to a UNC path it fails but if i try local it works,
> any idea ?
>
> for example, this works ok :
>
> backup database model to disk = 'C:\Backup\DailyDatabaseBackups
> \live.bak'
> go
>
> this fails :
>
> backup database model to disk = '\\myserver\DailyDatabaseBackups
> \live.bak'
> go

it probably fails (you did not report the exceptions you are prompted with)
becouse the account running the SQL Server service has not been granted
adeguate permissions at Share and NTFS level on the destination folder..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://www.hotelsole.com
DbaMgr2k ver 0.21.1 - DbaMgr ver 0.65.1 and further SQL Tools
--------- remove DMO to reply

[systemtek]

On Jun 20, 11:35 am, "Andrea Montanari" <***@virgilio.it>
wrote:
> hi Duncan,
>
>
>
>
>
> systemtek wrote:
> > Hi,
>
> > If i try to backup to a UNC path it fails but if i try local it works,
> > any idea ?
>
> > for example, this works ok :
>
> > backup database model to disk = 'C:\Backup\DailyDatabaseBackups
> > \live.bak'
> > go
>
> > this fails :
>
> > backup database model to disk = '\\myserver\DailyDatabaseBackups
> > \live.bak'
> > go
>
> it probably fails (you did not report the exceptions you are prompted with)
> becouse the account running the SQL Server service has not been granted
> adeguate permissions at Share and NTFS level on the destination folder..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)http://www.asql.biz       http://www.hotelsole.com
> DbaMgr2k ver 0.21.1 - DbaMgr ver 0.65.1 and further SQL Tools
> --------- remove DMO to reply- Hide quoted text -
>
> - Show quoted text -

Sorry should have said the account used does have full access to the
given share. I will re run and post the exact error.

[systemtek]

On 20 Jun, 11:35, "Andrea Montanari" <***@virgilio.it>
wrote:
> hi Duncan,
>
>
>
>
>
> systemtek wrote:
> > Hi,
>
> > If i try to backup to a UNC path it fails but if i try local it works,
> > any idea ?
>
> > for example, this works ok :
>
> > backup database model to disk = 'C:\Backup\DailyDatabaseBackups
> > \live.bak'
> > go
>
> > this fails :
>
> > backup database model to disk = '\\myserver\DailyDatabaseBackups
> > \live.bak'
> > go
>
> it probably fails (you did not report the exceptions you are prompted with)
> becouse the account running the SQL Server service has not been granted
> adeguate permissions at Share and NTFS level on the destination folder..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)http://www.asql.biz       http://www.hotelsole.com
> DbaMgr2k ver 0.21.1 - DbaMgr ver 0.65.1 and further SQL Tools
> --------- remove DMO to reply- Hide quoted text -
>
> - Show quoted text -

Or are we talking about permissions for the SA acount here ? or the
user running user account ?

[Andrea Montanari]

hi,
systemtek wrote:
> Or are we talking about permissions for the SA acount here ? or the
> user running user account ?

the Windows account running the SQL Server service..
regards
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://www.hotelsole.com
DbaMgr2k ver 0.21.1 - DbaMgr ver 0.65.1 and further SQL Tools
--------- remove DMO to reply