all groups > sql server msde > december 2005 >
You're in the

sql server msde

group:

urgent help needed - space available 0.00 MB


urgent help needed - space available 0.00 MB maxzsim via SQLMonster.com
12/28/2005 8:32:00 AM
sql server msde:
Hi ,

I have this distribution database (created via replication setup).
I have set aside 200 MB for data file in E:\ drive & 20 MB in C:\ drive for
log file using simple mode recovery

on the properties --> General tab of distribition it shows
Size : 220.00 MB (from the data + log file)
Space available : 0.00 MB

Which space on the server is it actually refering to as i could see from
the Windows Explorer that all the drives have enough space and what'll be the
impact on the replication(so far i can see the replication is still
successfully) ?

kindly advise

tks & rdgs

--
Message posted via SQLMonster.com
Re: urgent help needed - space available 0.00 MB maxzsim via SQLMonster.com
12/29/2005 3:48:01 AM
Hi,

Running DBCC UPDATEUSAGE ('db name') --> this is from a previous posting,
has solved my problem

tks & rdgs

[quoted text, click to view]

--
Message posted via SQLMonster.com
AddThis Social Bookmark Button