Viewing 8 posts - 1 through 9 (of 9 total)
ok, well i am thinking of moving to a shared hosting enviroment for some dbs. with this it costs per mb of SQL space. so i idealy want the smallest...
June 23, 2009 at 3:26 pm
tosscrosby (6/23/2009)
will (6/23/2009)
we are getting there, thanks for all the help gail and others. its much appreciated.
so in order for me to 'start again' i should back up...
June 23, 2009 at 3:10 pm
ah ok...
we are getting there, thanks for all the help gail and others. its much appreciated.
so in order for me to 'start again' i should back up all files,...
June 23, 2009 at 2:52 pm
ahh now i get it! (i think)
each time the log file is backed up it reorganised the virtual files with in the log. Whilst not reducing the physical size on...
June 23, 2009 at 2:22 pm
GilaMonster (6/23/2009)
June 23, 2009 at 1:59 pm
OK thanks for the replies..
So if the backup of the transaction log does not reduce its size, how do others cope with log size? Do you do a full back...
June 23, 2009 at 10:02 am
GilaMonster (6/23/2009)
will (6/23/2009)
However some of my questions still remain..Specifically....
Other than backing up DBs currently, I do not run any other scripts for DB health/performance. Can you please advise what else...
June 23, 2009 at 9:22 am
should have done better search, found this article which is far better than Microsoft help: http://www.sqlservercentral.com/articles/64582/
However some of my questions still remain..
June 23, 2009 at 9:03 am
Viewing 8 posts - 1 through 9 (of 9 total)