Prev: SQL 2008 vs 2008R2
Next: backup
From: shapper on 16 Jun 2010 17:36
Hello,

I am creating a backup of a SQL Database using T-SQL and I get an
error when saving it to a folder under Users/Miguel/Backup.

The same happens if I use SSMS.

If I change the folder to the usual SQL Backup folder there is no
problem.

Do I need to do something to my Users/Miguel/Backup folder?

Thanks,

Miguel
From: Tom Moreau on 16 Jun 2010 20:30
Grant read/write privileges for the SQL Server service account to that
folder.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"shapper" <mdmoura(a)gmail.com> wrote in message
news:267cb596-42c9-4386-9524-075c1699a97f(a)c10g2000yqi.googlegroups.com...
Hello,

I am creating a backup of a SQL Database using T-SQL and I get an
error when saving it to a folder under Users/Miguel/Backup.

The same happens if I use SSMS.

If I change the folder to the usual SQL Backup folder there is no
problem.

Do I need to do something to my Users/Miguel/Backup folder?

Thanks,

Miguel

 | 
Pages: 1
Prev: SQL 2008 vs 2008R2
Next: backup