SQL Server Performance Forum – Threads Archive
move a log file
HelloI want to move a log file from SQL server 2000 standard Ed to another drive. The SQL server DB is in simple recovery model. I don#%92t use SP_DETACH_DB and SP_ATTACH_DB concept. I wonder if there is some another solution for it.
Thanks
Arp
If this is in simple recovery mode, what do you want to do with the log file anyway? ———————–
–Frank
http://www.insidesql.de
———————–
Then I‘m going to change the SQL server DB in full recovery model.
quote:Originally posted by FrankKalis
If this is in simple recovery mode, what do you want to do with the log file anyway?
———————–
–Frank
http://www.insidesql.de
———————–
–Frank
http://www.insidesql.de
———————–
What do you mean you "don’t" use detach and attach? This sort of thing is PRECISELY what it is there for? Are you ideologically opposed to it? Tom Pullen
DBA, Oxfam GB
True and there is no other process or option to move the Log file alongwith data file, any process uses the same method of detach and attach. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>