Not MS SQL, but i needed another zone.
A file on my SQL server, sql2010.mdf has grown at a rate of 35GB per month and has reached 217GB. We have 10 GB left on the drive.
What can I do to get rid of this file or shrink it to a manageable size??? If we don't get this down, we will not be able to use our accounting software and will have to shut down until it's fixed. Any ideas?
Someone mentioned that I might need to run "BACKUP `databasename` WITH TRUNCATE_ONLY"
Will that help? Since I only have 10GB left, where will I store the Backup file? I'll have to install an new drive. Also, will I need to take the DB offline? and will it take 10 years to backup?