Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Post History
My project has the following set up for the production and preproduction ("clone") environment. Production is not accessible at all for the development team, only the preproduction database. Pr...
#2: Post edited
by
Alexei
·
2020-11-05T19:50:19Z (about 4 years ago)
added the question
#1: Initial revision
by
Alexei
·
2020-11-05T19:49:51Z (about 4 years ago)
How can I can I reduce the size of a SQL Server database after being restored and massive embedded files stripped?
My project has the following set up for the production and preproduction ("clone") environment.
- Production is not accessible at all for the development team, only the preproduction database.
- Preproduction database is restored each day, but a post-restore script is run to strip away sensitive data such as embedded files (VARBINARY(MAX)) and e-mail addresses
- This process leaves a preproduction database of about 50GB with 46GB available space which means that a lot of space is wasted