I have just seen this thread Here. answere for this question is.....Yes. For taking backup of database into local path or network path (UNC) the user need db_backupoperator privelege only.
Let's have a look into this scenario. I have two servers named as VMSYS2 and VMSYS3. I have taken a backup of VMSYS2 (Source) server toVMSYS3 (Destination)
To take a SQL Database backup into network drive, First I have created a Login in my Test server and I am not provided SA privelege to that login.
I have taken a backup into network drive using SQL commands. and Query ran successfullyas you can see in the below screen shot. .
Note: * SQL user must have read/write permision on the network share
* SQL services should be run in domain account only.
Hope this helps
Let's have a look into this scenario. I have two servers named as VMSYS2 and VMSYS3. I have taken a backup of VMSYS2 (Source) server toVMSYS3 (Destination)
To take a SQL Database backup into network drive, First I have created a Login in my Test server and I am not provided SA privelege to that login.
I have taken a backup into network drive using SQL commands. and Query ran successfullyas you can see in the below screen shot. .
* SQL services should be run in domain account only.
Hope this helps
Post a Comment