August 26, 2005 at 12:03 am
My Live Database get detached from server daily.
this problem occured after using dbcc shrinkfile .
I used this with the aim to shrink the log file
I dont know what will be the problem.
Pls Help me.
Being the database is live one,the problem is very serious
August 26, 2005 at 5:00 am
the auto close option of the database is on?
August 26, 2005 at 5:39 am
No,the autoclose option is not set to on
August 26, 2005 at 7:33 am
Why do you shrink the file daily ?
What is the command you are using to shrink the file ?
August 26, 2005 at 10:58 pm
I am not shrinking the file daily.
only once i used dbcc shrink file to shrink the log file.
From the next day onwards we find that the database gets detached daily morning from the server.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply