|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Stop making mediocre tutorials.The best tutorials are video! Camtasia Studio makes it easy to create engaging, buzz-building screen videos at any size, in any popular format. Download the free trial!
|
|
#1
April 12th, 2004, 10:32 PM
|
|||
|
|||
Purge tempdb
The tempdb file grew to such an extent that it is not allowing tables to be created. It throws Error 1101 stating that there is no space on tempdb.
So, I want to create a purging script to purge the existing tempdb transaction logs. HELP!
|
|
#2
April 13th, 2004, 03:40 PM
|
|||
|
|||
|
one easy way is to re-start the server, cuz each time you do it, the tempDb is recreated ,
BUT you should have enough space for it, IT is highly important to have enough space, otherwise your WHOLE system will be slow down. put a limit, but expand the tempdb
|
|
#3
April 15th, 2004, 01:08 PM
|
|||
|
|||
|
Hi Sypher,
Yeah I tried but the tempdb was on autogrow and it's ended up occupying 4000K+...my project involves working with tables that contain 2.2M records...so this is something to be expected. The transaction log has taken record of each event that I have ever committed and that's what is occupying space..so I need a script that would purge or compress the prior logs and make room for new ones. I found a command "dump transaction from tempdb with no log"..didn't work...i think the tables' name or something needs to be included instead of transaction but I'm not sure of the command. Can someone help me if they know the correct command ?? Thanks.
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > Purge tempdb |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
