October 21, 2009 at 10:26 pm
Hi, experts can u pls reply immediatly.
I have 2 production servers, which have SQL SERVER 2005 Enterprise Edition. Two servers are connected in Active/Passive cluster mode.
My requirement is I have to move TEMPDB database log file (templog.ldf) from D:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\templog.ldf
To F:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\templog.ldf.
templog.ldf size is 2gb.
TempDB contains 1 tempdb.mdf file, 7 .ndf files and 1 templog.ldf file
Do I need to restart the server once I moving the file to another disk drive?
Please help me by giving the solution. Thanks in advance.
October 22, 2009 at 12:28 am
You need to do is to restart SQL Server
October 22, 2009 at 12:45 am
How to move
My requirement is I have to move TEMPDB database log file (templog.ldf) from D:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\templog.ldf
To F:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\templog.ldf.
templog.ldf size is 2gb.
Thanks in advace
October 22, 2009 at 5:45 am
BOL actually describes this process.
use alter database ...modify file syntax.
stop\start SQL
delete tempdb log file in old location
---------------------------------------------------------------------
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply