Tuesday, March 27, 2012

Data File and Log File

In our current scanario log and data file on the same drive, I want to move
the log file into another drive for optimization and database is in use. how
can I
Current Scanario :-
MyDB1_DATA 1C:\MSSQL\data\MyDB1.mdf
MyDB1_TLOG 2C:\MSSQL\data\MyDB1.ldf
Desiring Scanario
MyDB1_DATA 1C:\MSSQL\data\MyDB1.mdf
MyDB1_TLOG 2D:\MSSQL\data\MyDB1.ldf
>> I want to move the log file into another drive for optimization and[vbcol=seagreen]
You cannot do this while the database is in use. One easy alternative is to
detach the database and move the log file to the new drive. When you attach
the database to the server, specify the new location of the logfile.
Anith

No comments:

Post a Comment