I need to perform backup and save it in network drive. I have given all permissions to the backup drives and mapped in source server as well. I successfully executed below command in sql.
EXEC sp_configure 'show advanced options', 1;
EXEC sp_configure 'xp_cmdshell',1
EXEC xp_cmdshell 'net use Z: \Backupserver\l'
EXEC xp_cmdshell 'net use Y: \Backupserver\m'
Also if I run below command i can see the output as well.
EXEC xp_cmdshell 'Dir Y:' (Means without any error i can see the disk details in output)
Volume in drive Y is Data2
Volume Serial Number is 902A-F0FE
Directory of Y:\
12/01/2021 09:42 PM Program Files (x86)
0 File(s) 0 bytes
1 Dir(s) 664,076,779,520 bytes free
I Refreshed the sql instance and tried backup the database in network drive. Though above all commands executed successfully why i am not able to see Z,Y disks while backup in SSMS.
I disconnected and re mapped disks, and tried with other letters. All possibilities I tried but not able to see network disks in GUI Backup window. As it is a Prod server i can not restart the instance.
Any particular reason why i am able to see disk details in output window by executing EXEC xp_cmdshell 'Dir Y:' but not visible in backup GUI ?
Please help me . I have only 5 hrs time to initiate the backup.