July 1, 2003 at 2:29 pm
Is there any way to move transaction log from One Location to Another i.e changing the directiory where Transaction log reside.
Being new to SQL-2000 having hard time to figure how to do that
I was trying to truncate the log by running sp_detach_db
Sp_attach_db ( it creates log in the same directory where DB resides)
any help will be appreciated
July 1, 2003 at 3:57 pm
Missing one step between
-- Put the DB in Offline mode
-- Detach the database using sp_detach_db
-- Move the OS files to the new location
-- Attach the db using sp_attach_db by specifying the new location
-- Put database in multi user mode
Edited by - Shas3 on 07/02/2003 12:16:37 PM
Shas3
July 3, 2003 at 3:21 am
When I've tried doing this it puts the log file in the same dir as the data file. Can you use this method to attach the database with the log and data files in seperate locations?
thanks
July 3, 2003 at 4:29 am
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply