I have a database I restored on a new hosting space. I worked a lot in this db before publish it. The mdf file is 37MB, the log file is 427 MB. I could have disk space problems with the hosting service, could I truncate the log file and then restoring the database again? And how could I do that?
Or maybe someone has suggestions on how to proceed?
Many thanks for your time.