I have inherited a SQL Server environment that was haphazardly installed and
managed. I am in the process of trying to apply some form of structure to t
his environment. Currently all data and log files reside in the default data
directory. I am moving the
log files to a separate directory on a different drive. I know I can use sp_
detach_db and sp_attach_db to move the log files, but how can I move the log
files for master, msdb, model, and tempdb?
Any help would be greatly appreciated.http://www.databasejournal.com/feat...cle.php/3379901|||Erik,
Thanks for the reply. This was exactly what I was looking for.
"erik perez" wrote:
> http://www.databasejournal.com/feat...cle.php/3379901
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment