Thursday, February 9, 2012

About change log file folder after database was created

Hi Guys,
Can I change log file folder after database was created? I want to move log
file to other folder, how do I do? Thanks.
You could use detach and attach:
http://msdn2.microsoft.com/en-us/library/ms187858.aspx
Alternatively if you have just made a backup you could use RESTORE with
MOVE. Please look at example D here:
http://msdn2.microsoft.com/en-us/library/ms186858.aspx
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

No comments:

Post a Comment