I have a 5 year old SQL Server 2008 database. There are actually 3 databases
NL_Dev
NL_Test
NL_Prod
Each has a log file. We have been using the development database, but all three seam to be linked together. The .MDF
files are all about 3.2GB, but the dev log file is 450GB.
I was trying to shrink the files, but only had 10GB's of space left on the array.
I had a backup of NL_Dev
and didn't think it would make any difference to delete the test log, so I stopped SQL Server and deleted the test log File. It didn't make any size difference, but now I can't access the data in NL_Dev
.
I tried un-attaching the DB, but now I can't attach it since the file is missing.
I am not a DBA, just a small business owner that has worked with Access and SQL Server for 20 years, and I've run out of rope to hang myself. Please Help
Gordon Mills Newlife Electronics