My client has a SQL Server 2000 which we are trying to upgrade. In the meantime, the Server is running out of space and I am trying to understand the size of the database.
When I check the size
select name , (size*8)/(1024.) AS SizeInMBs
The data is 900 MB and the Log is 110 GB. I have these questions:
So what is the size of that database? Should I consider the Log size?
Can the log file be truncated without risk of data loss?
Will deleting old records from the Database help reduce the log size?
The recovery model is FULL. Will we lose any data if I change it to SIMPLE? If not, once I change it to simple, will it reduce the current log size or just avoid it from growing much going further?