Dear All,
I got this error in one of our store...they unable to login to the database...
I check the status of the database thru SQL Server Enterprise Manager...there I found out that under database-->mystore(suspect) and no items is shown...like table..views and etc..
I tried detaching it by it gives me error...even if I tried to delete it but if gives me error...the physical file is there.
Can someone help me sort the problem ??
Thnks in advance
See in event viewer if you have a SQL message on this problem.. (application and system messages.. can be bad sectors of your hard disks)
do you have all files of your database (mdf, ldf)?
cod
yup..I have...but I know the problem already....my database size exceeded 2g...
Either upgrade my sql database to sql express or delete store historical data.
"cod" wrote:
do you have the desktop engine on your store ? two gb is the limit of MSDE .. 4 for sql express!
cod
You can archive the database
I have only MSDE..desktop engine will be there..
what would be the procedure if i want to update MSDE to SQL Express ?
"cod" wrote:
get sql express from MS .. backup your database or if not possible.. detach database with OSQL command ...
exec sp_detach @dbname = 'YourDatabase' ..
move all files (or backup) in another folder.. remove from pc MSDE and install sql express..
from surface area configuration enable remote connection through tcp/ip and named pipe ..
after, get from MS the sql server management studio (it's free) and attach your files or restore the backup.
If you need more space, think to remove from Journal the old-receipts .. they are stored in blob fields ..
cod
we manage to change the status of the database-->from suspect-->emergency-->dbo-->then normal...but still the size of my data is almost 2gb.
after deleteling transactions(store administrator)...it free up some space...enough to survive for a day or two....
now, what other data I could delete to free up some space ? in item table, we have too many unwanted items ? but i tried doin the delete in item table (backup data) it doesn't free up some space but deleted only the records.
can someone show me how to free up some spaces in my database ?
thnkx
"Afsh> You can archive the database
we manage to change the status of the database-->from suspect-->emergency-->dbo-->then normal...but still the size of my data is almost 2gb.
after deleteling transactions(store administrator)...it free up some space...enough to survive for a day or two....
now, what other data I could delete to free up some space ? in item table, we have too many unwanted items ? but i tried doin the delete in item table (backup data) it doesn't free up some space but deleted only the records.
can someone show me how to free up some spaces in my database ?
thnkx
"Afsh > >
Have something to add? Share your thoughts — no account required.
Ask the community — no account required