I have recently been challenged with the following issue:
1.I wanted to have a backup of one of our clients SQL Server database.
2.The only available information was the IP address of the SQL Server instance. The sql login and password. (the login has the system administrator role)
I researched for a while on the web with no success for easy solution. So I decided to work on my own.
1. Execute “net use” command to map a network drive (local computer):
2. Execute the backup (via SQL Management Studio) and copy the file name in your clipboard for the next step.
3. Use the backup file name with the following T-SQL statement:
If you have further questions feel free to comment below!