SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 regarding the temp db
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

amitsharma
Starting Member

India
2 Posts

Posted - 06/18/2008 :  06:15:02  Show Profile  Reply with Quote
hi i have created sfdata databse having craores of records in the table. now when i trying to insert some data in some tabel in sfdata databse, the sql server 2005 increses the size of mdf file on tempdb databse and becuse of thiis my c drive gets full. why thiis is incresing the size of tempdb databse mdf file however tehre no link b/w the databse i am working and the tempdb database. how can i remove the .mdf file of tempdb file

RickD
Slow But Sure Yak Herding Master

United Kingdom
3608 Posts

Posted - 06/18/2008 :  06:41:33  Show Profile  Reply with Quote
Put it this way, if you try to remove TempDB, you are no longer going to have a useable SQL Server.

It really does depend on what you are trying to do for the insert. TempDB is used to store any information to make processing faster, obviously you are trying to insert far too many rows in one transaction and this is what is causing your problems. Try splitting your insert into batches.
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 06/18/2008 :  21:50:40  Show Profile  Reply with Quote
How did you insert data? That shouldn't cause tempdb grow like that usually.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 06/19/2008 :  03:12:46  Show Profile  Reply with Quote
quote:
Originally posted by amitsharma

hi i have created sfdata databse having craores of records in the table. now when i trying to insert some data in some tabel in sfdata databse, the sql server 2005 increses the size of mdf file on tempdb databse and becuse of thiis my c drive gets full. why thiis is incresing the size of tempdb databse mdf file however tehre no link b/w the databse i am working and the tempdb database. how can i remove the .mdf file of tempdb file


Are you using temporary tables in your query and putting lots of data to them?
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000