Can anyone tell me if there are Web Space Providers, who support MSDE and ASPX?
Thanks for Information!
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
Do you mean they provide you with a server?
If so why msde?
see
http://www.webhost4life.com/hosting.asp
"SqlJunkies User" wrote:
> Can anyone tell me if there are Web Space Providers, who support MSDE and ASPX?
> Thanks for Information!
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
>
Showing posts with label space. Show all posts
Showing posts with label space. Show all posts
Monday, March 19, 2012
Friday, March 9, 2012
MSDE
I looking for some guidance here. I have database which has exceeded the 2 gig limit. I deleted some old tables in an attempt to acquire some space. This worked out. However when I look at the size of my *.mdf it still appears in excess of the 2 gigs . I know this isn't true since I deleted 500 megs of stuff. How do i reclaim the space (get the file size to report correctly) or do I need to even worry about it.
Andy
AndyYou might try first backing up the database and then running the "Shrink" command. In Enterprise Manager Select the database, right click and select "Shrink..." from the list of commands. If you don't have Enterprise Manager you can try this command through osql or equivalent.
|||Thanks for your reply and help. I was just about to attempt it when I realized from reading another article on the subject than MSDE dynamically recalculates and adjusts files and indices. Turns out all I had to do was be patient and it took care of itself. This apparently is different functionality from the full blown version of SQL2000. Anyhow, thanks
DBCC SHRINKDATABASE ([YourDatabaseName], 0)
Andy
Wednesday, March 7, 2012
msdbdata.mdf file is over 5 GB, cannot shrink it
I have problem with my sql server developer edition.
I began reciving alerts regarding disk space, and found out that the msdb files are 5 GB!!! the data file is full, so I cannot shrink it, but the table usage shows only a few MB used by tables.
its not advisable to shrink the system dbs except tempdb,but in your case just check if any user tables are created in msdb if so just delete the same to free diskspace.... then try shrinking msdb but b4 shrinking ensure you have the latest backup of all the dbs....|||
There are no user tables on this server.
It a local developer version, I use for development and small checks, there is no back up nither.
Subscribe to:
Posts (Atom)