Please Help!!
I have a 40GB DB with a Transaction Log File which grows even larger. I want the location of the log file on another drive. I have tried to detaching the DB and changing the location when I reattach the DB with no luck. Logfile continues to be in the same DIR as the DB. Can anyone please tell me how to change the location of the log file.
Thanks
I have a 40GB DB with a Transaction Log File which grows even larger. I want the location of the log file on another drive. I have tried to detaching the DB and changing the location when I reattach the DB with no luck. Logfile continues to be in the same DIR as the DB. Can anyone please tell me how to change the location of the log file.
Thanks