db backup
-
BACKUP DATABASE [db] TO DISK = N'D:\Classes' WITH NOFORMAT, INIT, NAME = N'db-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10 i use this query to backup my db with sql express 2005. it's fine.but when i use direct partition(eg. C:\) or desktop it's giving error as os error and access denied anyone can help me
-
BACKUP DATABASE [db] TO DISK = N'D:\Classes' WITH NOFORMAT, INIT, NAME = N'db-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10 i use this query to backup my db with sql express 2005. it's fine.but when i use direct partition(eg. C:\) or desktop it's giving error as os error and access denied anyone can help me
Probably because the account that SQL Server is running in does not have access to those drives. (NOTE: This is the account the SQL Server process is using, not the account you use to log in to SQL Server)
Upcoming events: * Glasgow: Geek Dinner (5th March) * Edinburgh: Web Security Conference Day for Windows Developers (12th April) My: Website | Blog | Photos
-
Probably because the account that SQL Server is running in does not have access to those drives. (NOTE: This is the account the SQL Server process is using, not the account you use to log in to SQL Server)
Upcoming events: * Glasgow: Geek Dinner (5th March) * Edinburgh: Web Security Conference Day for Windows Developers (12th April) My: Website | Blog | Photos
thanks if i try to backup to "c:\" it's giving that error .but if i backup to "c:\new folder" it's ok.i dont know why's that and what'll i do.i think that's not sql account problem.