hello
i have one doubt.can anybody clarigy it.
every time i am doing my database shrinking manually.
what i am asking i find out every time when i shrink my database that sql is showing minimum size of database to shrink.how can its getting minimum size
but i need to find out how to get minimum size of particular database programatically.
thanx
excuse my poor english
"every time i am doing my database shrinking manually."
Bad planning. Disk is cheap. You probably don′t backup your database acording to the recovery model of it.
Shrinking database files drives to disk fragmentation on it, witch goes to low performance. Never think about "shrink" as one of the "best pratices".
Marcelo
|||Kiran - see the answer I posted in the getting started forum ...|||
where you posted rod colledge
can u send me that url?
No comments:
Post a Comment