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
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
On Jun 20, 11:35 am, "Andrea Montanari" 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.
