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
I got it to work by doing this:
Step 1:
backup log DBNAME with truncate_only
Step 2:
Right click on DB within Enterprise Manager > Shrink Database > Files
Button > Select log file > Specify size to shrink it to (I usually
select the minimum allowed size).
Make sure you have good backup for transaction log and Database before you do this. I think DBCC shrikfile is looking for Logical Name for Log file which is normally Databasename_Log. You can find this when you right click on Database name, go to properties, select files, you should the logical name for transaction log file.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,219 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156