|
| | | Junior Member
 
Group: Forum Members
Last Login: 7/11/2008 10:40:01 AM
Posts: 11, Visits: 17 |
| Harry - Try this..
USE yourdbname
EXEC sp_MSforeachtable @command1="EXEC sp_spaceused '?'"
This will output the number of lines and size of each table. I found that the tables with the most entries were not always the largest size wise.
Then start by doing a TRUNCATE on the statistical ping, and statistical interface tables, then you can compact the database. Do all this in the Microsoft tool. You will loose that data, but will gain control over your database.
|
| |
| | | 
Forum Guru
Group: Forum Members
Last Login: 2 days ago @ 10:16:06 AM
Posts: 51, Visits: 77 |
| | Our dB is now full, and WUG won't even let me load the console interface. Can you provide a quick step-by-step process on how to do what you're suggesting with truncating the statistical Interface and Ping tables so we can regain some dB access? Thanks! roberttroll (7/3/2008)
Harry - Try this..
USE yourdbname
EXEC sp_MSforeachtable @command1="EXEC sp_spaceused '?'"
This will output the number of lines and size of each table. I found that the tables with the most entries were not always the largest size wise.
Then start by doing a TRUNCATE on the statistical ping, and statistical interface tables, then you can compact the database. Do all this in the Microsoft tool. You will loose that data, but will gain control over your database.
------------------------------------------------------------
Bryan Harrell
Network Infrastructure - Tallahassee
Fla. Dept of Revenue
------------------------------------------------------------ |
| |
| | | Junior Member
Group: Forum Members
Last Login: 7/11/2008 10:40:01 AM
Posts: 11, Visits: 17 |
| I had zero luck whatsoever using the WUG console or command line.
In the microsoft tool simply type "TRUNCATE table tablename" - The two largest tables I had were the statistical interface and statistical interface ping. Start with those first then compact the database.
|
| |
| | |
Forum Guru
Group: Forum Members
Last Login: 2 days ago @ 10:16:06 AM
Posts: 51, Visits: 77 |
| | Ok, that's the command and it seems incomplete: 1. Where do I enter it in the MS tool (I'm not seeing any place I can just enter the command except as a query??). 2. The command you gave seems incomplete (missing a truncation point). Heck, right now, I'd even settle for purging the entire statistical dB so we could start out fresh... FWIW, Our WUGv12 server has been off-line now for over 5-days and I can distinctly hear the trampling of the hooves beating a path to my door demanding I get it back up. I called Support first thing Monday and got a support ticket in to find a solution to this, but so far, they haven't been very helpful with specific and concise instructions to be able to purge our dB, and when I called back this afternoon to get a status update, I was told the Tech "was so busy, that she hadn't even been able to get to my problem"... This is not a good thing IPSWITCH and there's got to be a better way to resolve this issue than truncating the dB tables! Why is IPSwitch so silent on this issue....<<??>> In the mean time, I've just about given up, and think I'm just going to restore the dB backup I made prior to installing the v12.0.2 patch to see if I can get it back up with total loss of any statistical information for the last week. roberttroll (7/4/2008)
I had zero luck whatsoever using the WUG console or command line.
In the microsoft tool simply type "TRUNCATE table tablename" - The two largest tables I had were the statistical interface and statistical interface ping. Start with those first then compact the database.
------------------------------------------------------------
Bryan Harrell
Network Infrastructure - Tallahassee
Fla. Dept of Revenue
------------------------------------------------------------ |
| |
| | | Junior Member
Group: Forum Members
Last Login: 7/11/2008 10:40:01 AM
Posts: 11, Visits: 17 |
| http://msdn.microsoft.com/en-us/library/aa260621(SQL.80).aspx
Syntax
TRUNCATE TABLE name -
Thats the command.. Thats it, nothing more.. Just replace "name" with the name of the table you want to truncate. Enter it as a query yes. |
| |
|
|