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 .
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment