Otdfbt

Multi tool use

Python program for fibonacci sequence using a recursive function

What is the recommended procedure to land a taildragger in a crosswind?

Is there a simple example that empirical evidence is misleading?

What are nvme namespaces? How do they work?

Shorten or merge multiple lines of `&> /dev/null &`

Is keeping the forking link on a true fork necessary (Github/GPL)?

Why is unzipped directory exactly 4.0k (much smaller than zipped file)?

Why A=2 and B=1 in the call signs for Spirit and Opportunity?

Why did Jon Snow do this immoral act if he is so honorable?

Why does the Starter Set wizard have six spells in their spellbook?

If I arrive in the UK, and then head to mainland Europe, does my Schengen visa 90 day limit start when I arrived in the UK, or mainland Europe?

Did this character show any indication of wanting to rule before S8E6?

Time complexity of an algorithm: Is it important to state the base of the logarithm?

The Maltese Falcon

Is "vegetable base" a common term in English?

Of strange atmospheres - the survivable but unbreathable

Are there any German nonsense poems (Jabberwocky)?

What does it mean when a vocal teacher tell you that your lowest notes are heavy?

Security vulnerabilities of POST over SSL

How would a developer who mostly fixed bugs for years at a company call out their contributions in their CV?

Why does splatting create a tuple on the rhs but a list on the lhs?

What tokens are in the end of line?

How did NASA Langley end up with the first 737?

Does French have the English "short i" vowel?

Connect google cloud storage bucket in MSSQL(2016)

Google Cloud Storage mount on windowsgoogle-cloud storage bucket mounted to docker serviceGoogle Cloud Storage Transfers FailingIs Google Cloud Storage expensive?Lost Permissions to Google Cloud Storage BucketBacking up Google Cloud Storage BucketParallel downloads in Google Cloud StorageGoogle Cloud Bucket connection from Kubernetes deployment using Storage APIIs there a way to mount my Google Cloud storage account on Windows Server 2016?Google Cloud Storage Bucket cant delete files as project admin and storage admin

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

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: \mypcGoogle Storage /USER:user mypd'

Is there any possible solution that I can finish this job? Any help will be thankful.

windows-server-2016 mount google-cloud-storage sql-server-2016

share|improve this question

asked May 10 at 3:35

swchenswchen

12

add a comment | 

0

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: \mypcGoogle Storage /USER:user mypd'

Is there any possible solution that I can finish this job? Any help will be thankful.

windows-server-2016 mount google-cloud-storage sql-server-2016

share|improve this question

asked May 10 at 3:35

swchenswchen

12

add a comment | 

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: \mypcGoogle Storage /USER:user mypd'

Is there any possible solution that I can finish this job? Any help will be thankful.

windows-server-2016 mount google-cloud-storage sql-server-2016

share|improve this question

asked May 10 at 3:35

swchenswchen

12

--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: \mypcGoogle Storage /USER:user mypd'

share|improve this question

asked May 10 at 3:35

swchenswchen

12

share|improve this question

asked May 10 at 3:35

swchenswchen

12

asked May 10 at 3:35

swchenswchen

12

asked May 10 at 3:35

swchenswchen

12