i'm facing a problem that i have to shrink ldf file on sql 2008 because it's way too big now (2gb) .
unfortunately, somehow.. the shrink methode (DBCC) not working the way it should.
i have to shrink it otherwise my database server repository reach its max capacity.
i found a way to shrink it..(exactly.. replace it with a new ones) by doing this :
sp_attach_db @dbname = N'databasename', @filename1 = N'D:\Data\databasename.mdf'
(taken from http://social.msdn.microsoft.com/forums/en-US/sqldatabaseengine/thread/98a70bc6-7fbe-4b1d-8c8e-90ca0639a884/)
the purpose the make it small is achieve. but i dont know the effect in doing this..
anybody have experiece with it? please share to me...
thanks
No comments:
Post a Comment