By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,412 Members | 1,630 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,412 IT Pros & Developers. It's quick & easy.

tempdb and templog - moving

P: n/a
Right now both of these reside on my C:, but templog is over 3 1/2 GB.

1) What do I need to do to move both of these to another drive on the
same system?

2) Is there an easy way to purge or compact templog, or just set a size
limit for it?

Thanks,
Scott

Jul 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Hi

Stopping and re-starting SQL Server should give you a new tempdb.

To move tempdb see http://support.microsoft.com/kb/224071/EN-US/

To shrinking a transaction log file
http://msdn.microsoft.com/library/de...r_da2_1uzr.asp

John

"Scott" <sp***@sayrevillek12.net> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...
Right now both of these reside on my C:, but templog is over 3 1/2 GB.

1) What do I need to do to move both of these to another drive on the
same system?

2) Is there an easy way to purge or compact templog, or just set a size
limit for it?

Thanks,
Scott

Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.