If I try to backup of database in sql 2012 with t-Sql as follows:
Backup database db1
to disk='c:\myfullbkup.bak' with init
This code works absolutely fine.
But if I try to take backup through SSMS -Task -Backup in object explorer and gave the same path of c: drive or any other folder outside sql default "Backup" folder.It gives error as access denied.
This was not the scene in Sql server 2008.
Is there anything new that I am missing in Sql 2012.
If anyone can highlight it.