|
ganeshkumar08
Posting Yak Master
India
187 Posts |
 Posted - 04/27/2009 : 01:50:29
|
Hi,
I have a problem in shrinking a log file in sql server2005.
Below is the code i used to shrink log file.
USE Master
GO
DBCC SHRINKFILE('F:\Central Repository\Kandasamy\DB 24-09-2008\CricTestData_1.ldf', 1)
BACKUP LOG CricTestData WITH TRUNCATE_ONLY
DBCC SHRINKFILE('F:\Central Repository\Kandasamy\DB 24-09-2008\CricTestData_1.ldf', 1)
GO
after running the above code, error is displayed as below
Msg 8985, Level 16, State 1, Line 1
Could not locate file 'F:\Central Repository\Kandasamy\DB 24-09-2008\CricTestData_1.ldf' for database 'master'.
Msg 8985, Level 16, State 1, Line 3
Could not locate file 'F:\Central Repository\Kandasamy\DB 24-09-2008\CricTestData_1.ldf' for database 'master'.
Can any one please help me in shrinking log file. due to that problem i was not able to insert data in the table.
Thanks
Ganesh
Solutions are easy. Understanding the problem, now, that's the hard part |
|
How to shrink log file in sql 2005
