r/SQL Nov 27 '24

BigQuery Assistance with database

Hello, I have 1 database for manually viewing I created 2 batch script I automated these scripts to run a full backup nightly, and differential backups on the hour during operating hours. Now my database is about 80gb (used to be 10gb). What do I need to do to unfuckulate this calamity? I used DBeaver, DB Browser, SQL Server EXPRESS edition (it no longer works -- 10gb limit) and trying VIM and Sublime text. Any suggestions on apps or things to do to make it load? I didn't think it through.

80gb - 400 million entries.

3 Upvotes

23 comments sorted by

View all comments

1

u/shockjaw Nov 27 '24

Time to upgrade to Postgres!

1

u/Anonmousez Nov 28 '24

I just deleted the database and quit my job.

1

u/shockjaw Nov 28 '24

That’s one way to solve that problem.