I host a
SQL Server Enterprise 2016 + Windows Server 2016 DataCenter on google compute engine. I’m going to use
.bak file on my google cloud storage (GCS) bucket, to restore database on other folder on GCS bucket (In other words: I want my DB’s mdf and ldf are locate in GCS bucket).
First, I use ExpanDrive to mount my GCS bucket as a drive in my local computer.
Then I use
XP_CMDSHELL in SSMS to set a connection between SSMS and drive, but I can’t connect to my GCS bucket in SSMS.
--open xp_cmdshell EXEC sp_configure 'show advanced option', '1'; GO RECONFIGURE GO EXEC sp_configure 'xp_cmdshell', '1' RECONFIGURE WITH OVERRIDE GO --execute cmdshell EXEC XP_CMDSHELL 'net use Z: \mypc\Google Storage /USER:user mypd'
Is there any possible solution that I can finish this job? Any help will be thankful.