We are running SQL Server 2008 R2 every night we backup our SQL DB's. Last night it failed as a result of no Disk space. I noticed that D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA folder is a Terabyte in size and appears to be the culprit. Can something be done to either shrink these files or possibly remove them?
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.