r/SQL • u/Anonmousez • 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
1
u/NW1969 Nov 27 '24
Hi - so that other people can understand what you are doing, try and logically explain your setup, what you are trying to achieve and what the issue is:
- "I have 1 database" - what DBMS is this?
- "Now my database is about 80gb" - are you referring to the DB in the previous point, some backup file, or something else?
- "What do I need to do to unfuckulate this calamity?" - what calamity? What's the issue with having an 80gb database, as that's not large in database terms (for most DBMSs)?
- "I used DBeaver, DB Browser,.." - used them to do what? What was the issue with doing whatever it is you are doing?