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
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.
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?
regarding the temp db
Posted - 06/18/2008 : 06:15:02
