1,275
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.
#1
André Arnaud de Cal...
291,391
Super User 2024 Season 2
#2
Martin Dráb
230,445
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
