Unable to Shrink Database - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Unable to Shrink Database

Author

Topic

Kovanan
Starting Member

3 Posts

Posted - 2012-02-28 : 07:00:45

Hi,
I have a windows 2003 R2 Server and Database is SQL 2000. Now I want to shrink Log.ldf file as the size of the files are increasing day by day.
But when I try to shrink the database with following command

DBCC SHRINKFILE(wslogdb63_log,1)
BACKUP LOG wslogdb63 TO DISK='D:\wslogdb63.bak'
DBCC SHRINKFILE(wslogdb63_log,1)

it gives the below mentioned error
Server: Msg 8985, Level 16, State 1, Line 1Could not locate file 'wslogdb63_log' in sysfiles.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Processed 2117 pages for database 'wslogdb63', file 'wslogdb63_Log.ldf' on file 1.
BACKUP LOG successfully processed 2117 pages in 0.316 seconds (54.860 MB/sec).
Server: Msg 8985, Level 16, State 1, Line 3Could not locate file 'wslogdb63_log' in sysfiles.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Can anybody help me to solve the issue..
Thanks in advance.

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2012-02-28 : 07:08:48

Firstly, shrinking logs is not a good idea. Shrinking logs regularly is even worse.
Please read through this - [url]http://www.sqlservercentral.com/articles/64582/[/url]

Are you running that from the database that contains that file?

--
Gail Shaw
SQL Server MVP