I am trying to shrink the log file on my database (TG1). I am using GP10 with SQL Server 2000.
When I run "select name from sysfiles" I get:
GPSTG1Dat.mdf
GPSTG1Log.ldf
If i run "Backup Log TG1 with truncate_only" it says it successfully executes
If I run "DBCC Shrinkfile(GPSTG1Log,1000)" I get an error
"Could not locate file 'gpstg1log' in sysfile"
HELP!!! I am running out of disk space
*This post is locked for comments