thanks to moonguy on MSDN he saved me many hours of work.
When you try to backup, SQL Server 2005 shows the default backup path i.e. c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\ . This directory default has SQL user rights. Go to Backup directory and check the user name. Its very big name and I have not checked how SQL server adds it in allowed users list. You can do 2 things:
1. Let the Server take backup on default directory and copy the file in your desired folder. I did that.
2. Give same kind of permissions to your desired folder as Backup directory has.
Hope it solves the issue.
Moonguy
No comments:
Post a Comment