question

Jsx03-0598 avatar image
0 Votes"
Jsx03-0598 asked EchoDu-MSFT commented

Store SQL server database or table on Google drive or SharePoint?

I'm using SQL server and want to create a new database to house some really big data. a few million rows of data and it's way too big to put in a flat file or load into Excel because I have to update it all the time and it just takes 20 to 30 minutes to change anything




I'm considering using Microsoft SQL server since our company has that. But I want the database or the table to be stored in Google drive so that if I'm out on vacation or if I ever leave the company, someone else can just pick up where I left off and continue editing the database table


Any ideas how this would be possible? To store a database or table in a shared network drive?

sql-server-generaloffice-sharepoint-online
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @Jsx03-0598 ,

Would you tell me whether your issue has been resolved or have any update?
I am looking forward to your reply.

Have a nice day!

0 Votes 0 ·
ErlandSommarskog avatar image
1 Vote"
ErlandSommarskog answered pituach edited

You cannot put the database directly on Google drive - the database must be on a disk directly attached machine SQL Server runs on.

The normal procedure in a company is that you have one or more central servers that many users have access to, so you can easily share your database that way. Or you could have the database in a cloud service that your company uses.

Talk to your IT guys for more details.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

You cannot put the database directly on Google drive

Actually, you can. It is a VERY bad idea (maybe even really a stupid idea), it surly not fit for production and it surly can be considered as hacking, but it can be done 🤣

How?


First you map Google drive as network drive and give it a disk later (there are multiple apps that provide this option which we can find by searching google). Next you can use the same trick I showed back in 2013 in my post about shrink SQL database during restore (using symbolic link to the network drive).



0 Votes 0 ·
trevorseward avatar image
0 Votes"
trevorseward answered

This wouldn't be an appropriate use of either technology. You need a database of some form, be it SQL Server (Azure SQL, Azure SQL Managed Instance, MS SQL Server) or a form of NoSQL, such as an Azure Storage Account or CosmosDb, and so on.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

EchoDu-MSFT avatar image
0 Votes"
EchoDu-MSFT answered

Hello @Jsx03-0598 ,

I agree with trevorseward and ErlandSommarskog.

You can not store SOL databases in Shared Network drive or Google drive.

Here is an article that may help you.

Thanks,
Echo Du
================
If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.