I am trying to backup from my sql 2005 DB which is on windows server 2003 to sql 2008R2 on windows server 2008R2 but getting access denied,
I have tried using SSMS, T-Sql but still getting issue with this.
I have created backup folder on my 2008R2 server and assign the full access to Everyone on security permission, I have added user and also grant the FUll Permission.
1) I tried using SSMS ut didn't work
2) I tried using T-sql, didn't work
I have just install the sql 2008R2 on Windows 2008 R2.