Originally the database on this server was set up so that the data and the transaction log files were on the same drive, now I want to move the transaction log files to another drive on the same server. Can anyone tell me if this can be done and how? Thanks in advance!
--
Message posted via http://www.sqlmonster.comEasiest is most probably sp_detach_db, copy the file, sp_attach_db (specifying the new location for
the log file), verify all ok, delete the original log file. And, of course, a database backup first.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"SHEILA ROSCOE via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:15a5e29bb5934836a7a979b030b98e00@.SQLMonster.com...
> Originally the database on this server was set up so that the data and the transaction log files
> were on the same drive, now I want to move the transaction log files to another drive on the same
> server. Can anyone tell me if this can be done and how? Thanks in advance!
> --
> Message posted via http://www.sqlmonster.com
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment