SQL Server Performance Forum – Threads Archive
move a log fileHello
I 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.
If this is in simple recovery mode, what do you want to do with the log file anyway? ———————–
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? ———————–
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
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.