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 .
Showing posts with label logfile. Show all posts
Showing posts with label logfile. Show all posts
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 .
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:
Posts (Atom)