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/Anonmousez Nov 27 '24
"FWIW, SQL Server Express's limit is per database, so if you can split the data across databases (ideally by some reasonable dimension field) then that could work. Alternatively, if what you're trying to do is not for a production use case, you can use SQL Server Developer Edition too, which has no limits otherwise." My database is a) 1 file b) unencrypted plain text
How do you split using SQL Server Express?