create another Tempdb without stoping SQL

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

create another Tempdb without stoping SQL

Author

Topic

kristinaRR
Starting Member

5 Posts

Posted - 2007-10-22 : 08:38:17

Hi to all

In sql server there is a query that is making tempdb full.
What I want is resoling this problem but without stoping sql server?

Thanks in advance,

kristinaRR

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-10-22 : 08:40:16

Rewrite query.

E 12°55'05.25"
N 56°04'39.16"

kristinaRR
Starting Member

5 Posts

Posted - 2007-10-22 : 08:47:24

Hi

Query has like'%' that is making tempdb full.
What i want is create another tempdb1 that will have the role of tempdb and then delete this tempdb and make tempdb1 by default TEMPDB but without restarting sql server at all.

Thanks

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-10-22 : 08:48:35

you can't do that.

the only thing you can do is to rewrite the query logic to something better.
show us the query and we can help you.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com

Kristen
Test

22859 Posts

Posted - 2007-10-22 : 10:43:13

"that is making tempdb full"

Increase size of TEMPDB ?

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-10-22 : 21:24:37

If it's disk space issue, you can move tempdb to big disk or just add another data file in it.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-10-23 : 01:48:47

But if the query is badly written OP will probably fill second tempdb as well.