InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 15:45:00 GMT20http://www.sqlservercentral.com/Forums/Topic623559-360-1.aspxWell, some manuals (especially these days) aren't very good. But the 'softies really did a nice job with SQL Server's BOL! Most people don't know that. I have it open 24/7 on my laptop. I sure do miss the old days though, where you could get nice hard-copy manuals though. Gosh - that sounds SOOOO old school! :cool:Mon, 22 Dec 2008 08:37:53 GMTTheSQLGuruhttp://www.sqlservercentral.com/Forums/Topic623559-360-1.aspx[quote][b]TheSQLGuru (12/21/2008)[/b][hr] PLEASE check Books Online before posting questions! [/quote]Read the manual? What a radical, way out idea!Mon, 22 Dec 2008 00:43:39 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic623559-360-1.aspxNah... too much work, Kevin. ;)Sun, 21 Dec 2008 17:15:39 GMTJeff Modenhttp://www.sqlservercentral.com/Forums/Topic623559-360-1.aspxI post this for the benefit of others who may search the forums: PLEASE check Books Online before posting questions! It is a WONDERFUL resource! I put 'tempdb' in the index and voila, there was a clickable link 'moving', which took me directly to everything you need to know about moving the tempdb. :)Sun, 21 Dec 2008 17:07:40 GMTTheSQLGuruhttp://www.sqlservercentral.com/Forums/Topic623559-360-1.aspxUse ALter database with Modify file option to move the tempdb database and do an instance restart.FOllowing links would be helpful.[url]http://www.sqlservercentral.com/articles/Administration/63568/[/url][url]http://support.microsoft.com/kb/187824[/url]or in BOL ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/72bb62ee-9602-4f71-be51-c466c1670878.htmSun, 21 Dec 2008 05:04:06 GMTps.http://www.sqlservercentral.com/Forums/Topic623559-360-1.aspxThanks...will try the same.Sun, 21 Dec 2008 04:57:07 GMTJoy Smith Sanhttp://www.sqlservercentral.com/Forums/Topic623559-360-1.aspxYou can do it by running alter database statement. You can look at the script .that I’ve added as an example. Unfortunately you'll have to restart the service. Without restarting the service, tempdb will continue to work from its current position.use mastergo--Change the location of the data file. .Alter database tempdb modify file (name = tempdev, filename = 'D:\MyTempDBDir\tempdb.mdf')Go--Change the location of the log file. Alter database tempdb modify file (name = templog, filename = 'E:\TempDBLogDir\templog.ldf')go Don't forget to use the real path and not the path in this example.AdiSun, 21 Dec 2008 04:50:00 GMTAdi Cohn-120898http://www.sqlservercentral.com/Forums/Topic623559-360-1.aspxDear All, I want to change the location of my tempDB data base.How can I dot it..? I also want to do it without stopping SQL Server..Is it possible..? Please guide.Thanks in advance.Santhosh.Sun, 21 Dec 2008 04:14:39 GMTJoy Smith San